使用电子商务网站的复选框列表从数据库中搜索数据

问题描述：

您好先生我想使用复选框aur复选框列表搜索数据，如果我选择两个复选框然后我想获取复选框ID的数据。请给我一个这类查询的演示代码。

Hello sir i wanna search the data using checkbox aur checkboxlist like if i select two checkbox then i wanna to get the data of both the checkbox id's. please give me a demo code for this type of query.

答

你好，

你可以试试此代码：

Hello ,

You can try this code:

<div>>
        <asp:CheckBoxList ID="chkUserData" runat="server" AutoPostBack="true" 

            onselectedindexchanged="chkUserData_SelectedIndexChanged" 

            RepeatDirection="Horizontal">
        </asp:CheckBoxList>
        <asp:GridView ID="gvUserDetails" runat="server" EmptyDataText="No Record Found">
            <RowStyle BackColor="#EFF3FB" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
    </div>

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
            con.Open();
            SqlCommand cmd = new SqlCommand("select UserId,UserName,Email from UserMaster", con);
            cmd.ExecuteNonQuery();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                chkUserData.Items.Insert(i, new ListItem(ds.Tables[0].Rows[i][1].ToString(), ds.Tables[0].Rows[i][0].ToString()));
            }
        }
    }

  protected void chkUserData_SelectedIndexChanged(object sender, EventArgs e)
    {
 if (!String.IsNullOrEmpty(chkUserData.SelectedValue))
        {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("select UserId,UserName,Email from UserMaster where UserId='" + chkUserData.SelectedValue + "'", con);
        cmd.ExecuteNonQuery();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        gvUserDetails.DataSource = ds;
        gvUserDetails.DataBind();
    }
        else
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
            con.Open();
            SqlCommand cmd = new SqlCommand("select UserId,UserName,Email from UserMaster", con);
            cmd.ExecuteNonQuery();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            gvUserDetails.DataSource = ds;
            gvUserDetails.DataBind();
        }
}

在这里你可以随意改变。

Here you can change as you want.

使用电子商务网站的复选框列表从数据库中搜索数据

相关推荐