how to bind gridview using

[nileshbahirshet]

I am devloping an application in which I wan to bind gridview using xml data which comes from database .. How can I bind the gridview using SqlAdapter and dataset objects ? I have following code but it doesnt make column as per xml data in grid view It shows all data into single column .. I dont know whether I am make some mistake in inserting or retrving the data... Whether I have to store the xml as document type or as storage type ? I have following code which I use to bind the grid view ... Dim sqlString As String = "Data Source=ADSERVER\..........." Dim sqlConnection As New SqlConnection(sqlString) Dim xr As Xml.XmlReader Dim ds2 As New DataSet Dim dt As DataTable sqlConnection.Open() Dim cmd As New SqlCommand("Select data from xmlTest where PKID=63", sqlConnection) xr = cmd.ExecuteXmlReader() ds2.ReadXml(xr, XmlReadMode.InferSchema) dt = ds2.Tables(0) VGridControl1.DataSource = dt Which displays the in the single column as it is in database...

[Brij]

Have you checked you dt,That it is having single column as DB or according to your XML schema?

Cheers!! Brij