How to search records in a database?

See more:

ASP.NET

SQL-Server-2008R2

Hi guys!

I have an image button for searching and a grid view for displaying records.If the record/s does not exist, the page will display the number of items found. And when it found a record that matches, it will display in my grid view. Now, my problem here is my search function does not work. Can anyone help me?

Here is my .cs file for Searching:

protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        repgen_connection();
        DataTable dt = new DataTable();
        if (sbu.SelectedItem.Text == null && company_code.Text == null && buyer_name.Text == null && proj_name.Text == null && unit_desc.Text == null && milestone.SelectedItem.Text == null && checklist.SelectedItem.Text == null && activity.SelectedItem.Text == null)
        {
            ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('No records found!');", true);
        }
        else if (sbu.SelectedValue != null || company_code.Text != null || buyer_name.Text != null || proj_name.Text != null || unit_desc.Text != null || milestone.SelectedValue != null || checklist.SelectedValue != null || activity.SelectedValue != null)
        {
            string strQuery = "Select DISTINCT brand, company_code,Contract_num,buyer_name, proj_name ,unit_description, milestone, checklist,activity, status,logged_by,date_created,completed_by,date_completed FROM  rawdata WHERE ";
            if (sbu.SelectedValue != "")
            { strQuery += " brand LIKE '%" + sbu.SelectedValue + "%' AND"; }
            if (company_code.Text != "")
            { strQuery += " company_code LIKE '%" + company_code.Text + "%' AND"; }
            if (buyer_name.Text != "")
            { strQuery += " buyer_name LIKE '%" + buyer_name.Text + "%' AND"; }
            if (proj_name.Text != "")
            { strQuery += " proj_name LIKE '%" + proj_name.Text + "%' AND"; }
            if (unit_desc.Text != "")
            { strQuery += " unit_description LIKE '%" + unit_desc.Text + "%' AND"; }
            if (milestone.SelectedValue != "")
            { strQuery += " milestone LIKE '%" + milestone.SelectedValue + "%' AND"; }
            if (checklist.SelectedValue != "")
            { strQuery += " checklist LIKE '%" + checklist.SelectedValue + "%' AND"; }
            if (activity.SelectedValue != "")
            { strQuery += " activity LIKE '%" + activity.SelectedValue + "%' AND"; }
            strQuery += " proj_name and unit_description AND company_code  AND status='not completed' ORDER BY Contract_num DESC";

            SqlCommand query = new SqlCommand(strQuery);
            SqlDataAdapter sda = new SqlDataAdapter();
            query.CommandType = CommandType.Text;
            query.Connection = amicassaCon_repgen;

            try
            {
                amicassaCon_repgen.Open();
                sda.SelectCommand = query;
                sda.Fill(dt);
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }
            catch (Exception ex)
            {
                // Response.Write(ex.Message);
            }
            finally
            {
                amicassaCon_repgen.Close();
                sda.Dispose();
                amicassaCon_repgen.Dispose();
                //Response.Write(strQuery);
            }
        }
       

        int tot = 0;
        foreach (DataRow dr in dt.Rows)
        {
            tot = tot + 1;
        }
        itms.Text = "Item's found: " + tot + " items";
    }