提供一个GridView,在打开页面的时候，加载表T_TRA_PRODUCT中的所有内容

Question

GridView ado.net控件

Answer 1

GridView显示数据表的所有内容并进行增、删、改示例
//GridView控件设置编辑、删除、插入等页面内容
  <asp:GridView ID="ClassList" runat="server" AutoGenerateColumns="False"
                        CellPadding="4" Font-Size="11pt" GridLines="None" Width="468px" OnRowCancelingEdit="ClassList_RowCancetingEdit" OnRowDeleting="ClassList_RowDeleting" OnRowEditing="ClassList_RowEditing" OnRowUpdating="ClassList_RowUpdating" ForeColor="#333333" AllowPaging="True" AllowSorting="True" OnPageIndexChanging="ClassList_PageIndexChangging" PageSize="6" OnRowDataBound="ClassList_RowDataBound">
                        <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        <Columns>
                            <asp:TemplateField HeaderText="选项">
                                <ItemTemplate>
                                    <asp:CheckBox ID="CheckBox1" runat="server" Font-Size="9pt" Height="1px" Width="1px" />
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="b_id" HeaderText="类型编号" ReadOnly="True" />
                            <asp:BoundField DataField="b_name" HeaderText="职业类别" />
                            <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                            <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
                        </Columns>
                        <SelectedRowStyle BackColor="#C5BBAF" ForeColor="#333333" Font-Bold="True" />
                        <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        <AlternatingRowStyle BackColor="White" />
                        <RowStyle BackColor="#E3EAEB" />
                        <EditRowStyle BackColor="#7C6F57" />
                    </asp:GridView>
<asp:TextBox ID="typename" runat="server" Font-Size="11pt"></asp:TextBox>//添加文本框
<asp:Button id="btmAdd" onclick="btmAdd_Click" runat="server" Font-Size="10pt" Text="添加"></asp:Button>//执行添加按钮
<asp:CheckBox ID="CheckBox2" runat="server" AutoPostBack="True" Font-Size="9pt" OnCheckedChanged="CheckBox2_CheckedChanged"
                                    Text="全选" Width="54px" />//复选框全选操作
<asp:Button ID="btnDelte" runat="server" OnClick="Button2_Click" Text="批量删除" Width="81px" />//批量删除按钮
<asp:Button ID="btnCancel" runat="server" OnClick="Button3_Click" Text="取消全选" Width="79px" />//取消全选按钮
//数据库操作
SqlData My_sqldata = new SqlData();
    SqlConnection ST_myConn;
    protected void Page_Load(object sender, EventArgs e)
    {
        //建立数据库连接
        string ST_dns = ConfigurationSettings.AppSettings["conn"];
        ST_myConn = new SqlConnection(ST_dns);
        if (!IsPostBack)
        {
            //调用自定义方法ST_Type_List_Bind()进行数据绑定
            ST_Type_List_Bind();
        
        }
}
//绑定数据库显示数据
public void ST_Type_List_Bind()
    {
        string sqlstr = "select * from bz_class order by b_date desc ";
        //调用公共类中的ExceDS()方法，用来返回一个DataSet类型
        My_sqldata.ExceDS(sqlstr);
        //获取数据表中的主键字段
        ClassList.DataKeyNames = new string[] { "b_id" };
        ClassList.DataSource = My_sqldata.ExceDS(sqlstr);
        ClassList.DataBind();
    }
//添加插入数据
protected void btmAdd_Click(object sender, EventArgs e)
    {
        ST_myConn.Open();
        if (this.typename.Text != "")
        {
            string sqlstr1 = "select count(*) from bz_class where b_name='" + typename.Text.ToString() + "'";
            SqlCommand mycom = new SqlCommand(sqlstr1, ST_myConn);
            int intcount = Convert.ToInt32(mycom.ExecuteScalar());
            if (intcount > 0)
            {
                Response.Write("<script>alert('对不起！不允许添加相同记录！');location='Bang_zhu.aspx'</script>");
            }
            else
            {
                string ST_sql = "insert into bz_class (b_name,b_date) values ('" + typename.Text.ToString() + "','" + DateTime.Now.ToString() + "')";
                My_sqldata.ExceSQL(ST_sql);
                Response.Write("<script>alert('添加成功!');location='Bang_zhu.aspx'</script>");
            }
        }
    }
//执行删除索引数据行
protected void ClassList_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string sqlstr = "delete from bz_class where b_id='" + ClassList.DataKeys[e.RowIndex].Value.ToString() + "'";
        //调用公共类中的ExceSQL方法执行SQL语句
        My_sqldata.ExceSQL(sqlstr);
        ST_Type_List_Bind();
    }
//编辑修改数据内容并从新绑定数据显示
protected void ClassList_RowEditing(object sender, GridViewEditEventArgs e)
    {
        ClassList.EditIndex = e.NewEditIndex;
        ST_Type_List_Bind();
    }
    protected void ClassList_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string sqlstr0 = "update bz_class set b_name='" + ((TextBox)(ClassList.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "'where b_id='" + ClassList.DataKeys[e.RowIndex].Value.ToString() + "'";
        //调用公共类中的ExceSQL方法执行SQL语句
        My_sqldata.ExceSQL(sqlstr0);
        ClassList.EditIndex = -1;        ST_Type_List_Bind();
    }
//全选按钮操作
protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
    {
        for (int i = 0; i <= ClassList.Rows.Count - 1; i++)
        {
            CheckBox cbox = (CheckBox)ClassList.Rows[i].FindControl("CheckBox1");
            if (CheckBox2.Checked == true)
            {
                cbox.Checked = true;
            }
            else
            {
                cbox.Checked = false;
            }//CodeGo.net/
        }
    }
//批量删除按钮
  protected void Button2_Click(object sender, EventArgs e)
    {
        //ST_myConn.Open();
        for (int i = 0; i <= ClassList.Rows.Count - 1; i++)
        {
            CheckBox cbox = (CheckBox)ClassList.Rows[i].FindControl("CheckBox1");
            if (cbox.Checked == true)
            {
                string sqlstr = "delete from bz_class where b_id='" + ClassList.DataKeys[i].Value + "'";
                My_sqldata.ExceSQL(sqlstr);
                Response.Write("<script language=javascript>alert('批量删除成功！');location='AnlType.aspx'</script>");
            }
        }
    }//其他设置字符因素（略）

Answer 2

点击删除按钮，给他一个点击事件，MessageShow("确认删除")