protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.Cells[0].HasControls())
{
LinkButton BtnDelete = (LinkButton)e.Row.Cells[0].Controls[2];
LinkButton BtnUpdate = (LinkButton)e.Row.Cells[0].Controls[0];
if (BtnDelete.Text.Equals("删除"))
{
BtnDelete.Attributes.Add("onclick", "javascript:return confirm('" + string.Format("您确认要删除管理员{0}吗?", DataBinder.Eval(e.Row.DataItem, "MessageName")) + "')");
}
if (BtnUpdate.Text.Equals("更新"))
{
BtnUpdate.Attributes.Add("onclick", "javascript:return confirm('" + string.Format("您确认要更新管理员{0}吗?", DataBinder.Eval(e.Row.DataItem, "MessageName")) + "')");
}
}
public static bool DeleteMessage(Message SingleMessage)
{
bool Flage = false;
string procname = "delete from Message where MessageId=@MessageId";
SqlParameter[] prams ={ new SqlParameter("@MessageId", SqlDbType.Int) };
prams[0].Value = SingleMessage.MessageId;
int intResult = DBHelper.ExecuteCommand(procname, prams);
if (intResult > 0)
{
Flage = true;
}
return Flage;
}
public static bool UpdateMessage(Message singleMessage)
{
bool Flage = false;
string procname = "UPDATE [Message] SET [MessageName] = @MessageName, [MessageA] = @MessageA, [MessageTelephone] = @MessageTelephone, [MessageFAX] = @MessageFAX, [MessageE] = @MessageE, [MessageTitle] = @MessageTitle, [MessageGuestbook] = @MessageGuestbook WHERe [MessageId] = @MessageId";
SqlParameter[] prams ={new SqlParameter("@MessageId",SqlDbType.Int),
new SqlParameter("@MessageName",SqlDbType.VarChar,100),
new SqlParameter("@MessageA",SqlDbType.VarChar,100),
new SqlParameter("@MessageTelephone",SqlDbType.VarChar,100),
new SqlParameter("@MessageFAX",SqlDbType.VarChar,100),
new SqlParameter("@MessageE",SqlDbType.VarChar,100),
new SqlParameter("@MessageTitle",SqlDbType.VarChar,100),
new SqlParameter("@MessageGuestbook",SqlDbType.VarChar,1000)};
prams[0].Value = singleMessage.MessageId;
prams[1].Value = singleMessage.MessageName;
prams[2].Value = singleMessage.MessageA;
prams[3].Value = singleMessage.MessageTelephone;
prams[4].Value = singleMessage.MessageFAX;
prams[5].Value = singleMessage.MessageE;
prams[6].Value = singleMessage.MessageTitle;
prams[7].Value = singleMessage.MessageGuestbook;
int intResult = DBHelper.ExecuteCommand(procname,prams);
if (intResult > 0)
{
Flage = true;
}
return Flage;
}
}
为什么 更新和删除没有效果???我的代码哪里有问题吗??
答案:1 悬赏:50 手机版
解决时间 2021-04-24 22:27
- 提问者网友:火车头
- 2021-04-24 16:51
最佳答案
- 五星知识达人网友:长青诗
- 2021-04-24 18:16
更新删除命令不能写到 GridView1_RowDataBound里面 应该写到 GridView1_RowCommand里面
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯