chkbox

最新推荐文章于 2025-07-22 00:16:16 发布

yhh345814509

最新推荐文章于 2025-07-22 00:16:16 发布

阅读量417

点赞数

CC 4.0 BY-SA版权

文章标签： datagrid string server class xhtml object

本文链接：https://blog.youkuaiyun.com/yhh345814509/article/details/6920159

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication3._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>发现问题了木有</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:CheckBoxList ID="chkclass" RepeatLayout="Table" RepeatColumns ="3" CellPadding="9" CellSpacing="18" OnSelectedIndexChanged ="submitchange" runat="server">
        </asp:CheckBoxList>
        <br /><br />
        <asp:DataGrid ID ="dgclass" runat ="server"></asp:DataGrid>
    </div>
    </form>
</body>
</html>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace WebApplication3
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                String strconnection = "server=.;database=class;integrated secrity=true;";
                SqlConnection objconnection = new SqlConnection(strconnection);
                String strsql = "SELECT name FROM class";
                SqlCommand objcommand = new SqlCommand(strsql, objconnection);

                objconnection.Open();
                chkclass.DataSource = objcommand.ExecuteReader();
                chkclass.DataTextField = "name";
                chkclass.DataValueField = "number";
                chkclass.DataBind();
                objconnection.Close();
            }
        }

        private void submitchange(object sender, System.EventArgs e)
        {
            String strwhereclause = "";
            foreach (ListItem liThisOne in chkclass.Items)
            {
                if (liThisOne.Selected)
                {
                    strwhereclause += "number=" + liThisOne.Value + "OR";
                }

            }
            Response.Write("strwhereclause=<br/>" + strwhereclause + "<hr/>");
            if (strwhereclause.Length > 0)
            {
                dgclass.Visible = true;
                String str = strwhereclause.Substring(0, strwhereclause.Length - 4);
                strwhereclause = "WHERE" + str;

                String strconnection = "server=.;database=class;integrated secrity=true;";
                SqlConnection objconnection = new SqlConnection(strconnection);
                String strsqlforgrid = "SELECT * FORM class" + strwhereclause;
                SqlCommand objcommand = new SqlCommand(strsqlforgrid, objconnection);

                Response.Write("strsqlforgrid =<br/>" + strsqlforgrid + "<hr/>");
                objconnection.Open();
                dgclass.DataSource = objcommand.ExecuteReader();
                dgclass.DataBind();
                objconnection.Close();
            }
            else
                dgclass.Visible = false;
        }
    }
}
发现了问题你就天才了