Hi.
I'm trying to read xml schema to a dataset that already contains datatable
with the same name as the one in schema file and ReadXmlSchema has no
effect.
This console application in VB.Net demonstrates it:
Module Module1
Sub Main()
WriteSchemaFromNW()
End Sub
Private Sub WriteSchemaFromNW()
Dim connection As SqlClient.SqlConnection
Try
Dim connectionString As String = "integrated security=SSPI;data
source=localhost;persist security info=False;initial catalog=Northwind"
connection = New SqlClient.SqlConnection(connectionString)
Dim command As New SqlClient.SqlCommand("Select * from Orders", connection)
Dim da As New SqlClient.SqlDataAdapter(command)
Dim ds As New DataSet
Dim dt As New DataTable("Orders")
ds.Tables.Add(dt)
da.Fill(dt)
ds.WriteXmlSchema("c:\Orders.xml")
dt = Nothing
Dim ds1 As New DataSet, ds2 As New DataSet
Dim dt1 As New DataTable("Orders")
ds1.Tables.Add(dt1)
ds1.ReadXmlSchema("c:\Orders.xml")
ds2.ReadXmlSchema("c:\Orders.xml")
Console.WriteLine("Reading schema into dataset with existing table")
For Each tbl As DataTable In ds1.Tables
Console.WriteLine(String.Format("Table {0} - number of rows = {1}, number of
columns = {2}", tbl.TableName, tbl.Rows.Count, tbl.Columns.Count))
Next
Console.WriteLine("Reading schema into an empty dataset")
For Each tbl As DataTable In ds2.Tables
Console.WriteLine(String.Format("Table {0} - number of rows = {1}, number of
columns = {2}", tbl.TableName, tbl.Rows.Count, tbl.Columns.Count))
Next
Catch ex As Exception
Console.WriteLine(ex.Message)
Finally
If Not connection Is Nothing Then
connection.Dispose()
End If
End Try
End Sub
End Module
Any help is very appreciated.
Thanks a lot
- Predrag.