Duplicate rows in the Dataset!

[helloitsme]

Hello!

I use DataAdapter.Fill method to fill the dataset with data from a SQL database table. But when the same method is called for a second time subsequently, it appends the data instead of overwriting the duplicate rows in the table.

For example, i use DataAdapter.Fill(mydataset,"mytable"). the "mytable" has 50 rows and copies the same to "maytable" in mydataset. But after a subsequent call to DataAdapter.Fill(mydataset,"mytable"), the mytable in mydataset has 100 rows (i.e all the 50 rows duplicated).

Can anyone please tell me how to avoid that!!
I hope I have posted this in the right forum,else let me know...

Thank you!

[jorgepino]

the DataAdapter does not set a PrimaryKey value for the resulting DataTable. You must explicitly define the primary key to ensure that duplicate rows are resolved correctly

[helloitsme]

Thank you for replying...

I tried doing so using the following before doing the .Fill -

DA.MissingSchemaAction = MissingSchemaAction.AddWithKey;

if this is what you were talking about, then this did not help either...
Please let me know if did something wrong or understood wrong...

thanx...