datagridview new rows added

[NewToAspDotNet]

Hi everyone, i have a datagridview for adding/updating rows to the sqlserver database..before adding a new row to the database, i want to check whether the record already exist in my databse to avoid dubble records in the database...any idea how to do that? thanx, djavid

[pmarfleet]

Write a method in your C# code that calls a stored procedure that checks, based on the data being added, whether a matching record already exists. Paul

[laddie 0]

Also you can set the column of the data grid's datatable which need to be unique to be true.