GridView更新,没报错,怎么就是没成功!
cs代码:
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridView1.DataKeyNames = new string[] { "question_ID" };
QuestionKeep qk = new QuestionKeep();
string Content = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtquestion_content")).Text.ToString().Trim();
string Answer = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtquestion_answer")).Text.ToString().Trim();
string Standard = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtquestion_Standard")).Text.ToString().Trim();
string Express = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtquestion_Express")).Text.ToString().Trim();
string ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
DataSet ds1 = qk.UpdateJudgeQuestion(Content,Answer,Standard,Express, Convert.ToInt32(ID));
GridView1.DataSource = ds1;
GridView1.EditIndex = -1;
bind();
}
void bind()
{
QuestionKeep qk = new QuestionKeep();
DataSet ds1 = qk.judgekeep();
GridView1.DataSource = ds1;
GridView1.DataKeyNames = new string[] { "question_ID" };
GridView1.DataBind();
}
UpdateJudgeQuestion方法:
public DataSet UpdateJudgeQuestion(string question_content, string question_Answer, string question_standard, string question_Express, int question_ID)
{
Exercise exec = new Exercise();
SqlConnection con = exec.getcon();
SqlCommand cmd = new SqlCommand("UpdateJudgeQuestion", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramquestion_content = new SqlParameter("@question_content", SqlDbType.VarChar, 500);
paramquestion_content.Value = question_content;
cmd.Parameters.Add(paramquestion_content);
SqlParameter paramquestion_Answer = new SqlParameter("@question_Answer", SqlDbType.VarChar, 500);
paramquestion_Answer.Value = question_Answer;
cmd.Parameters.Add(paramquestion_Answer);
SqlParameter paramquestion_standard = new SqlParameter("@question_standard", SqlDbType.VarChar, 500);
paramquestion_standard.Value = question_standard;
cmd.Parameters.Add(paramquestion_standard);
SqlParameter paramquestion_Express = new SqlParameter("@question_Express", SqlDbType.VarChar, 500);
paramquestion_Express.Value = question_Express;
cmd.Parameters.Add(paramquestion_Express);
SqlParameter paramquestion_ID = new SqlParameter("@question_ID", SqlDbType.Int);
paramquestion_ID.Value = question_ID;
cmd.Parameters.Add(paramquestion_ID);
DataSet ds = new DataSet();
SqlDataAdapter ada = new SqlDataAdapter(cmd);
ada.Fill(ds);
return ds;
}
存储过程:CREATE PROCEDURE UpdateJudgeQuestion
(@question_content varchar(500),@question_Answer varchar(500),@question_standard varchar(200),
@question_Express varchar(200),@question_ID int)
AS
update judge
set question_content=@question_content
,question_answer=@question_answer,question_standard=@question_standard,question_express=@question_express
where
question_id=@question_id
GO