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 OleDbDataAdapte r("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]

U¿ytkownik "Tee" <th*@streamyx.c om> napisa³ w wiadomo¶ci
news:%2******** **********@tk2m sftngp13.phx.gb l...

Hi,

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

da = new OleDbDataAdapte r("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["AnotherCol umn"] = "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.Dat aSet DataSet1 = new System.Data.Dat aSet();

System.Data.Dat aTable dt = new System.Data.Dat aTable();

System.Data.Dat aColumn dc = new System.Data.Dat aColumn("Field1 ",
typeof(System.S tring));

dt.Columns.Add( dc);

DataSet1.Tables .Add(dt);

System.Data.Dat aRow dr = dt.NewRow();

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

dt.Rows.Add(dr) ;
"Tee" <th*@streamyx.c om> wrote in message
news:%2******** **********@tk2m sftngp13.phx.gb l...

Hi,

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

da = new OleDbDataAdapte r("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

[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/de...ClassTopic.asp

Adding a datatable to a dataset is nothing more than

dim ds as new dataset
ds.tables.add(m ydatatable)

I hope this helps?

Cor

"Tee" <th*@streamyx.c om>

Hi,

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

da = new OleDbDataAdapte r("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