Click here to Skip to main content
16,004,602 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
public partial class search : System.Web.UI.Page
{
   
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLDbConnection"].ConnectionString);

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            fill_ddlPhone();
            fill_ddlEmail();
        }
        
    }


    private void fill_ddlPhone()
    {
        try
        {
            string sql = "SELECT * FROM registration";

            ddlPhone.Items.Clear();
            ddlPhone.AppendDataBoundItems = true;
            ddlPhone.Items.Add(new ListItem("Phone", "-1"));
            ddlPhone.DataSource = cmscon.getRows(sql);
            ddlPhone.DataTextField = "Phone";
            ddlPhone.DataValueField = "Phone";
            ddlPhone.DataBind();
            ddlPhone.SelectedValue = "-1";
        }
        catch (Exception ex)
        {

        }
    }
    private void fill_ddlEmail()
    {
        try
        {
            string sql = "SELECT * FROM registration";

            ddlEmail.Items.Clear();
            ddlEmail.AppendDataBoundItems = true;
            ddlEmail.Items.Add(new ListItem("E-Mail", "-1"));
            ddlEmail.DataSource = cmscon.getRows(sql);
            ddlEmail.DataTextField = "Email";
            ddlEmail.DataValueField = "Email";
            ddlEmail.DataBind();
            ddlEmail.SelectedValue = "-1";
        }
        catch (Exception ex)
        {

        }
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {

        String str = "select * from registration where(FirstName like '%' + @search + '%'AND StudentID LIKE '%' + @StId + '%' )";
        

        SqlCommand cmdSearch = new SqlCommand(str, con);
        cmdSearch.Parameters.Add("@search", SqlDbType.VarChar).Value = txtContactFirstName.Text;
        cmdSearch.Parameters.Add("@StId", SqlDbType.VarChar).Value = txtContactID.Text;

        con.Open();
        cmdSearch.ExecuteNonQuery();
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmdSearch;
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();

        da.Fill(ds, "FirstName");
        da.Fill(ds, "StudentID");
        gvSearch.DataSource = ds;
        gvSearch.DataBind();
        con.Close();

        

           

    }
}
Posted
Comments
OriginalGriff 9-Feb-15 3:49am    
And?
Your problem is?
What help do you need?
star_tasneem 9-Feb-15 6:16am    
the problem is the string input is searching fine but i can not add dropdownlist input. plz help..thnx in advance

change your sql statment as
SQL
string str = "select * from registration where FirstName like @search AND StudentID LIKE @StId";

when you add parameter values set it as below
C#
cmdSearch.Parameters.Add("@search", SqlDbType.VarChar).Value = "%" +txtContactFirstName.Text + "%";
cmdSearch.Parameters.Add("@StId", SqlDbType.VarChar).Value = "%" +txtContactID.Text + "%";
 
Share this answer
 
Comments
star_tasneem 9-Feb-15 6:08am    
these are string inputs in search button which is working fine..what about dropdownlist input?plz help
Use the query like this:

VB
String str = "select * from registration where FirstName like '%@search%' AND StudentID LIKE '%@StId%' )";
 
Share this answer
 
Comments
star_tasneem 9-Feb-15 6:07am    
string inputs are searching fine but dropdownlist input is not showing any results.
how to search using dropdownlist input? thnx in advance

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900