Hi,
I have just learned from the link
http://support.microsoft.com/kb/821765/EN-US/ to use the
database with VB .NET
From the example of the above link, if I want to use the
table Student as reference table, I need to verify if the
SNo existing in the database, then the SName is matching
with that SNo is existed in the database. The Error to
handle the case will be:
IDERROR=1 IF SNo does not have that ID
IDERROR=2 IF SName does not match with the existing ID.
The Wizard from the "OleDbDataAdapter" automatically
generate the four SQL update, delete, insert... for me. I
want to add a SQL statements as the following:
SELECT *
FROM student
WHERE student.SNo="Input from the textbox of VB .NET".
If the return is null, the IDERROR=1
SELECT *
FROM student
WHERE student.SNo="Input from the textbox of VB .NET"
AND student.SName="Input from the textbox of VB .NET"
If the return is null, the IDERROR=2
Could someone help me to accomplish it, please.
Thanks,
/CC.