ok Dear Just use this query....
SQLSTRING1 = "SELECT emp_no, emp_name, nric_no, dept FROM Emp_Profile WHERE emp_name LIKE ' %" & ToolStripTextBox1.Text & " %'"
Just Try This if u r using vb 6 to vb.net 2.0 this query work
SQLSTRING1 = "SELECT emp_no, emp_name, nric_no, dept FROM Emp_Profile WHERE emp_name LIKE '" & ToolStripTextBox1.Text & "'"
Hi Every One,
I am new to .net and i want to use transaction in my code for storing and manipulation of the data .
basically i use transaction for insert , update , delete query and two sp which used in the coding ....
for insertion , updation and deletion i use command.commandtext =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.