Searching from Userform to Database

richard smith

I have a webform that keeps an inventory of vehicle maintenance. This form is still in the works, but I am attempting to make it very userfriendly. I need to add a search function so I added a textbox (called textSearch) and a button to push when ready to search. The employee will type the Customer last name into that box, and I need the employee to be redirected to a different userform, and have a datagrid (that is already set-up on the other user form) display all customers with that last name. How would this be done?

7 Replies

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

Hemant Srivastava13y ago
Accepted answer
From first page, send the string as aquery string.. something like that:

Response.Redirect("SecondPage.aspx?Name=" + txtBx_Request.Text);
And on the second page load, get the query string to populate your data grid. Query string you could get as:
string requested_Name = Request.QueryString["Name"];
richard smith13y ago
Haven't had a moment to test the code yet. But will def, 1 up, and mark as solved if this relinqueshes my problem.
Hemant Srivastava13y ago
If the above solution helped you, Plz mark this answer as an accepted answer.. that would help others to follow.
Hemant Srivastava13y ago
In the Search Button (First Form) event handler put the code like:
        protected void Button1_Click(object sender, EventArgs e)
        {
            Response.Redirect("SecondPage.aspx?Name=" + txtBx_Request.Text);
        }

And on the second form page load, get the query string like:
        protected void Page_Load(object sender, EventArgs e)
        {
           string reqName = Request.QueryString["Name"];
           if (reqName != "")
           {
               Label1.Text = "You queried for the person having name: " + reqName;
               DataBaseSearch(reqName);
           }
         }

Now bind your data result into your grid in DataBaseSearch() method
richard smith13y ago
I am actually needing to pass the value in the textbox to a different method. Would that be set-up the same way or would I do it differently than the Response.Redirect("SecondPage.aspx?Name=" + txtBx_Request.Text);

The name of the method is DatabaseSearch()
richard smith13y ago
How do I actually request the data from textSearch? Is it a simple Request["textSearch"]?
Hemant Srivastava13y ago
I would try like this:

1. Get the input from 'Search Text Box' (say for last name Smith)
2. Search 'Smith' into your Customer Data collection. If your data collection is already not in memory, bring that data from database. You may use ADO.Net Dataset for reading the data.

Now you have dataset, either store that dataset contents into some .Net collection (e.g. List, Dictionary etc.) then find the word 'smith' OR you can directly search the word in dataset directly by using lambda expression.
(how to searchin dataset, you may refer to this link:
http://www.c-sharpcorner.com/UploadFile/0f68f2/querying-a-data-table-using-select-method-and-lambda-express/)

3. Populate the datagrid with your result set.

4. On 'Search' button click, Redirect to that page on which you are dispalying datagrid.

Hope it could help you.