Search multiple columns in database and display results in ASP.Net

BigHeart

SOLVED CLOSED ACTIVE ANSWERED
User: BigHeart
Posted: on Dec 08, 2012 06:25 AM
Forum: Data Controls
Replies: 3
Views: 3658

I want to search record based on Name, ID, Date, Report Type. from same table with one textbox,. can any one give me solution,.

i can do search with one column how can do it with multiple column

protected void Button2_Click(object sender, EventArgs e)
    {
       
     DateTime dt = Convert.ToDateTime(TextBox1.Text);
     SqlCommand cmd = new SqlCommand("SELECT * FROM Transactions where report_type = @report_type ");

     cmd.Connection = con;
     cmd.Parameters.Add("@report_type", SqlDbType.NVarChar).Value = DropDownList1.SelectedValue;
     SqlDataAdapter da = new SqlDataAdapter(cmd);
     DataSet ds = new DataSet();
     da.Fill(ds);
     GridView1.DataSource = ds;
      GridView1.DataBind();
    }

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
User: Mudassar
Replied: on Dec 08, 2012 06:27 AM
Report

Refer: 1. Searching in ASP.Net GridView Multiple Parameters

BigHeart

0 2

Reply
User: BigHeart
Replied: on Dec 15, 2012 04:21 AM
Report

cant fetch data in gridview,.,. for multiple parameter.

 protected void Button2_Click(object sender, EventArgs e)
    {
        
        con.Open();
        string query = "select * from Transactions where (dateadd(dd, datediff(dd,0, [R_date]), 0) or @R_date= '') and (report_type = @report_type or @report_type= '')";
        SqlCommand cmd = new SqlCommand(query);
        cmd.Parameters.AddWithValue("@R_date", TextBox2.Text.Trim());
        cmd.Parameters.AddWithValue("@report_type", DropDownList1.SelectedIndex > 0 ? DropDownList1.SelectedValue : "");

        SqlDataAdapter sda = new SqlDataAdapter();
        cmd.Connection = con; sda.SelectCommand = cmd;
        DataSet ds = new DataSet();
        sda.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
        con.Close();
}

Mudassar

0 3

Reply
User: Mudassar
Replied: on Dec 27, 2012 04:47 AM
Report

Could you let us know the error?

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Search multiple columns in database and display results in ASP.Net

Company

Explore

Follow us

Contact Us