足球游戏_中国足彩网¥体育资讯$

.net中使用DatagridView的增删改方法
来源:易贤网 阅读:775 次 日期:2014-08-29 10:48:57
温馨提示:易贤网小编为您整理了“.net中使用DatagridView的增删改方法”,方便广大网友查阅!

default.aspx 页面:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="GPS_Web.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>

<!--GridView中必须写的几个事件:onrowediting、onrowupdating、onrowcancelingedit、onrowdeleting--->

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

onpageindexchanging="GridView1_PageIndexChanging" onrowcancelingedit="GridView1_RowCancelingEdit"

onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating"

onrowdeleting="GridView1_RowDeleting"

onselectedindexchanging="GridView1_SelectedIndexChanging">

<Columns>

<asp:TemplateField HeaderText="编号" Visible="False">

<ItemTemplate>

<asp:Label ID="lblNum" runat="server" Text='<%# Eval("Num") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="姓名">

<EditItemTemplate>

<asp:TextBox ID="txtTableName" runat="server" Text='<%# Eval("TableName") %>'></asp:TextBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%# Eval("TableName") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="地址">

<EditItemTemplate>

<asp:TextBox ID="txtTextName" runat="server" Text='<%# Eval("TextName") %>'></asp:TextBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="Label3" runat="server" Text='<%# Eval("TextName") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:CommandField HeaderText="状态" ShowSelectButton="True" />

<asp:CommandField HeaderText="编辑" ShowEditButton="True" />

<asp:CommandField HeaderText="删除" ShowDeleteButton="True" />

</Columns>

</asp:GridView>

<br />

<asp:Button ID="btnAdd" runat="server" onclick="btnAdd_Click" Text="添加" />

<br />

<br />

</div>

</form>

</body>

</html>

default.aspx.cs页面代码:

using System;

using System.Web.UI;

using System.Web.UI.WebControls;

using GPS_Web.ywpages.DAL;

using System.Data;

namespace GPS_Web

{

/// <summary>

/// </summary>

public partial class Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

GridViewBind();

}

}

private void GridViewBind()

{

string sql = "select Num,TableName,TextName from dbo.GroupType_Demo";

try

{ //绑定数据源

GridView1.DataSource = SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, sql).Tables[0];

GridView1.DataBind();

}

catch (Exception ex){}

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

GridViewBind();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

GridViewBind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{ //gridview编辑项索引等于单击行的索引

GridView1.EditIndex = e.NewEditIndex;

GridViewBind();

}

/// <summary>

/// 修改事件

/// </summary>

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{ //取出编号

int Num = Convert.ToInt32(((Label)GridView1.Rows[e.RowIndex].FindControl("lblNum")).Text.ToString());

//获取修改的值的内容

string TableName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtTableName")).Text;

string TextName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtTextName")).Text;

//更新记录

string sql = string.Format("update dbo.GroupType_Demo set TableName='{0}',TextName='{1}' where Num={2}",TableName,TextName,Num);

try

{

int i = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sql);

if (i > 0)

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script language='javascript'>alert('修改成功!')</script>");

}

else

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script language='javascript'>alert('修改失败!')</script>");

}

}

catch (Exception ex)

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script language='javascript'>alert('操作无效!')</script>");

}

GridView1.EditIndex = -1;

GridViewBind();

}

/// <summary>

/// 删除事件

/// </summary>

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

//取出编号

int Num = Convert.ToInt32(((Label)GridView1.Rows[e.RowIndex].FindControl("lblNum")).Text.ToString());

//更新记录

string sql = string.Format("delete dbo.GroupType_Demo where num={0}", Num);

try

{

int i = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sql);

if (i > 0)

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script language='javascript'>alert('删除成功!')</script>");

}

else

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script language='javascript'>alert('删除失败!')</script>");

}

}

catch (Exception ex)

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script language='javascript'>alert('操作无效!')</script>");

}

GridView1.EditIndex = -1;

GridViewBind();

}

/// <summary>

/// 添加按钮

/// </summary>

protected void btnAdd_Click(object sender, EventArgs e)

{

Response.Redirect("~/Default_Add.aspx");

}

protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)

{

//行号

int i = e.NewSelectedIndex;

GridViewRow row = GridView1.Rows[e.NewSelectedIndex];

btnAdd.Text = "你选中了第" + (i+1) + "行。";

}

}

}

执行后的页面效果:

中国足彩网信息请查看IT技术专栏

中国足彩网信息请查看网络编程
易贤网手机网站地址:.net中使用DatagridView的增删改方法
由于各方面情况的不断调整与变化,易贤网提供的所有考试信息和咨询回复仅供参考,敬请考生以权威部门公布的正式信息和咨询为准!

2025国考·省考课程试听报名

  • 报班类型
  • 姓名
  • 手机号
  • 验证码
关于我们 | 联系我们 | 人才招聘 | 网站声明 | 网站帮助 | 非正式的简要咨询 | 简要咨询须知 | 加入群交流 | 手机站点 | 投诉建议
工业和信息化部备案号:滇ICP备2023014141号-1 足球游戏_中国足彩网¥体育资讯$ 滇公网安备53010202001879号 人力资源服务许可证:(云)人服证字(2023)第0102001523号
云南网警备案专用图标
联系电话:0871-65099533/13759567129 获取招聘考试信息及咨询关注公众号:hfpxwx
咨询QQ:526150442(9:00—18:00)版权所有:易贤网
云南网警报警专用图标