Using XML and VB .NET without any other databases or Query languages.

henry_gogogo

I must be the only one around that wants to make a Windows program just for the desktop using VB .NET and XML. And do not want to use SQL, OLEDB, ODBC, Access. I just want to use XML to store the Data, read the Data into a DataGrid, add or delete rows, and edit the rows then write the changed Data back to the file. So far I have an XML file, an XSD file, a form with a DataGrid, I have made a DataSet with the following line of code Dim dsContacts As New DataSet("contacts") I placed a mainmenu control on the form and use menuitem3 as below. Which populates the DataGrid. Now I understand I have to have a DataTable to be able to do anything with the data. I have read the help files in VB .NET but the more I read them the more confused I get. Can someone please tell me how to make a DataTable using the information below to construct it? 'This code populates the DataGrid Private Sub MenuItem3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles MenuItem3.Click Me.DataGrid1.Visible = True 'Reads the data from the contacts.xml file dsContacts.ReadXml(Application.StartupPath & "\contacts.xml") With DataGrid1 .DataSource = dsContacts .DataMember = "contacts" .CaptionText = .DataMember End With End Sub ------------------------------------------------------------------------------------------------------------------------ This is the file containing the Data. The name of the file is contacts.xml. White Johnson 10932 Bigge Rd. Menlo Park CA 94025 408 496-7223 Green Margie 309 63rd St. #411 Oakland CA 94618 415 986-7020 Carson Cheryl 589 Darwin Ln. Berkeley CA 94705 415 548-7723 Hunter Anne 22 Cleveland Av. #14 San Jose CA 95128 408 286-2428 Straight Dean 5420 College Av. Oakland CA 94609 415 834-2919 ----------------------------------------------------------------------------------------------------------------------- This is the Schema file named contacts.xsd.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

nkumari22y ago
I have made a datagrid in which i have put certain controls like textbox, combo box etc and these are being populated from the xml file. Now, depending upon the value entered/ selected in the controls placed on the datagrid ,i want to modify the xml file. Moreover, i want to build this in C#.So, could you help me in solving it. Thanks a lot
+1
anoo_paturi22y ago
'declare datatable Dim myTable As New DataTable 'declare columns Dim mycol1 As New DataColumn Dim mycol2 As New DataColumn 'specify the column type With mycol1 .ColumnName = "Column1" .DataType = Type.GetType("System.String") End With With mycol2 .ColumnName = "Column2" .DataType = Type.GetType("System.Int32") End With 'add columns to datatable With myTable .Columns.Add(mycol1) .Columns.Add(mycol2) End With 'declare a row Dim DRow As DataRow 'now loop through your XML doc and retrieve the data 'u need and place these 2 lines at the appropriate location : : DRow = myTable.NewRow myTable.Rows.Add(DRow) : : 'declare a new dataset Dim TablesDS As New DataSet 'Add DataTable to DataSet... TablesDS.Tables.Add(PanelTable)
+1
nkumari22y ago
hi, well, by now u must have solved the problem,so probably could help me... can u tell me how to edit the row and write back to the xml file. will really appreciate your help. nkumari
+1
henry_gogogo22y ago
Guess no one knows. OH well.
+1