LOOK~~~LOOK~~~~...thank you!!

2007-05-22 18:06
2007-05-23 22:44
多谢楼主啦...
2007-05-24 21:43
2007-05-28 11:55
2007-05-28 12:16
2007-05-29 00:14
2007-05-30 09:22
SqlConnection con = DB.CreateConn();
con.Open();
string sqlstr0 = "delete from Teacher_course where Teacher_course.Teacher_id='" + Gv_teach.DataKeys[e.RowIndex].Value.ToString() + "'";
string sqlstr1 = "delete from Teacher where Teacher_id='"+Gv_teach.DataKeys[e.RowIndex].Value.ToString()+"'";
SqlCommand sqlcom0 = new SqlCommand(sqlstr0, con);
sqlcom0.ExecuteNonQuery();
SqlCommand sqlcom1 = new SqlCommand(sqlstr1, con);
sqlcom1.ExecuteNonQuery();
try
{
sqlcom1.ExecuteNonQuery();
Lbl_note.Text = "删除成功";
Lbl_note.Style["color"]="green";
}
catch (SqlException)
{
Lbl_note.Text = "删除失败";
Lbl_note.Style["color"] = "red";
}
sqlcom0.Connection.Close();
sqlcom1.Connection.Close();
St_BindGridView();
多表删除程序与各位讨论一下,能删除但不会执行try语句.有高人指点哈就好了.

2007-05-30 12:51
2007-06-02 19:21
2007-06-02 19:28