Show search data from search box in masterpage to other page

girish parganiha

9y1.5k.NET

Hi,

I create search box in master page to show the search box in other pages of my web application.I write the search button click event code in master page. I want to show the search result in other page of my website(view.aspx page) & i use details view control in that page to show the output.

The code i use in master page 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");
}

But the code only redirect to view.aspx page and does not show the search result.
If something wrong in this code then please guide me.

2 Replies

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

Mangesh G9y ago
This is beacause the master page load is happening when You redirect to page

so need to retain these values

May Be You can keep the things In the session an check if search occured override that result ...
0
Ananth G9y ago
DataTable dt = new DataTable();
sda.Fill(dt);

store the above data to a session variable . then you will Redirect to the view.aspx then you will get that session data in pageload then use that session data to view.aspx page .

this process is working properly because 1 year before i also use this process..

try it.

---------If answer is correct , accept the answer.. its useful to others------------
0