How to add a row to an SQL Dataset

[JT]

I have an SQL database with one table in it. I want to load the table into
a DataSet, add new records to the DataSet, then commit the changes back to
the database.

Using C#.NET, the following loads the DataSet and fills it:

string SelectString = "SELECT * FROM dbo.Trade";
SqlCommand RecordsSelectio n = new SqlCommand(Sele ctString,
ThisConnection) ;

RecordsSelectio n.CommandTimeou t = 10;

SqlDataAdapter TradeAdapter = new SqlDataAdapter( );
TradeAdapter.Se lectCommand = RecordsSelectio n;
DataSet TradeRecords = new DataSet();
TradeAdapter.Fi ll(TradeRecords , "dbo.Trade" );

Now I want to access the single table and add a new row. I can iterate
through the tables collection of the dataset, but for each table, there is
no name property.

So my question is, how can I access a table within this dataset so I can add
a new row?

I know this question is elementary, but I would appreciate any help as
research has not answered the question.

Thanks.

[David]

Erm...

I think TradeRecords.Ta bles[0] will give you access to the first table in
the dataset.

Best regards,
Dave Colliver.
http://www.AshfieldFOCUS.com
~~
http://www.FOCUSPortals.com - Local franchises available
"JT" <wd**@noreturna ddressl.comwrot e in message
news:jM******** *************** *******@giganew s.com...

>I have an SQL database with one table in it. I want to load the table into
a DataSet, add new records to the DataSet, then commit the changes back to
the database.

Using C#.NET, the following loads the DataSet and fills it:

string SelectString = "SELECT * FROM dbo.Trade";
SqlCommand RecordsSelectio n = new SqlCommand(Sele ctString,
ThisConnection) ;

RecordsSelectio n.CommandTimeou t = 10;

SqlDataAdapter TradeAdapter = new SqlDataAdapter( );
TradeAdapter.Se lectCommand = RecordsSelectio n;
DataSet TradeRecords = new DataSet();
TradeAdapter.Fi ll(TradeRecords , "dbo.Trade" );

Now I want to access the single table and add a new row. I can iterate
through the tables collection of the dataset, but for each table, there is
no name property.

So my question is, how can I access a table within this dataset so I can
add
a new row?

I know this question is elementary, but I would appreciate any help as
research has not answered the question.

Thanks.

[Marc Scheuner]

>Now I want to access the single table and add a new row. I can iterate

>through the tables collection of the dataset, but for each table, there is
no name property.

There's a .TableName though.....

Once you have a handle to your DataTable (by means of

DataTable tblTrades = TradeRecords.Ta bles[0]

you can then call the .NewRow() method on the DataTable to get back a
new instance of a DataRow - now fill it, add it to the .Rows
collection, and call the .Update method on the TradeAdapter, and you
should be done.

Marc