Displaying search results in Datagridview

Question

I am trying to display the search results I obtain from searching a database in a datagrid control present on my form.

My table name is bookinfo with following columns bid, bname, author, unitprice, availablebooks.

I have a textbox on my windows form and i want to display these search results in datagrid as a textchanged event.

I'm not getting any idea for doing this, Can any body give the sample code or at least give me an idea about writing the steps.

Thank You in advance Guys....

Rewant Choudhary · Answer

myConnection = WebConfigurationManager . ConnectionStrings [ "onnectionString" ]. ConnectionString ; connect = new SqlConnection ( myConnection ); command = new SqlCommand (); connect . Open (); command . Connection = connect ; string komut = "SELECT * FROM table name WHERE authername='"+textbox1.Text+"'" ; try { SqlCommand sqlCommand = new SqlCommand (); sqlCommand = connect . CreateCommand (); sqlCommand . CommandText = komut ; SqlDataAdapter sda = new SqlDataAdapter ( sqlCommand . CommandText , connect ); SqlCommandBuilder scb = new SqlCommandBuilder ( sda ); //Create a DataTable to hold the query results. DataTable dTable = new DataTable (); //Fill the DataTable. sda . Fill ( dTable ); GridView1 . DataSource = dTable ; GridView1 . DataBind (); } catch ( SqlException ) { //Console.WriteLine(e.StackTrace); } reader . Close (); connect . Close ();

Displaying search results in Datagridview

Answers (1)