using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace note
{
/// <summary>
/// WebForm2 的摘要说明。
/// </summary>
public class WebForm2 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.LinkButton lbback;
protected System.Web.UI.WebControls.DataList DataList;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
BindDataList();
}
}
private void BindDataList()
{
string dsn;
dsn = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
SqlConnection conn = new SqlConnection(dsn);
conn.Open();
SqlCommand comm = new SqlCommand("select * from Note",conn);
SqlDataReader dr = comm.ExecuteReader();
DataList.DataSource = dr;
DataList.DataBind();
dr.Close();
conn.Close();
}
private void DataList_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
int id;
if(e.CommandName == "select")
DataList.SelectedIndex =e.Item.ItemIndex;
if(e.CommandName == "update")
id = (int)DataList.DataKeys[e.Item.ItemIndex];
if(e.CommandName == "unselect")
DataList.SelectedIndex = -1;
if(e.CommandName == "delete")
{
id = (int)DataList.DataKeys[e.Item.ItemIndex];
//Application["count"] = (object)id;
Response.Redirect(" http://localhost/zxq2/YesorNo.aspx?ID =" + id);
}
//Response.Write(Request.QueryString["ID"]);
BindDataList();
}
private void DataList_EditCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
DataList.EditItemIndex = e.Item.ItemIndex;
BindDataList();
}
{
/// <summary>
/// WebForm2 的摘要说明。
/// </summary>
public class WebForm2 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.LinkButton lbback;
protected System.Web.UI.WebControls.DataList DataList;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
BindDataList();
}
}
private void BindDataList()
{
string dsn;
dsn = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
SqlConnection conn = new SqlConnection(dsn);
conn.Open();
SqlCommand comm = new SqlCommand("select * from Note",conn);
SqlDataReader dr = comm.ExecuteReader();
DataList.DataSource = dr;
DataList.DataBind();
dr.Close();
conn.Close();
}
private void DataList_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
int id;
if(e.CommandName == "select")
DataList.SelectedIndex =e.Item.ItemIndex;
if(e.CommandName == "update")
id = (int)DataList.DataKeys[e.Item.ItemIndex];
if(e.CommandName == "unselect")
DataList.SelectedIndex = -1;
if(e.CommandName == "delete")
{
id = (int)DataList.DataKeys[e.Item.ItemIndex];
//Application["count"] = (object)id;
Response.Redirect(" http://localhost/zxq2/YesorNo.aspx?ID =" + id);
}
//Response.Write(Request.QueryString["ID"]);
BindDataList();
}
private void DataList_EditCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
DataList.EditItemIndex = e.Item.ItemIndex;
BindDataList();
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.lbback.Click += new System.EventHandler(this.lbback_Click);
this.DataList.ItemCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList_ItemCommand);
this.DataList.EditCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList_EditCommand);
this.DataList.UpdateCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList_UpdateCommand);
this.Load += new System.EventHandler(this.Page_Load);
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.lbback.Click += new System.EventHandler(this.lbback_Click);
this.DataList.ItemCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList_ItemCommand);
this.DataList.EditCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList_EditCommand);
this.DataList.UpdateCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList_UpdateCommand);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
#endregion
private void DataList_UpdateCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
string strID;
strID = DataList.DataKeys[(int)e.Item.ItemIndex].ToString();
TextBox txtName = (TextBox)e.Item.FindControl("txtName");
TextBox txtEmail = (TextBox)e.Item.FindControl("txtEmail");
TextBox txtText = (TextBox)e.Item.FindControl("txtText");
string dsn;
dsn = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
SqlConnection connUpdate = new SqlConnection(dsn);
SqlCommand commUpdate = new SqlCommand("update Note set UserName=@valUserName,Email=@valEmail,PostTime=@valPostTime,Text=@valText where ID=@valID",connUpdate);
{
string strID;
strID = DataList.DataKeys[(int)e.Item.ItemIndex].ToString();
TextBox txtName = (TextBox)e.Item.FindControl("txtName");
TextBox txtEmail = (TextBox)e.Item.FindControl("txtEmail");
TextBox txtText = (TextBox)e.Item.FindControl("txtText");
string dsn;
dsn = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
SqlConnection connUpdate = new SqlConnection(dsn);
SqlCommand commUpdate = new SqlCommand("update Note set UserName=@valUserName,Email=@valEmail,PostTime=@valPostTime,Text=@valText where ID=@valID",connUpdate);
commUpdate.Parameters.Add( "@valID", SqlDbType.Int);
commUpdate.Parameters.Add( "@valUserName", SqlDbType.VarChar );
commUpdate.Parameters.Add("@valEmail",SqlDbType.VarChar);
commUpdate.Parameters.Add("@valPostTime",SqlDbType.SmallDateTime);
commUpdate.Parameters.Add("@valText",SqlDbType.Text);
commUpdate.Parameters["@valID"].Value = strID;
commUpdate.Parameters["@valUserName"].Value = txtName.Text;
commUpdate.Parameters["@valEmail"].Value = txtEmail.Text;
commUpdate.Parameters["@valPostTime"].Value = DateTime.Now;
commUpdate.Parameters["@valText"].Value = txtText.Text;
connUpdate.Open();
commUpdate.ExecuteNonQuery();
connUpdate.Close();
DataList.EditItemIndex = -1;
BindDataList();
commUpdate.Parameters.Add( "@valUserName", SqlDbType.VarChar );
commUpdate.Parameters.Add("@valEmail",SqlDbType.VarChar);
commUpdate.Parameters.Add("@valPostTime",SqlDbType.SmallDateTime);
commUpdate.Parameters.Add("@valText",SqlDbType.Text);
commUpdate.Parameters["@valID"].Value = strID;
commUpdate.Parameters["@valUserName"].Value = txtName.Text;
commUpdate.Parameters["@valEmail"].Value = txtEmail.Text;
commUpdate.Parameters["@valPostTime"].Value = DateTime.Now;
commUpdate.Parameters["@valText"].Value = txtText.Text;
connUpdate.Open();
commUpdate.ExecuteNonQuery();
connUpdate.Close();
DataList.EditItemIndex = -1;
BindDataList();
}
private void lbback_Click(object sender, System.EventArgs e)
{
Response.Redirect(" http://localhost/zxq2/index.aspx");
}