using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
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.Data.SqlClient;
using System.Configuration;
namespace WebApplication1
{
/// <summary>
/// userlist 的摘要说明。
/// </summary>
public class userlist : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid dgd_userlist;
protected System.Web.UI.WebControls.TextBox txb_uid;
protected System.Web.UI.WebControls.Button btn_search;
protected System.Web.UI.WebControls.HyperLink hlk_citylist;
protected System.Web.UI.WebControls.HyperLink HyperLink2; private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)BindGrid();
// 在此处放置用户代码以初始化页面
}
public void BindGrid()
{
string strconn=ConfigurationSettings.AppSettings["dsn"];
SqlConnection cn=new SqlConnection(strconn);
cn.Open();
SqlDataAdapter da=new SqlDataAdapter("userlist",cn);
DataSet ds=new DataSet();
da.Fill(ds);
dgd_userlist.DataSource=ds;
dgd_userlist.DataBind();
cn.Close();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btn_search.Click += new System.EventHandler(this.Page_Load);
this.dgd_userlist.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgd_userlist_PageIndexChanged);
this.dgd_userlist.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgd_userlist_EditCommand);
this.dgd_userlist.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgd_userlist_UpdateCommand);
this.dgd_userlist.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgd_userlist_DeleteCommand);
this.dgd_userlist.Load += new System.EventHandler(this.Page_Load);
this.dgd_userlist.SelectedIndexChanged += new System.EventHandler(this.dgd_userlist.SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void dgd_userlist_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dgd_userlist.EditItemIndex=(int)e.Item.ItemIndex;
BindGrid();
} private void dgd_userlist_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string strconn=ConfigurationSettings.AppSettings["dsn"];
SqlConnection cn=new SqlConnection(strconn);
cn.Open();
SqlCommand cm=new SqlCommand("usermodifyForAdmin",cn);
cm.CommandType=CommandType.StoredProcedure;
cm.Parameters.Add("@UID",SqlDbType.VarChar);
cm.Parameters.Add(new SqlParameter("@UPower",SqlDbType.Int));
string uidvalue=e.Item.Cells[1].Text.ToString();
cm.Parameters["@UID"].Value=uidvalue;
string upowervalue=((DropDownList)e.Item.FindControl
("ddl_upower")).SelectedItem.Value.ToString();
cm.Parameters["@UPower"].Value=Convert.ToInt16(upowervalue);
cm.ExecuteNonQuery();
dgd_userlist.EditItemIndex=-1;
BindGrid();
} private void dgd_userlist_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string strconn=ConfigurationSettings.AppSettings["dsn"];
SqlConnection cn=new SqlConnection(strconn);
cn.Open();
string userdelete="delete * from users where UID=@UID ";
SqlCommand cm=new SqlCommand(userdelete,cn);
cm.Parameters.Add("@UID",SqlDbType.VarChar);
string uidvalue=e.Item.Cells[1].Text.ToString();
cm.Parameters["@UID"].Value=uidvalue;
cm.ExecuteNonQuery();
dgd_userlist.EditItemIndex=-1;
BindGrid();
} private void dgd_userlist_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgd_userlist.CurrentPageIndex=e.NewPageIndex;
BindGrid();
} private void btn_searchClick(object sender, System.EventArgs e)
{
string varuid=txb_uid.Text.ToString();
Response.Redirect("userdetail.aspx?uid="+varuid);
}
}
}出错提示!c:\inetpub\wwwroot\WebApplication1\userlist.aspx.cs(69): 事件“System.Web.UI.WebControls.BaseDataList.SelectedIndexChanged”只能出现在 += 或 -= 的左边
using System.Collections;
using System.ComponentModel;
using System.Data;
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.Data.SqlClient;
using System.Configuration;
namespace WebApplication1
{
/// <summary>
/// userlist 的摘要说明。
/// </summary>
public class userlist : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid dgd_userlist;
protected System.Web.UI.WebControls.TextBox txb_uid;
protected System.Web.UI.WebControls.Button btn_search;
protected System.Web.UI.WebControls.HyperLink hlk_citylist;
protected System.Web.UI.WebControls.HyperLink HyperLink2; private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)BindGrid();
// 在此处放置用户代码以初始化页面
}
public void BindGrid()
{
string strconn=ConfigurationSettings.AppSettings["dsn"];
SqlConnection cn=new SqlConnection(strconn);
cn.Open();
SqlDataAdapter da=new SqlDataAdapter("userlist",cn);
DataSet ds=new DataSet();
da.Fill(ds);
dgd_userlist.DataSource=ds;
dgd_userlist.DataBind();
cn.Close();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btn_search.Click += new System.EventHandler(this.Page_Load);
this.dgd_userlist.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgd_userlist_PageIndexChanged);
this.dgd_userlist.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgd_userlist_EditCommand);
this.dgd_userlist.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgd_userlist_UpdateCommand);
this.dgd_userlist.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgd_userlist_DeleteCommand);
this.dgd_userlist.Load += new System.EventHandler(this.Page_Load);
this.dgd_userlist.SelectedIndexChanged += new System.EventHandler(this.dgd_userlist.SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void dgd_userlist_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dgd_userlist.EditItemIndex=(int)e.Item.ItemIndex;
BindGrid();
} private void dgd_userlist_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string strconn=ConfigurationSettings.AppSettings["dsn"];
SqlConnection cn=new SqlConnection(strconn);
cn.Open();
SqlCommand cm=new SqlCommand("usermodifyForAdmin",cn);
cm.CommandType=CommandType.StoredProcedure;
cm.Parameters.Add("@UID",SqlDbType.VarChar);
cm.Parameters.Add(new SqlParameter("@UPower",SqlDbType.Int));
string uidvalue=e.Item.Cells[1].Text.ToString();
cm.Parameters["@UID"].Value=uidvalue;
string upowervalue=((DropDownList)e.Item.FindControl
("ddl_upower")).SelectedItem.Value.ToString();
cm.Parameters["@UPower"].Value=Convert.ToInt16(upowervalue);
cm.ExecuteNonQuery();
dgd_userlist.EditItemIndex=-1;
BindGrid();
} private void dgd_userlist_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string strconn=ConfigurationSettings.AppSettings["dsn"];
SqlConnection cn=new SqlConnection(strconn);
cn.Open();
string userdelete="delete * from users where UID=@UID ";
SqlCommand cm=new SqlCommand(userdelete,cn);
cm.Parameters.Add("@UID",SqlDbType.VarChar);
string uidvalue=e.Item.Cells[1].Text.ToString();
cm.Parameters["@UID"].Value=uidvalue;
cm.ExecuteNonQuery();
dgd_userlist.EditItemIndex=-1;
BindGrid();
} private void dgd_userlist_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgd_userlist.CurrentPageIndex=e.NewPageIndex;
BindGrid();
} private void btn_searchClick(object sender, System.EventArgs e)
{
string varuid=txb_uid.Text.ToString();
Response.Redirect("userdetail.aspx?uid="+varuid);
}
}
}出错提示!c:\inetpub\wwwroot\WebApplication1\userlist.aspx.cs(69): 事件“System.Web.UI.WebControls.BaseDataList.SelectedIndexChanged”只能出现在 += 或 -= 的左边
解决方案 »
- C# winform中的Paint事件为什么执行不止一次啊
- return 语句之后还行紧接着执行功能该怎么办
- 如何开发一套wpf程序,同时用在桌面和WEB上
- 求助:C#中如何对报表进行分页!
- 求深入浅出c#程序设计-林邦杰-光盘的资源-只要每章的源代码
- SQL.与.NET连接问题.非常谢谢谢谢.高分!!!
- C#执行CMD的命令有权限问题?
- [请教]数据访问层设计基础问题
- 我的.NET环境中,为什么没有窗体的Closed和Closing事件?请高手指点!
- 对斑竹的强烈建议!!!
- 急!!如何利用XML在SQL2000中查询数据并在Winform中应用!!!
- (winform)如何判断dataset中某个表的内容是否变化了?
new System.EventHandler()括号里面应该是一个处理函数才对