//从文件Web.config中读取连接字符串
string strconn = ConfigurationSettings.AppSettings["dsn"];
//连接本地计算机的AUS数据库
SqlConnection cn = new SqlConnection(strconn);
cn.Open();
SqlCommand cm = new SqlCommand("usermodifyForAdmin", cn);//调用存储过程
//将命令类型转为存储类型
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add("@UName", SqlDbType.VarChar);
cm.Parameters.Add(new SqlParameter("@URoleID", SqlDbType.Int));
cm.Parameters.Add("@UState", SqlDbType.VarChar);
//从DateGrid中取得更新内容,Cells [1]为UName列
string uidvalue = E.Item.Cells[1].Text.ToString();
cm.Parameters["@UName"].Value = uidvalue;
//从DateGrid中取得更新内容
string urolevalue = ((DropDownList)E.Item.FindControl("ddl_uroleid")).SelectedItem.Value.ToString();
cm.Parameters["@URoleID"].Value = Convert.ToInt16(urolevalue);
string ustatevalue = ((DropDownList)E.Item.FindControl("ddl_ustate")).SelectedItem.Value.ToString();
cm.Parameters["@UState"].Value = ustatevalue;
cm.ExecuteNonQuery();
dgd_userlist.EditItemIndex = -1;
BindGrid();
string strconn = ConfigurationSettings.AppSettings["dsn"];
//连接本地计算机的AUS数据库
SqlConnection cn = new SqlConnection(strconn);
cn.Open();
SqlCommand cm = new SqlCommand("usermodifyForAdmin", cn);//调用存储过程
//将命令类型转为存储类型
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add("@UName", SqlDbType.VarChar);
cm.Parameters.Add(new SqlParameter("@URoleID", SqlDbType.Int));
cm.Parameters.Add("@UState", SqlDbType.VarChar);
//从DateGrid中取得更新内容,Cells [1]为UName列
string uidvalue = E.Item.Cells[1].Text.ToString();
cm.Parameters["@UName"].Value = uidvalue;
//从DateGrid中取得更新内容
string urolevalue = ((DropDownList)E.Item.FindControl("ddl_uroleid")).SelectedItem.Value.ToString();
cm.Parameters["@URoleID"].Value = Convert.ToInt16(urolevalue);
string ustatevalue = ((DropDownList)E.Item.FindControl("ddl_ustate")).SelectedItem.Value.ToString();
cm.Parameters["@UState"].Value = ustatevalue;
cm.ExecuteNonQuery();
dgd_userlist.EditItemIndex = -1;
BindGrid();
http://blog.csdn.net/Freeze_Soul/article/details/1775741
你什么时候能够看到 BindGrid 这类很低级的代码呢?
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "链接字符串";
cn.Open();
int value;
try
{
SqlCommand cmd = new SqlCommand(cmdtext, cn);
value = cmd.ExecuteNonQuery() > 0 ? 1 : 0;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
return value;
}
看看数据库里的数据更新没有。
如果更新了 取出来绑定。