玉祥平台客服-15087858732

标题: [分享] CridView创建实现选中，编辑，取消，删除 [打印本页]

作者: fteair 时间: 2020-2-1 17:35

作者: fteair 时间: 2020-2-1 17:37

作者: fteair 时间: 2020-2-2 17:37

作者: fteair 时间: 2020-2-5 17:47

作者: fteair 时间: 2020-2-6 17:45

作者: Adam丶鱼 时间: 2020-7-28 17:54
标题: [分享] CridView创建实现选中，编辑，取消，删除
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->
前台主要代码：
                        ... ...
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
                     ForeColor="#333333" GridLines="None" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"
                     OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit">
                     <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                     <Columns>
                        <asp:BoundField DataField="身份证号码" HeaderText="用户ID" ReadOnly="True" />
                        <asp:BoundField DataField="姓名" HeaderText="用户姓名" />
                        <asp:BoundField DataField="员工性别" HeaderText="性别" />
                        <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />
                        <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
                        <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
                        <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
                     </Columns>
                     <RowStyle ForeColor="#000066" />
                     <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                     <[img]file:///C:\Users\Administrator\AppData\Roaming\Tencent\QQ\Temp\TempPic\QQPC8I~RFL5{[%N1)JMU}P7.tmp[/img]agerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                     <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                  </asp:GridView>

代码

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->
using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{

//清清月儿http://blog.csdn.net/21aspnet
SqlConnection sqlcon;
SqlCommand sqlcom;
string strCon = "Data Source=(local);Database=数据库名;Uid=帐号file:///C:\Users\Administrator\AppData\Roaming\Tencent\QQ\Temp\TempPic\OQNA2SM)Z8$PY]0()F19Z72.tmpwd=密码";
protected void Page_Load(object sender, EventArgs e)
{
      if (!IsPostBack)
      {
         bind();
      }
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
      GridView1.EditIndex = e.NewEditIndex;
      bind();
}

//删除
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
      string sqlstr = "delete from 表 where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
      sqlcon = new SqlConnection(strCon);
      sqlcom = new SqlCommand(sqlstr,sqlcon);
      sqlcon.Open();
      sqlcom.ExecuteNonQuery();
      sqlcon.Close();
      bind();
}

//更新
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
      sqlcon = new SqlConnection(strCon);
      string sqlstr = "update 表 set 字段1='"
         + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',字段2='"
         + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',字段3='"
         + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where id='"
         + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
      sqlcom=new SqlCommand(sqlstr,sqlcon);
      sqlcon.Open();
      sqlcom.ExecuteNonQuery();
      sqlcon.Close();
      GridView1.EditIndex = -1;
      bind();
}

//取消
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
      GridView1.EditIndex = -1;
      bind();
}

//绑定
public void bind()
{
      string sqlstr = "select * from 表";
      sqlcon = new SqlConnection(strCon);
      SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
      DataSet myds = new DataSet();
      sqlcon.Open();
      myda.Fill(myds, "表");
      GridView1.DataSource = myds;
      GridView1.DataKeyNames = new string[] { "id" };//主键
      GridView1.DataBind();
      sqlcon.Close();
}
}

作者: Adam丶鱼 时间: 2020-7-28 17:55

欢迎光临玉祥平台客服-15087858732 (http://bbs.delit.cn/)