在DropDownList里不能更新权限（UPower）请问是什么问题？？
在DropDownList里不能更新权限（UPower）请问是什么问题？？代码调试通过
<asp:TemplateColumn HeaderText="用户类型">
<ItemTemplate>
<asp:Label id=lbl_upower runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"Upower") %>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:dropdownlist id="ddl_upower" runat="server">
<asp:ListItem Value="1">1</asp:ListItem>
<asp:ListItem Value="2">2</asp:ListItem>
</asp:dropdownlist>
</EditItemTemplate>
</asp:TemplateColumn>
---------------------------------------------------
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.Configuration ;
using System.Data .SqlClient ;
namespace MMS
{
/// <summary>
/// userlist 的摘要说明。
/// </summary>
public class userlist : System.Web.UI.Page
{
protected System.Web.UI.WebControls.HyperLink HyperLink2;
protected System.Web.UI.WebControls.Button btn_search;
protected System.Web.UI.WebControls.TextBox tbx_uid;
protected System.Web.UI.WebControls.HyperLink hlk_citymanage;
protected System.Web.UI.WebControls.DataGrid dgd_userlist;
public void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack) BindGrid();
}
#region Web Form Designer generated code
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.btn_search_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
public void BindGrid()
{ //从文件Web.config中读取连接字符串
string strconn= ConfigurationSettings.AppSettings["dsn"];
//连接本地计算机的MMS数据库
SqlConnection cn= new SqlConnection (strconn);
//创建SqlDataAdapter对象,调用存储过程
SqlDataAdapter da=new SqlDataAdapter ("userlist",cn);
//创建并填充DataSet
DataSet ds=new DataSet ();
da.Fill (ds);
dgd_userlist.DataSource =ds;
dgd_userlist.DataBind ();
cn.Close ();
}
public void DataGrid_Edit(Object sender,DataGridCommandEventArgs E)
{
dgd_userlist.EditItemIndex =(int)E.Item .ItemIndex ;
BindGrid();
}
public void DataGrid_Cancel(Object sender,DataGridCommandEventArgs E)
{
dgd_userlist.EditItemIndex =-1;
BindGrid();
}
public void DataGrid_Update(Object sender,DataGridCommandEventArgs E)
{ //从文件Web.config中读取连接字符串
string strconn= ConfigurationSettings.AppSettings["dsn"];
//连接本地计算机的MMS数据库
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));
//从DateGrid中取得更新内容,Cells [0]为UID列
string uidvalue=E.Item.Cells[1].Text .ToString ();
cm.Parameters ["@UID"].Value =uidvalue;
//从DateGrid中取得更新内容
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();
}
public void DataGrid_Delete(Object sender,DataGridCommandEventArgs E)
{
//从文件Web.config中读取连接字符串
string strconn= ConfigurationSettings.AppSettings["dsn"];
//连接本地计算机的MMS数据库
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 );
//从DateGrid中取得更新内容
//Cells [1]为UID列
string uidvalue=E.Item.Cells [1].Text .ToString ();
cm.Parameters ["@UID"].Value =uidvalue;
cm.ExecuteNonQuery ();
dgd_userlist.EditItemIndex =-1;
BindGrid();
}
public void DataGrid_Page(Object sender,DataGridPageChangedEventArgs E)
{
dgd_userlist.CurrentPageIndex =E.NewPageIndex ;
BindGrid();
}
private void btn_search_Click(object sender, System.EventArgs e)
{
string varuid=tbx_uid.Text .ToString ();
Response.Redirect ("userdetail.aspx?uid="+varuid);
}
}
}
问题点数：0、回复次数：0Top
