protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection myconn = DB.CreateConnection();
myconn.Open();
string newID1 = Request.QueryString["ID"].ToString();
string sql = "update news set title='" + this.M_Title.Text + "',auther='" + this.M_Auther.Text + "',contents='" + this.M_Contents.Text + "' where ID="+newID1;
OleDbCommand cmd = new OleDbCommand(sql, myconn);
cmd.ExecuteNonQuery();
cmd.Cancel();
this.Button1.Enabled = false;
myconn.Close();
Response.Redirect("defnews.aspx");
}
}这个是更新的点击完没有反映,下个是删除的也是一样点击完没有反映
protected void newsID_Delete(object sender,DataGridCommandEventArgs e)
{
OleDbConnection myconn = DB.CreateConnection();
myconn.Open();
string DnewID = newsID.DataKeys[e.Item.ItemIndex].ToString();
string sql = "delete from news where ID=" + DnewID;
OleDbCommand cmd = new OleDbCommand(sql, myconn);
cmd.ExecuteNonQuery();
myconn.Close();
newsID.DataBind();
}
{
OleDbConnection myconn = DB.CreateConnection();
myconn.Open();
string newID1 = Request.QueryString["ID"].ToString();
string sql = "update news set title='" + this.M_Title.Text + "',auther='" + this.M_Auther.Text + "',contents='" + this.M_Contents.Text + "' where ID="+newID1;
OleDbCommand cmd = new OleDbCommand(sql, myconn);
cmd.ExecuteNonQuery();
cmd.Cancel();
this.Button1.Enabled = false;
myconn.Close();
Response.Redirect("defnews.aspx");
}
}这个是更新的点击完没有反映,下个是删除的也是一样点击完没有反映
protected void newsID_Delete(object sender,DataGridCommandEventArgs e)
{
OleDbConnection myconn = DB.CreateConnection();
myconn.Open();
string DnewID = newsID.DataKeys[e.Item.ItemIndex].ToString();
string sql = "delete from news where ID=" + DnewID;
OleDbCommand cmd = new OleDbCommand(sql, myconn);
cmd.ExecuteNonQuery();
myconn.Close();
newsID.DataBind();
}
如果是03的话很可能是事件丢失了