Hi,

I need to check two fields/columns within my SQL database before inserting a new record.

Basically I have a Name field and a Date field, I want to check if a name exists with a specific date before I insert what would be a duplicate record. I can have multiple instances of name or date but not both together.

I am using Visual Basic .Net within Visual Studio, can anyone help?

Thanks

VBMazza

Hi,

Compare them in the WHERE clause of the INSERT Query.
Now To confirm the Insertion check the RecordsAffected returned by the ExecuteNonQuery.

Regards,
Prashant.

Thanks,

I used the WHERE statement in a SELECT command, then used a Data Reader to give a
BOOLEAN response, so I can give the user an option to edit a record.

VBMazza