我在ListView_ItemUpdating()事件中增加了对数据库的操作,但是没有效果
using (SqlConnection connection = new SqlConnection(System.Web.Configuration.WebConfigurationManager.AppSettings["Conn"].ToString()))
{
using (SqlCommand command = new SqlCommand(sqlStr, connection))
{
command.Parameters.Add("@qxlx", SqlDbType.VarChar, 50);
command.Parameters.Add("@qxbh", SqlDbType.Int, 4);
command.Parameters[0].Value = ddlType.SelectedValue;
command.Parameters[1].Value = Convert.ToInt32(lbbh.Text);
command.Connection.Open();
command.ExecuteNonQuery();
}
}
using (SqlConnection connection = new SqlConnection(System.Web.Configuration.WebConfigurationManager.AppSettings["Conn"].ToString()))
{
using (SqlCommand command = new SqlCommand(sqlStr, connection))
{
command.Parameters.Add("@qxlx", SqlDbType.VarChar, 50);
command.Parameters.Add("@qxbh", SqlDbType.Int, 4);
command.Parameters[0].Value = ddlType.SelectedValue;
command.Parameters[1].Value = Convert.ToInt32(lbbh.Text);
command.Connection.Open();
command.ExecuteNonQuery();
}
}
protected void ListView1_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
//获取ListView中的DropDownList控件
DropDownList ddlType = (DropDownList)ListView1.Items[e.ItemIndex].FindControl("ddlType");
//e.NewValues["qxlx"] = ddlType.SelectedValue;
ddlType.SelectedValue =(string)e.OldValues["qxlx"];
Label lbbh = (Label)ListView1.Items[e.ItemIndex].FindControl("qxbhLabel1");
/*将选择的项更新会数据库*/
string sqlStr = "update T_qixie set qxlx=@qxlx where qxbh=@qxbh";
//string sqlStr = "update T_qixie set qxlx='ccf' where qxbh=30";
using (SqlConnection connection = new SqlConnection(System.Web.Configuration.WebConfigurationManager.AppSettings["Conn"].ToString()))
{
using (SqlCommand command = new SqlCommand(sqlStr, connection))
{
command.Parameters.Add("@qxlx", SqlDbType.VarChar,50);
command.Parameters.Add("@qxbh", SqlDbType.Int, 4);
command.Parameters[0].Value = ddlType.SelectedValue;
command.Parameters[1].Value = Convert.ToInt32(lbbh.Text);
command.Connection.Open();
command.ExecuteNonQuery();
}
}
}
不是应该用吗?ItemUpdating是点修改时发生,是用来绑定数据的;
ItemUpdated是修改完,点保存时发生的
ItemUpdating是点击更新的时候用的,我认为没什么区别,刚刚上网听说好像是ms的bug
LZ啊,好好再看看关于SQL的书籍吧,按照你的描述,我的理解为:执行了你的程序之后,数据库里未多出一行新增的记录。如果是这样的话,那你的SQL语句错的太厉害了。update != insert。你这条语句还有个where,如果这个where不满足,则该语句压根就不会执行update,因此没事发生是很正常的。