How do I search records in the grid with a particular given date in ASP.NET

Question

1.00/5 (2 votes)

See more:

i have patient visit grid,and it has admit date and discharge date column, i want to give a feature to search for a patient with particular admit date, and it needs to be searched with the grid itself, not running a query, i want it to be that way itself,
how do i filter records in the grid with a given admit date

please answer me, thank you

What I have tried:

i'm very new to asp.net, grid operations are clumsy and difficult for me, please suggest some source to learn about grid operaations

Posted 9-Aug-16 8:00am

Member 12677894

Updated 9-Aug-16 8:53am

Add a Solution

Comments

Vincent Maverick Durano 9-Aug-16 14:26pm

Let me clarify. Are you displaying all the records in the Grid at once?

Member 12677894 9-Aug-16 14:40pm

no, i have set paging=15

Vincent Maverick Durano 9-Aug-16 14:46pm

Good. If that's the case then you need to write a query to perform a data request based on your filter.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vincent Maverick Durano · Answer 1 · 2016-08-09T08:53:00

If you are using ADO.NET with DataTable for binding your GridView, then you can do something like this:

C#

protected void BindGrid(string searchText){
    using(SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE")){
        using(SqlCommand cmd = new SqlCommand(sql,connection)){
                string sql = "SELECT * FROM TableName WHERE YourFieldName = @Param1";
                cmd.Parameters.AddWithValue("@Param1", searchText);
                DataTable dt = new DataTable();
                SqlDataAdapter ad = new SqlDataAdapter(cmd);
                ad.Fill(dt);

                if (dt.Rows.Count > 0) { //check if the query returns any data
                       GridView1.DataSource = dt;
                       GridView1.DataBind();
                }
                else
                {
                     //No records found
                }
        }

    }
}

protected void Button1_Click(object sender, EventArgs e){
        BindGrid(YourTextBoxID.Text.Trim());
}

The code above is the typical way to search for a particular records in the database based on a TextBox value. You may need to validate the text to ensure validate dates format. You can also use a MaskEdit or Calendar extender control for your TextBox to ensure that the dates entered is valid. Depending on your datatype, you may also need to do a datatype conversion from string to datetime.

Hope that helps.