ASP.net Gridview复选框打勾/打勾更新
本文关键字：更新 复选框 net Gridview ASP | 更新日期: 2023-09-27 18:06:09
我在ASP中有一个Gridview。. NET在那里我需要包括复选框到网格视图和更新按钮。在选中特定行的复选框时，应该触发更新事件，并且单击更新按钮应该保存更改。我已经编写了c#代码来更新Gridview而不使用复选框。但是，当包含复选框时无法继续。网格视图设计代码为:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_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:Label ID="Label1" runat="server" Text="Employee ID"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server" style="margin-left: 110px"></asp:TextBox>
<br />
<br />
<asp:Label ID="Label2" runat="server" Text="Employee Name"></asp:Label>
<asp:TextBox ID="TextBox2" runat="server" style="margin-left: 90px"></asp:TextBox>
<br />
<br />
<asp:Label ID="Label3" runat="server" Text="Employee Experience"></asp:Label>
<asp:TextBox ID="TextBox3" runat="server" style="margin-left: 61px"></asp:TextBox>
<br />
<br />
<asp:Label ID="Label4" runat="server" Text="Employee Address"></asp:Label>
<asp:TextBox ID="TextBox4" runat="server" style="margin-left: 79px"></asp:TextBox>
<br />
<br />
<asp:Button ID="Button2" runat="server" onclick="Button2_Click"
style="text-align: left" Text="Submit" />
<asp:GridView ID="EmployeeGridView" runat="server" AutoGenerateColumns="False"
DataKeyNames="Emp_id" onrowcancelingedit="EmployeeGridView_RowCancelingEdit"
onrowediting="EmployeeGridView_RowEditing"
onrowdeleting="EmployeeGridView_RowDeleting"
onrowupdating="EmployeeGridView_RowUpdating" AllowPaging="True" CellPadding="4"
ForeColor="#333333" GridLines="None"
onpageindexchanging="EmployeeGridView_PageIndexChanging"
Width="408px" AllowSorting="True"
onselectedindexchanged="EmployeeGridView_SelectedIndexChanged">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:TemplateField HeaderText="Sr.No">
<ItemTemplate><%#Container.DataItemIndex+1 %></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate><%#Eval("Emp_name") %></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtempname" runat="server" Text='<%#Eval("Emp_name") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Experience">
<ItemTemplate><%#Eval("Emp_exp") %></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtempexp" runat="server" Text='<%#Eval("Emp_exp") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address">
<ItemTemplate><%#Eval("Emp_address") %></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtempaddress" runat="server" Text='<%#Eval("Emp_address") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="true" ButtonType ="Button"
ItemStyle-ForeColor= "Aqua">
<ItemStyle ForeColor="Aqua"></ItemStyle>
</asp:CommandField>
<asp:CommandField ShowDeleteButton="true" ButtonType="Button" HeaderText="Delete" />
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerSettings FirstPageText="First" LastPageText="Last"
Mode="NumericFirstLast" PageButtonCount="4" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
</div>
<asp:Button ID="Button1" runat="server" Text="Update" />
</form>
</body>
</html>
c#代码后面是:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
string connstr = @"Data Source=xxxxxxx'SQLEXPRESS;Initial Catalog=xxxxxxxxx;Integrated Security=True";
protected void EmployeeGridView_Sorting(object sender, GridViewSortEventArgs e)
{
Session["sortBy"] = e.SortExpression;
FillGrid();
}
protected void Page_Load(object sender, EventArgs e)
{
Session["sortBy"] = null;
if (!Page.IsPostBack)
{
FillGrid();
}
}
public void FillGrid()
{
SqlConnection con = new SqlConnection(connstr);
con.Open();
SqlCommand cmd = new SqlCommand("GetEmployeeInfo", con);
SqlDataReader dr = cmd.ExecuteReader();//it reads froword only data from database
DataTable dt = new DataTable();//object of data table that uses to conatin whole data
dt.Load(dr);//Sql Data reader data load in data table it is DataTable Method.
EmployeeGridView.DataSource = dt;
EmployeeGridView.DataBind();
}
protected void EmployeeGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
EmployeeGridView.EditIndex = -1;
FillGrid();
}
protected void EmployeeGridView_RowEditing(object sender, GridViewEditEventArgs e)
{
EmployeeGridView.EditIndex = e.NewEditIndex;
FillGrid();
}
protected void EmployeeGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int empid = Convert.ToInt32(EmployeeGridView.DataKeys[e.RowIndex].Value.ToString());//Get Each Row unique value from DataKeyNames
string name = ((TextBox)EmployeeGridView.Rows[e.RowIndex].FindControl("txtempname")).Text;//get TextBox Value in EditItemTemplet that row is clicked
string experience = ((TextBox)EmployeeGridView.Rows[e.RowIndex].FindControl("txtempexp")).Text;
string address = ((TextBox)EmployeeGridView.Rows[e.RowIndex].FindControl("txtempaddress")).Text;
SqlConnection con = new SqlConnection(connstr);
con.Open();
SqlCommand cmd = new SqlCommand("EmployeeUpdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@emp_id ", empid);
cmd.Parameters.AddWithValue("@emp_name ", name);
cmd.Parameters.AddWithValue("@emp_exp ", experience);
cmd.Parameters.AddWithValue("@emp_address ", address);
cmd.ExecuteNonQuery();//Sql Command Class method return effected rows use for insert,update, delete
EmployeeGridView.EditIndex = -1;// no row in edit mode
FillGrid();
}
protected void EmployeeGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int empid = Convert.ToInt32(EmployeeGridView.DataKeys[e.RowIndex].Value.ToString());
SqlConnection con = new SqlConnection(connstr);
con.Open();
SqlCommand cmd = new SqlCommand("DeleteEmployee", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@emp_id ", empid);
cmd.ExecuteNonQuery();
FillGrid();
}
protected void EmployeeGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
EmployeeGridView.PageIndex = e.NewPageIndex;
FillGrid();
}
private void UpdateOrAddNewRecord(string Emp_id, string Emp_name, string Emp_exp, string Emp_address)
{
SqlConnection con = new SqlConnection(connstr);
string sqlStatement = string.Empty;
sqlStatement = "INSERT INTO tbl_employee" +
"(Emp_id, Emp_name, Emp_exp, Emp_address)" +
"VALUES (@Emp_id, @Emp_name, @Emp_exp, @Emp_address)";
con.Open();
SqlCommand cmd = new SqlCommand(sqlStatement, con);
cmd.Parameters.AddWithValue("@Emp_id", Emp_id);
cmd.Parameters.AddWithValue("@Emp_name", Emp_name);
cmd.Parameters.AddWithValue("@Emp_exp", Emp_exp);
cmd.Parameters.AddWithValue("@Emp_address", Emp_address);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
con.Close();
}
protected void Button2_Click(object sender, EventArgs e)
{
UpdateOrAddNewRecord(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text);
FillGrid();
}
}
我没有保留DeleteEmployee、EmployeeUpdate、GetEmployeeInfo等存储过程的代码。
在上面的代码中，我需要为gridview插入复选框，并更新选中的项目，而不是单击编辑按钮，然后更新
在事件更新按钮点击做这些事情。循环遍历网格的每一行。在每一行中，获得相应的复选框检查CheckedBox是否被选中如果选中，则从当前行检索其他值并调用我们的更新方法。
for (int innercounter = 0; innercounter < grid.Rows.Count; innercounter++)
{
CheckBox chkSelect;
chkSelect = (CheckBox)grid.Rows[innercounter].Cells[0].FindControl("ChkSelect");
if (chkSelect.Checked == true)
{
Label Field1 = (Label)grid.Rows[innercounter].Cells[1].FindControl("txtFieldName1");
Label Field2 = (Label)grid.Rows[innercounter].Cells[2].FindControl("txtFieldName2");
Update(Field1.text,Field2.text)
}
}