php 实现类似asp.net中的datagridview效果,asp.net中使用DatagridView的增删改方法具体实现...

asp.net中使用DatagridView的增删改方法具体实现

default.aspx 页面：

代码如下:

onpageindexchanging="GridView1_PageIndexChanging" onrowcancelingedit="GridView1_RowCancelingEdit"

onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating"

onrowdeleting="GridView1_RowDeleting"

onselectedindexchanging="GridView1_SelectedIndexChanging">

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

{

///

/// 参考的网址：http://blog.csdn.net/wanglei_samrtfish/article/details/8070480

///

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();

}

///

/// 修改事件

///

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", "");

}

else

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "");

}

}

catch (Exception ex)

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "");

}

GridView1.EditIndex = -1;

GridViewBind();

}

///

/// 删除事件

///

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", "");

}

else

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "");

}

}

catch (Exception ex)

{

ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "");

}  www.gxlcms.com

GridView1.EditIndex = -1;

GridViewBind();

}

///

/// 添加按钮

///

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) + "行。";

}

}

}

执行后的页面效果：

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网