Hello,
I really need your help with this, I'm stucked with a code that doesn't work because of incorrect syntax
Basically what I have to do is make a research on database based on input(textbox1.text, textbox2.text, textbox3.text...) from user plus the user isn't necesserly going to enter all fields how can I manage this in the code
Here the code:
Dim connection As New OleDbConnection("Provider=SQLNCLI.1;Data Source=Imane-PC\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=Project;")

Dim command As New OleDbCommand("SELECT * FROM form,rel WHERE form.code = rel.code and form.code and form.desc = @desc LIKE @code and form.exp LIKE @exp", connection)

command.Parameters.AddWithValue("@desc", Me.TextBox1.Text)
command.Parameters.AddWithValue("@code", Me.TextBox2.Text)
command.Parameters.AddWithValue("@exp", Me.TextBox3.Text)


[/CODE]
I really need your help, it is very urgent thank you