i am new to VB.net. just want to check an id number in my textbox if its aldready existed in my database. this is my condition:
if textbox1.text = ds.tables("employees").row(0).item("id") then
msgbox("ID already exist")
end if
i am new to VB.net. just want to check an id number in my textbox if its aldready existed in my database. this is my condition:
if textbox1.text = ds.tables("employees").row(0).item("id") then
msgbox("ID already exist")
end if
What is ur problem? or where is the probelm?
this is the error i have encounter...object reference not set to an instance of an object
the condition i have set doesn't work.. thanks
ds.tables("employees").row(0).item("id") only one row ur checking? Cant u validate at the back end? by just sending ur employee id as parameter?
If you are wanting ID's to be unique, you might want to think about making it a primary key. Thus making it not possible to have multiples. Then you can wrap your insert in a try catch, the client will handle the "No duplicate keys" message.
Make it the Primary Key then set it to autoincrement and the database will assign an id for you, no need to worry about it in the code.
thanks for the suggestion.. got an idea. :) and it works :)
What is ur sollution ? And if it solved then plz mark the thread as solved..
You can try:
'sqls is a string
'cmd is a command builder
sqls = "SELECT * FROM employees WHERE id = '" & textbox1.text & "'"
cmd = New CommandBuilder(sqls,connection)
If cmd.ExecuteNonQuery = False Then
MsgBox("ID not found")
End If
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.