Question

asp.net update语句

protected void Button3_Click(object sender, EventArgs e)
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=D:\WebSite2\App_Data\kaoqin.mdb";
OleDbConnection conn = new OleDbConnection(strConnection);
conn.Open();
string sql = "update student set s_password='" + this.TextBox6.Text + "' where s_name= '" + this.TextBox1.Text + "'" ;
我接下来的代码有错，下面我想实现对数据库的修改，还有提示修改成功，和修改失败的提示，请哪位高手帮忙补全下。

Answer 1

string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=D:\WebSite2\App_Data\kaoqin.mdb";
conn.Open();
try
{
string sql = "update student set s_password='" + this.TextBox6.Text + "' where s_name= '" + this.TextBox1.Text + "'" ;

OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.ExecuteNonQuery();
Response.Write("<script>alert('成功！')</script>");//这里写成功的语句
}
catch
{
Response.Write("<script>alert('失败！')</script>");//提示错误
}
finally
{
conn.Closed();
}

Answer 2

楼上应该是可以的，不过还是不要把链接数据库写在控件的事件里，应该自定义一个类来放数据的各种操作，页面里再调用就可以了。这样可以提高代码的重用和可读性与性能