How to show data from search box ?

Question

Hi I create a search box in masterpage using textbox and button control and write the button code in masterpage. Now I want to show the search data in other webform page using detailsview control. The problem is that it does not search the data.The code i use is- { SqlConnection con = new SqlConnection(Data Source=.;Initial Catalog=Movieweb;Integrated Security=True); SqlDataAdapter sda = new SqlDataAdapter(select * from Moviedb con); DataTable dt = new DataTable(); sda.Fill(dt); Response.Redirect(view.aspx); } Please help me. Thanks.

Beginner · Answer

try dataset to fill adapter DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter( select * from Moviedb con ); sda.Fill(ds);

girish parganiha · Answer

Thank You for your reply. I create search box in master page to show the search option in all other pages of my website. I write the button_click event code for search button in masterpageit redirect the page to view.aspx page and shows the detailsview control in that page but not shows the search data. If there is something wrong in this code then please help me.

Krishna Rajput Singh · Answer

Hello Girish thank you for writing below links hope helpful for you..:) http://www.c-sharpcorner.com/UploadFile/cd7c2e/different-type-of-search-on-database-and-display-result-on-g/

Khaja Moizuddin · Answer

http://stackoverflow.com/questions/3854358/how-to-make-an-autocomplete-textbox-in-asp-net http://www.c-sharpcorner.com/UploadFile/rahul4_saxena/jquery-auto-complete-text-box-in-Asp-Net-C-Sharp/ http://programcall.com/1/aspnet/example-for-implementing-autocomplete-in-aspnet-textbox.aspx Try this

Khaja Moizuddin · Answer

You mean you want to do like autocomplete