如何在GridView中添加CheckBox控件列,添加删除确认对话框-控件新闻-慧都网

如何在GridView中添加CheckBox控件列,添加删除确认对话框

翻译|其它|编辑：郝浩|2007-09-17 10:20:15.000|阅读 2069 次

概述：

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;

public partial class GridViewCheckBox : System.Web.UI.Page
...{
    protected void Page_Load(object sender, EventArgs e)
    ...{
        if (!IsPostBack)
            GridViewDataBind();
    }

    private void GridViewDataBind()
    ...{
        string connStr = ConfigurationManager.ConnectionStrings["northwind"].ConnectionString;
        SqlConnection conn = new SqlConnection(connStr);
        SqlDataAdapter da = new SqlDataAdapter("select firstname, lastname, city from employees", conn);
        conn.Open();
        DataSet ds = new DataSet();
        try
        ...{
            da.Fill(ds, "testTable");
            dgCheckBox.DataSource = ds.Tables["testTable"].DefaultView;
            dgCheckBox.DataBind();
        }
        catch (Exception error)
        ...{
            Response.Write(error.ToString());
        }
        finally
        ...{
            conn.Close();
        }
    }
    protected void cmdSelectAll_Click(object sender, EventArgs e)
    ...{
        System.Web.UI.WebControls.CheckBox chkEport;
        if (cmdSelectAll.Text == "全选")
        ...{
            foreach (GridViewRow gridviewrow in dgCheckBox.Rows)
            ...{
                chkEport = (CheckBox)gridviewrow.FindControl("chkEport");
                chkEport.Checked = true;
            }
            cmdSelectAll.Text = "取消";
        }
        else
        ...{
            foreach (GridViewRow gridviewrow in dgCheckBox.Rows)
            ...{
                chkEport = (CheckBox)gridviewrow.FindControl("chkEport");
                chkEport.Checked = false;
            }
            cmdSelectAll.Text = "全选";
        }
    }
    protected void cmdFindSelected_Click(object sender, EventArgs e)
    ...{
        System.Web.UI.WebControls.CheckBox chkEport;
        string strID;
        System.Text.StringBuilder strMsg = new System.Text.StringBuilder("选中项的City字段值分别为：<hr color=red>");
        foreach (GridViewRow gridviewrow in dgCheckBox.Rows)
        ...{
            chkEport = (CheckBox)gridviewrow.FindControl("chkEport");
            if (chkEport.Checked)
            ...{
                strID = ((Label)(gridviewrow.FindControl("lblCity"))).Text;
                strMsg.Append(strID + "<br><hr color=red>");
            }
            message.Text = strMsg.ToString();
        }
    }
    protected void dgCheckBox_RowCreated(object sender, GridViewRowEventArgs e)
    ...{
        if (e.Row.RowType == DataControlRowType.DataRow)
        ...{
            TableCell myCell;
            myCell = e.Row.Cells[4];
            LinkButton btnDel = (LinkButton)myCell.Controls[0];
            btnDel.Attributes.Add("onclick", "return confirm('您真的要删除此行吗？');");
            btnDel.Text = "删除";
        }
    }
    protected void dgCheckBox_RowDeleting(object sender, GridViewDeleteEventArgs e)
    ...{
        Response.Write("删除");
    }
}