经典DATAGRID增加,删除,修改,分页全集合----面试必配

ASPX

<%@ Page language="c#" Codebehind="TradeClass_admin.aspx.cs" AutoEventWireup="false" Inherits="F_Admin.TradeClass_admin" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>WebForm5</title>

</HEAD>

<body>

<tr>

ID序号(注：请按顺序填写)<asp:textbox id="ClassId" runat="server" Width="33px"></asp:textbox>

分类名称<asp:textbox id="ClassName" runat="server" Width="88px"></asp:textbox><asp:button id="AddButton" runat="server" Text="添加"></asp:button>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

<asp:datagrid id="TradeClassList" runat="server" AutoGenerateColumns="False" DataKeyField="ClassID"

AllowPaging="True" PageSize="5" Width="100%">

<asp:TemplateColumn HeaderText="ID序号">

<%# DataBinder.Eval(Container.DataItem,"ClassID") %>

</ItemTemplate>

<asp:TextBox id="ClassID" Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"ClassID") %>' Width="88px">

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="分类名称">

<%# DataBinder.Eval(Container.DataItem,"ClassName") %>

</ItemTemplate>

<asp:TextBox id="TradeClassName" Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"ClassName") %>' Width="80px">

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:EditCommandColumn UpdateText="更新" CancelText="取消" EditText="编辑"></asp:EditCommandColumn>

<asp:ButtonColumn Text="删除" CommandName="del"></asp:ButtonColumn>

</Columns>

</asp:datagrid>

</td>

</tr>

</table>

</form>

</body>

</HTML>

.cs

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Web;

using System.Configuration;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

namespace F_Admin

{

/// <summary>

/// TradeClass_admin 的摘要说明。

/// </summary>

public class TradeClass_admin : System.Web.UI.Page

{

protected System.Web.UI.WebControls.TextBox ClassId;

protected System.Web.UI.WebControls.TextBox Textbox1;

protected System.Web.UI.WebControls.TextBox ClassName;

protected System.Web.UI.WebControls.Button AddButton;

protected System.Web.UI.WebControls.DataGrid TradeClassList;

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

if(Session["UserName"]==null||Session["UserName"].ToString()==String.Empty)

{

Response.Redirect("Admin_Login.aspx");

}

if(!Page.IsPostBack)

{

SetBind();

}

private void SetBind()

{

SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);

SqlDataAdapter ad=new SqlDataAdapter("select * from Fly_TradeClass",conn);

DataSet ds=new DataSet();

conn.Open();

ad.Fill(ds);

conn.Close();

TradeClassList.DataSource=ds.Tables[0];

TradeClassList.DataBind();

}

Web 窗体设计器生成的代码

private void TradeClassList_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

if(e.CommandName=="del")

{

SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);

SqlCommand comm=new SqlCommand("delete from Fly_TradeClass where ClassID=@ID",conn);

SqlParameter parm1=new SqlParameter("@ID",SqlDbType.Int);

parm1.Value=this.TradeClassList.DataKeys[e.Item.ItemIndex];

comm.Parameters.Add(parm1);

conn.Open();

comm.ExecuteNonQuery();

conn.Close();

SetBind();

}

private void TradeClassList_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

this.TradeClassList.EditItemIndex=e.Item.ItemIndex;

SetBind();

}

private void TradeClassList_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);

SqlCommand comm=new SqlCommand("update Fly_TradeClass set ClassId=@ClassId,ClassName=@ClassName where ClassID=@ID",conn);

SqlParameter parm1=new SqlParameter("@ClassID",SqlDbType.Int);

parm1.Value=((TextBox)e.Item.FindControl("ClassID")).Text;

SqlParameter parm2=new SqlParameter("@ClassName",SqlDbType.VarChar,10);

parm2.Value=((TextBox)e.Item.FindControl("TradeClassName")).Text;

SqlParameter parm3=new SqlParameter("@ID",SqlDbType.Int);

parm3.Value=this.TradeClassList.DataKeys[e.Item.ItemIndex];

comm.Parameters.Add(parm1);

comm.Parameters.Add(parm2);

comm.Parameters.Add(parm3);

conn.Open();

comm.ExecuteNonQuery();

conn.Close();

this.TradeClassList.EditItemIndex=-1;

SetBind();

}

private void TradeClassList_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

this.TradeClassList.EditItemIndex=-1;

SetBind();

}

private void TradeClassList_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)

{

this.TradeClassList.CurrentPageIndex=e.NewPageIndex;

SetBind();

}

private void TradeClassList_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)

{

foreach(DataGridItem di in this.TradeClassList.Items)

{

if(di.ItemType==ListItemType.Item||di.ItemType==ListItemType.AlternatingItem)

{

((LinkButton)di.Cells[3].Controls[0]).Attributes.Add("onclick","return confirm('你真的要删除吗？考虑清楚');");

}

private void AddButton_Click(object sender, System.EventArgs e)

{

SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);

SqlCommand comm=new SqlCommand("insert into Fly_TradeClass (ClassID,ClassName) values (@ID,@ClassName)",conn);

SqlParameter parm1=new SqlParameter("@ID",SqlDbType.Int);

parm1.Value=this.ClassId.Text;

SqlParameter parm2=new SqlParameter("@ClassName",SqlDbType.VarChar,10);

parm2.Value=this.ClassName.Text;

comm.Parameters.Add(parm1);

comm.Parameters.Add(parm2);

conn.Open();

comm.ExecuteNonQuery();

conn.Close();

SetBind();

Response.Write("添加成功！");

}

posted on 2006-06-29 12:40 程序缘阅读(303) 评论(0) 收藏举报

刷新页面返回顶部

经典DATAGRID增加,删除,修改,分页全集合----面试必配

导航

公告