版权声明：转载原创文章请以超链接形式请注明原文章出处，尊重作者，尊重原创！
恰饭广告
实现效果：
BLL层：
using GridviewTest.DAL;
using GridviewTest.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
namespace GridviewTest.BLL
{
public class UserInfoBLL
{
UserInfoDAL userInfoDAL = new UserInfoDAL();
public DataTable LoadData()
{
return userInfoDAL.LoadData();
}
public void Delete(UserInfo user)
{
userInfoDAL.Delete(user);
}
public void UserUpdate(UserInfo user)
{
userInfoDAL.UserUpdate(user);
}
}
}
DAL层：
using GridviewTest.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
namespace GridviewTest.DAL
{
public class UserInfoDAL
{
SQLHelper sqlHelp = new SQLHelper();
public DataTable LoadData()
{
string cmdText = "select * from T_login";
return sqlHelp.ExecuteTable(cmdText);
}
public void Delete(UserInfo user)
{
sqlHelp.ExecuteNonQuery("delete from T_login where id=@id",
new SqlParameter("id",user.id));
}
public void UserUpdate(UserInfo user)
{
sqlHelp.ExecuteNonQuery(@"UPDATE T_login SET username=@name,password=@pwd where id=@id",
new SqlParameter("@id", user.id),
new SqlParameter("@name", user.name),
new SqlParameter("@pwd", user.pwd));
}
}
}
Model层：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace GridviewTest.Model
{
public class UserInfo
{
public int id { get; set; }
public string name { get; set; }
public string pwd { get; set; }
}
}
UI层：
WebForm1.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="GridviewTest.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">
<Columns>
<asp:TemplateField HeaderText="学号">
<EditItemTemplate>
<asp:Label ID="Label2" Text='<%# Eval("id") %>' runat="server"></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" Text='<%# Eval("id") %>' runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="姓名">
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem,"username") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("username") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="密码">
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem,"password") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox2" Text='<%# Eval("password") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="操作">
<EditItemTemplate>
<asp:Button ID="btnUpdate" runat="server" Text="更新" CommandName="Update" />
<asp:Button ID="btnCancel" runat="server" Text="取消" CommandName="Cancel" />
</EditItemTemplate>
<ItemTemplate>
<asp:Button ID="btnEdit" runat="server" Text="编辑" CommandName="Edit" />
<asp:Button ID="btnDel" runat="server" Text="删除" CommandName="Delete" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
WebForm1.aspx.cs
using GridviewTest.BLL;
using GridviewTest.Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace GridviewTest
{
public partial class WebForm1 : System.Web.UI.Page
{
UserInfoBLL userInfoBLL = new UserInfoBLL();
UserInfo user = new UserInfo();
private void BindGridView()
{
GridView1.DataSource = userInfoBLL.LoadData();
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
user.id = Convert.ToInt32(((Label)GridView1.Rows[e.RowIndex].FindControl("Label1")).Text);
userInfoBLL.Delete(user);
BindGridView();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
user.id = Convert.ToInt32(((Label)GridView1.Rows[e.RowIndex].FindControl("Label2")).Text);
user.name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text;
user.pwd = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text;
userInfoBLL.UserUpdate(user);
GridView1.EditIndex = -1;
BindGridView();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
BindGridView();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
BindGridView();
}
}
}
原文链接：https://www.idaobin.com/archives/1299.html
让我恰个饭吧.ヘ(￣ω￣ヘ)
支付宝 ——————- 微信
恰饭广告
