实例：GridView实现CheckBox的多选或单选，并根据所选择的行进行数据操作

实例说明：

    有一个用户列表，其中每一个用户对应一个状态。状态有两个值，分别是已激活，未激活。

    现要求实现这样的功能，

     1.        列表显示出用户名及对应的激活状态。

     2.        列表中的每一行行首有一个CheckBox，列表底部有一个Button（激活）。使用者先勾选CheckBox（可多选），在点击激活按钮，即可激活相应勾选的用户。

     3.        对于当前状态是激活状态的用户，其行首不应该显示CheckBox.

 

功能截图：

 

 

 

    涉及到的知识：

1.  
   1. GridView如何加入CheckBox，如何传值。
   2. GridView的某列如何根据不同的存储值而显示不同的文本。
   3. 如何获取多选的CheckBox，如何批量执行数据库操作。

---

 

 

主要代码：

aspx页面代码：

<asp:GridView ID="GridViewMain" runat="server" OnRowDataBound="GridViewMain_RowDataBound"> <Columns> <asp:TemplateField> <HeaderTemplate>  选择 </HeaderTemplate> <ItemTemplate> <asp:CheckBox ID="CheckItem" runat="server" /> <asp:HiddenField ID="HidID" runat="server" Value='<%# Eval("UserID") %> ' /> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="UserName" HeaderText="UserName" /> <asp:BoundField DataField="ActiveStatus" HeaderText=" Active Status 激活状态" > </asp:BoundField> </Columns> </asp:GridView>

---

cs代码

protected void GridViewMain_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Cells[0].FindControl("CheckItem").Visible = (e.Row.Cells[2].Text.Trim() == "0" ? true : false); e.Row.Cells[2].Text = (e.Row.Cells[2].Text.Trim() == "0" ? "未激活" : "已激活"); }}

---

protected void btnActive_Click(object sender, EventArgs e) { int rowCount = GridViewMain.Rows.Count; string checkIDlink = ""; for (int i = 0; i < rowCount; i++) { CheckBox tempChk = (CheckBox)GridViewMain.Rows[i].FindControl("CheckItem"); HiddenField HidID = (HiddenField)GridViewMain.Rows[i].FindControl("HidID"); if (tempChk.Checked == true) { checkIDlink += HidID.Value + "|"; } } if (String.IsNullOrEmpty(checkIDlink.Trim())) { string ErroMsg = @"<mce:script language=""javascript""><!--alert(""No Row is Selected!"")// --></mce:script>"; Literal2.Text = ErroMsg; return; } checkIDlink = checkIDlink.Substring(0, checkIDlink.LastIndexOf("|")); int returnRows = ActiveUser(checkIDlink); GridViewMain.DataSourceID = ***; GridViewMain.DataBind(); }

 

---

public int ActiveUser(string userIDLink) { string[] userID = userIDLink.Split(Convert.ToChar("|")); string[] SQLs = new string[userID.Length]; for (int i = 0; i < userID.Length; i++) { SQLs[i] = "UPDATE TUserName SET ActiveStatus = 'Y' WHERE UserID = '" + userID[i]+ "'"; } return DataAccess.SqlHelper.SQLExecuteNonQuery(SQLs); }

---

public static int SQLExecuteNonQuery(string[] SQLText) { try { using (SqlConnection connection = new SqlConnection(CONN_STRING_NON_DTC)) { connection.Open(); SqlTransaction transaction; // Start a local transaction. transaction = connection.BeginTransaction(); int executeCount = 0; try { for (int i = 0; i < SQLText.Length; i++) { // Call the overload that takes a connection in place of the connection string executeCount+=ExecuteNonQuery(transaction, CommandType.Text, SQLText[i]); } transaction.Commit(); } catch { transaction.Rollback(); throw new ArgumentNullException("The transaction is rollbacked , please check the execute SQL."); } transaction.Dispose(); if (connection.State == ConnectionState.Open) { connection.Close(); } return executeCount; } } catch (Exception ex) { throw ex; } }