Comments by Shafiul Alam (Top 14 by date)

Hi Maciej Los, Thank you very much for your time. I updated the SQL as you suggested and it works great :)

Thank you very much.

Hi Thanks for your suggestion on Parametrized queries, But i dont know about that. Can you please share some resources/Links. Thanks a lot for you time.

Hi Anand,

Apology, if I miss something. Its says DataBind is not a property of DataGridView. I was using Below instead. a msg popup after one table loaded and ten next and then next. Please help me to load the entire thing at once.

Dim xmlreader As New XmlTextReader("E:\New folder\Desktop\Desktop\TEST FILE\TEST FILE\Testing XML Files_V19.Sep\4578279_FMRepProdOrder_WMB_GMC20131113 212209.191821.xml")
Dim ds As New DataSet()
ds.ReadXml(xmlreader)
''xmlreader.Close()

For i = 0 To ds.Tables.Count - 1
DataGridView1.DataSource = ds.Tables(i)
MsgBox("Table Loaded")
Next

Dim dt As New DataTable()
dt.Columns.Add("FirstName", GetType(String))
dt.Columns.Add("LastName", GetType(String))
dt.Columns.Add("UserName", GetType(String))
dt.Columns.Add("Role", GetType(String))
Dim xmldoc As New XmlDocument()
xmldoc.Load("C:\Users\Shafiul Alam\Desktop\SampleXML.xml")
Dim nodeList As XmlNodeList = xmldoc.SelectNodes("/users/user")
For Each node As XmlNode In nodeList
Dim dtrow As DataRow = dt.NewRow()
dtrow("FirstName") = node("FirstName").InnerText
dtrow("LastName") = node("LastName").InnerText
dtrow("UserName") = node("UserName").InnerText
dtrow("Role") = node("Job")("Role").InnerText
dt.Rows.Add(dtrow)
Next

Hi Anand, Thanks for the link. it works. Below is the code. Here I need to specify all the Columns, but in my XML Collection, columns are not fixed. Is there any way I can load all the available columns, without specifying the column names.

Thanks a lot, It works great.

I have 3 textbox, 2 for Simple Text and one for Date.

Hi this code works fine. Not working, if TextBox2 value is date. Showing "Syntax Error: Missing Operand After (Column Name) Operator"

What need to be done differently?

Hi Thanks, I just found the right code

dt.DefaultView.RowFilter = String.Format("[LabelRef] Like '{0}%'", Me.TextBox2.Text.Trim())