我用gridview绑定了以张表格tea_diary,然后通过gridview中的一个按钮将一条每条记录的ID传到另外一个页面的Textbox中以便于修改其中的数据。传值成功了,但是我在Textbox中修改了数据之后,执行,command的更新命令后,发现数据并没有修改,请问这是为什么?要怎么修改?我用Try...catch语句并未捕捉的异常
这次我将一部分代码拷过来了,大家帮帮忙啊
public partial class teacher_diaryDetail : System.Web.UI.Page
{
int id;
//string num;
protected void Page_Load(object sender, EventArgs e)
{
id = (int.Parse)(Request .QueryString ["id"]);
//num = Session["teaID"].ToString();
//num = "123456";
SqlConnection conn = dbaseClass.connCreat();
string strcmd = "select * from tea_diary where ID="+id;
conn.Open();
SqlCommand cmd=new SqlCommand (strcmd ,conn );
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
diaryTitle.Text = dr["title"].ToString();
diaryContent.Text = dr["diary"].ToString();
dr.Close();
conn.Close();
}
protected void edit_Click(object sender, EventArgs e)
{
id = (int.Parse)(Request.QueryString["id"]);
SqlConnection conn = dbaseClass.connCreat();
string strcmda = "update tea_diary set title='" + diaryTitle.Text.Trim() + "',diary='" + diaryContent.Text.Trim() + "'where ID='" +id+"'";
conn.Open ();
SqlCommand cmd=new SqlCommand (strcmda ,conn );
if (cmd.ExecuteNonQuery() > 0)
{
Response.Write("更新成功!");
}
else
{
Response.Write("<script language='javascript'>alert('更新周志失败,请重新更新!')");
}
}
}
这段代码执行后会显示“更新成功”,可是数据库中没有任何变化。。
这次我将一部分代码拷过来了,大家帮帮忙啊
public partial class teacher_diaryDetail : System.Web.UI.Page
{
int id;
//string num;
protected void Page_Load(object sender, EventArgs e)
{
id = (int.Parse)(Request .QueryString ["id"]);
//num = Session["teaID"].ToString();
//num = "123456";
SqlConnection conn = dbaseClass.connCreat();
string strcmd = "select * from tea_diary where ID="+id;
conn.Open();
SqlCommand cmd=new SqlCommand (strcmd ,conn );
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
diaryTitle.Text = dr["title"].ToString();
diaryContent.Text = dr["diary"].ToString();
dr.Close();
conn.Close();
}
protected void edit_Click(object sender, EventArgs e)
{
id = (int.Parse)(Request.QueryString["id"]);
SqlConnection conn = dbaseClass.connCreat();
string strcmda = "update tea_diary set title='" + diaryTitle.Text.Trim() + "',diary='" + diaryContent.Text.Trim() + "'where ID='" +id+"'";
conn.Open ();
SqlCommand cmd=new SqlCommand (strcmda ,conn );
if (cmd.ExecuteNonQuery() > 0)
{
Response.Write("更新成功!");
}
else
{
Response.Write("<script language='javascript'>alert('更新周志失败,请重新更新!')");
}
}
}
这段代码执行后会显示“更新成功”,可是数据库中没有任何变化。。
{
using(SqlConnection conn = dbaseClass.connCreat())
{ conn.Close();
}
}
if (cmd.ExecuteNonQuery() > 0)
好像没有执行命令吧。。
现在是要怎么修改呢