How to show data from search box ?

girish parganiha

10y959.NET

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.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Beginner10y ago
try dataset to fill adapter

DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter("select * from Moviedb", con);
sda.Fill(ds);

0
girish parganiha10y ago
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 masterpage,it 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.
0
Krishna Rajput Singh10y ago
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/
0
Khaja Moizuddin10y ago
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
0
Khaja Moizuddin10y ago
You mean you want to do like autocomplete
0