how to add new record as first record in dataset

[email protected] · April 17th, 2006, 11:50 PM

Hi all,

Well, i have been stucked in a tricky problem. I want to add a new item(record) as first item(record) in dataset which is already been populated from database.

I hope that I will going to have replies very soon. Thanks in advance for your valuable replies...

Abdul Ghaffar

dutguoyi · April 18th, 2006, 10:07 PM

Maybe you can add a special column named colsort for sorting in DataSet.
For example, the colsort data in the the former rows is 0 and the elder is 1.
Then you can use datagridview to sort the data by colsort desc.
But be careful your memory.

:)Â¡Â¶
Â¡Â¶Â¡Â¶ No pains, no gains.
Â¡Â¶Â¡Â¶Â¡Â¶

rumbafum · April 19th, 2006, 08:21 AM

Can create a new Dataset, add the record to th new dataset, and then merge data from the old one with preserveChanges set to true...

DataSet ds = new DataSet();
//add new row here
ds.Merge(oldDataSet, true);

[email protected] · April 21st, 2006, 12:02 AM

Thanks Rumbafu for your valuable reply..... it really worked fine....

Abdul Ghaffar

rumbafum · April 21st, 2006, 05:23 AM

No prob