=?ISO-8859-1?Q?Datasets=3A_Created_with_code_VS=2E_cre?==?ISO-8859-1?Q?ated_using_point=B4n_click?=

[=?ISO-8859-1?Q?S=F8ren?=]

Hi guys

This is just driving me mad. :-| Here´s the thing:

When a dataset has been created like this:
Dim customerOrders As DataSet = New DataSet("CustomerOrders")
Dim ordersTable As DataTable = customerOrders.Tables.Add("Orders")
Dim pkOrderID As DataColumn = ordersTable.Columns.Add("OrderID",
Type.GetType("System.Int32"))
ordersTable.Columns.Add("OrderQuantity", Type.GetType("System.Int32"))
ordersTable.Columns.Add("CompanyName",
Type.GetType("System.String"))
... then this is possible:
Dim test = customerOrders.Tables("Orders").AsEnumerable()
... but when a dataset has been created by adding a new item to the
project resulting in a .xsd file, then it seems to be a completely
different type of dataset, which doesn´t have all the methods that the
dataset created though code does [ie. Tables()].

Is this basicly just two different kind of datasets (a good one and a
completely useless one)?

Regards Søren

[=?ISO-8859-1?Q?S=F8ren?=]

I finally figured it out. I wasn´t the dataset at all .. it was problems
with variable scope, that broke the connection to the dataset. :-)

Regards Søren
Søren skrev:

Hi guys

This is just driving me mad. :-| Here´s the thing:

When a dataset has been created like this:
Dim customerOrders As DataSet = New DataSet("CustomerOrders")
Dim ordersTable As DataTable = customerOrders.Tables.Add("Orders")
Dim pkOrderID As DataColumn = ordersTable.Columns.Add("OrderID",
Type.GetType("System.Int32"))
ordersTable.Columns.Add("OrderQuantity", Type.GetType("System.Int32"))
ordersTable.Columns.Add("CompanyName",
Type.GetType("System.String"))
.. then this is possible:
Dim test = customerOrders.Tables("Orders").AsEnumerable()
.. but when a dataset has been created by adding a new item to the
project resulting in a .xsd file, then it seems to be a completely
different type of dataset, which doesn´t have all the methods that the
dataset created though code does [ie. Tables()].

Is this basicly just two different kind of datasets (a good one and a
completely useless one)?

Regards Søren