Q: DataSet

[Geoff]

Hi

I have a question which has occurred to me. I have been writing new records
to a table in a database. To do this, I have created a dataset (ADO.NET), by
attaching a dataadptor to the table and then using
MyDataAdaptor.Fill(MyDataSet, "TableName").

This is all well and good. The dataset is then a copy of the database table
and I can add rows to it and then at the end do an update and the new
records in the dataset are transferred to the table in the database.

However, what if I only want to add rows to the table. As far as I can see
there is no point in using the Fill to load all the data in the table to the
dataset. Is there a way to create the dataset table, which I can add rows
to, without first populating it with rows from the database?

Thanks in advance

Geoff

[Cor Ligthert [MVP]]

Geoff,

Fillschema

http://msdn.microsoft.com/library/de...chematopic.asp

I hope this helps,

Cor
"Geoff" <no********@email.com> schreef in bericht
news:43**********************@news.dial.pipex.com. ..

Hi

I have a question which has occurred to me. I have been writing new
records to a table in a database. To do this, I have created a dataset
(ADO.NET), by attaching a dataadptor to the table and then using
MyDataAdaptor.Fill(MyDataSet, "TableName").

This is all well and good. The dataset is then a copy of the database
table and I can add rows to it and then at the end do an update and the
new records in the dataset are transferred to the table in the database.

However, what if I only want to add rows to the table. As far as I can see
there is no point in using the Fill to load all the data in the table to
the dataset. Is there a way to create the dataset table, which I can add
rows to, without first populating it with rows from the database?

Thanks in advance

Geoff

[Geoff]

Thanks Cor. As always most helpful

Geoff

"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:uV**************@TK2MSFTNGP15.phx.gbl...

Geoff,

Fillschema

http://msdn.microsoft.com/library/de...chematopic.asp

I hope this helps,

Cor
"Geoff" <no********@email.com> schreef in bericht
news:43**********************@news.dial.pipex.com. ..

Hi

I have a question which has occurred to me. I have been writing new
records to a table in a database. To do this, I have created a dataset
(ADO.NET), by attaching a dataadptor to the table and then using
MyDataAdaptor.Fill(MyDataSet, "TableName").

This is all well and good. The dataset is then a copy of the database
table and I can add rows to it and then at the end do an update and the
new records in the dataset are transferred to the table in the database.

However, what if I only want to add rows to the table. As far as I can
see there is no point in using the Fill to load all the data in the table
to the dataset. Is there a way to create the dataset table, which I can
add rows to, without first populating it with rows from the database?

Thanks in advance

Geoff