在ASP.NET 2.0 下如何实现DataList的编辑功能
来源:互联网 发布:警惕网络诈骗讲座报告 编辑:程序博客网 时间:2024/05/25 21:35
前台:
<form id="form1" runat="server">
<div>
<asp:DataList ID="dlEditItem" runat="server" DataKeyField="EmployeeID" OnCancelCommand="dlEditItem_CancelCommand" OnEditCommand="dlEditItem_EditCommand" OnUpdateCommand="dlEditItem_UpdateCommand">
<HeaderTemplate>人员信息</HeaderTemplate>
<ItemTemplate>
<asp:Button ID="edit" runat="server" Text="Edit" CommandName="Edit"/><%# Eval("LastName")%><%# Eval("FirstName")%>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lastname" runat="server"><%# Eval("LastName")%></asp:Label>
<asp:Label ID="firstname" runat="server"><%#Eval("FirstName") %></asp:Label>
<asp:TextBox ID="title" runat="server" Text='<%#Eval("Title") %>'></asp:TextBox>
<asp:Button ID="update" CommandName="update" runat="server" Text="Update"/>
<asp:Button ID="cancel" runat="server" CommandName="cancel" Text="Cancel"/>
</EditItemTemplate>
<FooterTemplate><hr></FooterTemplate>
</asp:DataList></div>
</form>
<div>
<asp:DataList ID="dlEditItem" runat="server" DataKeyField="EmployeeID" OnCancelCommand="dlEditItem_CancelCommand" OnEditCommand="dlEditItem_EditCommand" OnUpdateCommand="dlEditItem_UpdateCommand">
<HeaderTemplate>人员信息</HeaderTemplate>
<ItemTemplate>
<asp:Button ID="edit" runat="server" Text="Edit" CommandName="Edit"/><%# Eval("LastName")%><%# Eval("FirstName")%>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lastname" runat="server"><%# Eval("LastName")%></asp:Label>
<asp:Label ID="firstname" runat="server"><%#Eval("FirstName") %></asp:Label>
<asp:TextBox ID="title" runat="server" Text='<%#Eval("Title") %>'></asp:TextBox>
<asp:Button ID="update" CommandName="update" runat="server" Text="Update"/>
<asp:Button ID="cancel" runat="server" CommandName="cancel" Text="Cancel"/>
</EditItemTemplate>
<FooterTemplate><hr></FooterTemplate>
</asp:DataList></div>
</form>
后台:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 DataListEditItem : System.Web.UI.Page
...{
protected void Page_Load(object sender, EventArgs e)
...{
if (!IsPostBack)
DataListDataBind();
}
private void DataListDataBind()
...{
string connStr = ConfigurationManager.ConnectionStrings["northwind"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
SqlDataAdapter Adapter = new SqlDataAdapter("select employeeid,lastname, firstname, title from employees", conn);
conn.Open();
DataSet ds = new DataSet();
try
...{
Adapter.Fill(ds, "testTable");
dlEditItem.DataSource = ds.Tables["testTable"].DefaultView;
dlEditItem.DataBind();
}
catch (Exception error)
...{
Response.Write(error.ToString());
}
finally
...{
conn.Close();
}
}
protected void dlEditItem_CancelCommand(object source, DataListCommandEventArgs e)
...{
dlEditItem.EditItemIndex = -1;
DataListDataBind();
}
protected void dlEditItem_EditCommand(object source, DataListCommandEventArgs e)
...{
dlEditItem.EditItemIndex = e.Item.ItemIndex;
DataListDataBind();
}
protected void dlEditItem_UpdateCommand(object source, DataListCommandEventArgs e)
...{
int empID = (int)dlEditItem.DataKeys[e.Item.ItemIndex];
TextBox newTitle = (TextBox)e.Item.FindControl("title");
string strUpt = "update employees set title ='" + newTitle.Text + "' where employeeid=" + empID.ToString();
string connStr = ConfigurationManager.ConnectionStrings["northwind"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(strUpt, conn);
conn.Open();
try
...{
cmd.ExecuteNonQuery();
dlEditItem.EditItemIndex = -1;
DataListDataBind();
}
catch(Exception error)
...{
Response.Write(error.ToString());
}
finally
...{
conn.Close();
}
}
}
using System.Data;
using System.Configuration;
using System.Collections;
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 DataListEditItem : System.Web.UI.Page
...{
protected void Page_Load(object sender, EventArgs e)
...{
if (!IsPostBack)
DataListDataBind();
}
private void DataListDataBind()
...{
string connStr = ConfigurationManager.ConnectionStrings["northwind"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
SqlDataAdapter Adapter = new SqlDataAdapter("select employeeid,lastname, firstname, title from employees", conn);
conn.Open();
DataSet ds = new DataSet();
try
...{
Adapter.Fill(ds, "testTable");
dlEditItem.DataSource = ds.Tables["testTable"].DefaultView;
dlEditItem.DataBind();
}
catch (Exception error)
...{
Response.Write(error.ToString());
}
finally
...{
conn.Close();
}
}
protected void dlEditItem_CancelCommand(object source, DataListCommandEventArgs e)
...{
dlEditItem.EditItemIndex = -1;
DataListDataBind();
}
protected void dlEditItem_EditCommand(object source, DataListCommandEventArgs e)
...{
dlEditItem.EditItemIndex = e.Item.ItemIndex;
DataListDataBind();
}
protected void dlEditItem_UpdateCommand(object source, DataListCommandEventArgs e)
...{
int empID = (int)dlEditItem.DataKeys[e.Item.ItemIndex];
TextBox newTitle = (TextBox)e.Item.FindControl("title");
string strUpt = "update employees set title ='" + newTitle.Text + "' where employeeid=" + empID.ToString();
string connStr = ConfigurationManager.ConnectionStrings["northwind"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(strUpt, conn);
conn.Open();
try
...{
cmd.ExecuteNonQuery();
dlEditItem.EditItemIndex = -1;
DataListDataBind();
}
catch(Exception error)
...{
Response.Write(error.ToString());
}
finally
...{
conn.Close();
}
}
}
- 在ASP.NET 2.0 下如何实现DataList的编辑功能
- 实现DataList的编辑功能
- 如何让DataList具有分页的功能(asp.net)
- 如何让DataList具有分页的功能 2(asp.net)
- Asp.net DataList嵌套DataList的实现
- ASP.NET中运用DataList控件来实现编辑、更新、删除、取消等功能
- asp.net DataList实现分页功能
- Scott Mitchell 的ASP.NET 2.0数据教程之三十六:: 综叙:在DataList里编辑和删除数据
- Scott Mitchell 的ASP.NET 2.0数据教程之三十六:: 综叙:在DataList里编辑和删除数据
- Scott Mitchell 的ASP.NET 2.0数据教程之三十六:: 综叙:在DataList里编辑和删除数据
- 在ASP.net中是如何实现注销功能的?
- 在asp.net中如何获取asp:DataList中子控件asp:RadioButtonList的值
- ASP.net datalist,gridview 编辑模板里面控件的使用;
- Scott Mitchell 的ASP.NET 2.0数据教程之四十:: 自定义DataList编辑界面
- Scott Mitchell 的ASP.NET 2.0数据教程之四十:: 自定义DataList编辑界面
- asp.net使用for循环实现Datalist的分列显示功能
- ASP.NET:DataList控件的选择输入功能
- ASP.NET中DataList控件如何实现嵌套?
- 封装原有C++程序为可引用的.NET组件的方法
- 我们需要“第二人生”吗?[Second life]
- 如何管理标签?
- 相似度函数的算法-请大家贡献自己的想法
- *BSD迷思
- 在ASP.NET 2.0 下如何实现DataList的编辑功能
- 同学少年多不贱 [咱们的大学生活]
- 程序员和黑客
- 使用 ADO.NET 访问 Oracle 9i 存储过程
- ORACLE函数大全
- HTML颜色代码
- 实施SOA CIO要解决三个重要问题
- 超市开业
- 1111111