我通过gridview传值,将一条记录的信息绑定到textbox中,但是在textbox中更新数据后,点击更新按钮,没有任何改动,数据库中也没有修改。下面是我的代码,大家帮我看看啊
public partial class teacher_diaryDetail : System.Web.UI.Page
{
int id;
//string num;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
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();
conn.Open();
string strcmd = "update tea_diary set title='" + diaryTitle.Text + "',diary='" + diaryContent.Text + "' where ID=" + id;
string strcmda = "update tea_diary set diary='" + diaryContent.Text.Trim() + "' where ID=" + id;
SqlCommand cmd = new SqlCommand(strcmd, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Redirect("diaryInfo.aspx");
}
protected void concel_Click(object sender, EventArgs e)
{
Response.Redirect ("diaryInfo.aspx");
}
}
public partial class teacher_diaryDetail : System.Web.UI.Page
{
int id;
//string num;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
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();
conn.Open();
string strcmd = "update tea_diary set title='" + diaryTitle.Text + "',diary='" + diaryContent.Text + "' where ID=" + id;
string strcmda = "update tea_diary set diary='" + diaryContent.Text.Trim() + "' where ID=" + id;
SqlCommand cmd = new SqlCommand(strcmd, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Redirect("diaryInfo.aspx");
}
protected void concel_Click(object sender, EventArgs e)
{
Response.Redirect ("diaryInfo.aspx");
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货