[Dannrafer]

I want to search my database using textbox hers my code:
I did not get error with this code but it didnt search anything on my databse..

 Private cs As New SqlConnection("Data Source=DANN-D3CCEAB190\SQLEXPRESS;Initial Catalog=StudentGradeCompilation;Integrated Security=True")
   
    Private da As New SqlDataAdapter("SELECT Studentname, Studentnocode, [Print] FROM Table_1 WHERE Studentnocode LIKE '%Maintext.text' ", cs)


    Private ds As New DataSet

    Private cmb As New SqlCommandBuilder(da)
    Public BindingSource1 As New BindingSource()

This post has been edited by Dannrafer: 07 July 2011 - 07:46 AM

[modi123_1]

Awesome! Are you having problems with it? Is the code not working as expected? If so how is it working and how should it be working? Is there an exception? If so what is the exception and what line is it occurring on?

Just by looking at it I can tell your SQL statement is flawed. You need to get your maintext to APPEND to the string and not be just characters in a string!

" SELECT Studentname, Studentnocode, [Print] FROM Table_1 WHERE Studentnocode LIKE '%" + Maintext.text + "%'"

I am not sure if the code is outside of the chunk you gave us, but I do hope you are executing that query!