Need help: fill dataset

[Tee]

Hi,

I need some help about filling dataset, I am not sure how to describe it, so
I give the example here.

da = new OleDbDataAdapter("SELECT * FROM Path WHERE PathID=1", cnn);

da.Fill(DataSet, "Path");



this is the code of current DataAdapter filling up a DataSet.

What I wanted to do now is fill the DataSet with specified data from Code,
not from DataAdapter.

Is this possible? if yes, how to do it?



Thanks,
Tee

 

[Grzegorz Danowski]

Hi,

I need some help about filling dataset, I am not sure how to describe it,
so
I give the example here.

da = new OleDbDataAdapter("SELECT * FROM Path WHERE PathID=1", cnn);

da.Fill(DataSet, "Path");



this is the code of current DataAdapter filling up a DataSet.

What I wanted to do now is fill the DataSet with specified data from Code,
not from DataAdapter.

Is this possible? if yes, how to do it?

For example:

DataRow dr = DataSet["Path"].NewRow();
dr[0] = 34;// value of 34 to first field
dr["AnotherColumn"] = "A string";
....
etc.

DataSet["Path"].Rows.Add(dr);

I hope it helps.
Grzegorz

 

[Jim Hughes]

Something along these lines should work. Replace field1 with your field
names.

Use the NewRow() method of the Dataset DataTable, populate the data and Add
it to the DataTable Rows colleciton.

System.Data.DataSet DataSet1 = new System.Data.DataSet();

System.Data.DataTable dt = new System.Data.DataTable();

System.Data.DataColumn dc = new System.Data.DataColumn("Field1",
typeof(System.String));

dt.Columns.Add(dc);

DataSet1.Tables.Add(dt);

System.Data.DataRow dr = dt.NewRow();

dr["Field1"] = "your data1";

dt.Rows.Add(dr);

 

[Cor Ligthert]

Tee,

A dataset is a object that beside relations and other things holds
datatables.
I assume you are talking only about filling the datatable.

In this class description is a very complete sample of that.
http://msdn.microsoft.com/library/d...f/html/frlrfSystemDataDataTableClassTopic.asp

Adding a datatable to a dataset is nothing more than

dim ds as new dataset
ds.tables.add(mydatatable)

I hope this helps?

Cor