using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
datalist();
}
}
private void datalist()
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("select * from admin", DB.conn);
DataSet ds = new DataSet();
sda.Fill(ds, "admin");
this.DataList1.DataKeyField = "id";
this.DataList1.DataSource = ds.Tables["admin"].DefaultView;
this.DataList1.DataBind();
DB.conn.Close();
}
protected void Button1_Click1(object sender, EventArgs e)
{
Response.Write(Application["count"].ToString());
Response.Write("<br>");
Response.Write(Server.MachineName);
Response.Write("<h1>Title</h1>");
Response.Write(Server.UrlEncode("<a href=www.baidu.com>www.baidu.com</a>"));
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "select")
{
this.DataList1.SelectedIndex = e.Item.ItemIndex;
this.datalist();
}
}
protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "edit")
{
this.DataList1.EditItemIndex = e.Item.ItemIndex;
this.datalist();
}
}
protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
{
this.DataList1.EditItemIndex = -1;
this.datalist();
}
protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
{
string id = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
string name = ((TextBox)e.Item.FindControl("txtname")).Text;
try
{
SqlCommand cmd = new SqlCommand("update admin set name='" + name + "'where id='" + id + "'", DB.conn);
DB.conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
DB.conn.Close();
}
}
protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
{
string id = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
try
{
DB.conn.Open();
SqlCommand cmd = new SqlCommand("delete from admin where id='" + id + "'", DB.conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
DB.conn.Close();
}
}
简单实现。