How to prohibit inserting existing row in datatable

[ardin]

suppose i have a dataset populated using dataadapter. i bind the dataset
to a windows datagrid. i accepts new record through textboxes not
through the datagrid. how can i detect if the data entered is already
existing to the dataset before the update command of the dataset is
executed so that the row with error will not be added to the datagrid?

 

[Cor]

Hi Ardin,

You can use the datatable select
You can use the datarowcollection find
You can use the dataview rowfilter
You can go through the datatable with a loop

I hope this helps?

Cor

 

[ardin]

cor,

thanks, i actually use dataview rowfilter, however, i just want to know
if there's another way, like when i issue that command
dataset.table["tablename"].rows.add(dRow), an exeption will be generated
since the primary/unique key is already included in the dataset schema.

again thanks,

ardin

 

[Cor]

Hi Ardin,

I was calling for methods,
For what you write now, I use the datarowcollection find.

http://msdn.microsoft.com/library/d...rlrfsystemdatadatarowcollectionclasstopic.asp

I hope this helps?

Cor

 

[ardin]

cor,

thanks for the prompt reply.

ardin_wowie_winwin_arianne