Start New Discussion within our Software Development Community


I am new to Need to know how can I retrieve the value from compname field of my table, to the textbox7 in form i made.
While the user enters data in the textbox, i need to compare the entered textbox value, if it exists or not, in the database. If exists, It should enter the value in textbox. If not, it should pop up a message box asking user to add new contact.

I have inserted data using Oledbd command string.

Database : MS Access 2007

Kindly help me out. Your guidance would be highly appreciated.

Thank You..

First of all you have to construct the SELECT statement.

Dim sqlr="select column_name1 from table_name where column_name2=@col_value"

Prepare the command object.

Dim Cmd as New OleDbCommand
Cmd.Connection=Cn 'Assign ref of connection object

Execute the command using ExecuteScalar method.

 Dim result=Cmd.ExecuteScalar()
 If IsNothing(Result) Then
     'Not found
 End If
This question has already been answered. Start a new discussion instead.