请大家帮我看看我这条SQL语句哪错了
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
TextBox1.Text= Session["password"].ToString();
TextBox2.Text = Session["Nickname"].ToString();
TextBox3.Text = Session["Birthday"].ToString();
TextBox4.Text = Session["Education"].ToString();
TextBox5.Text = Session["Title"].ToString();
TextBox6.Text = Session["Post"].ToString();
TextBox7.Text = Session["Unit"].ToString();
TextBox8.Text = Session["OfficePhone"].ToString();
TextBox9.Text = Session["Fax"].ToString();
TextBox10.Text = Session["Email"].ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Provider=Microsoft.Jet.OleDb.4.0;";
str += @"Data Source=" + Server.MapPath("~/App_Data/hxqlorg.mdb");
string UpdateStr = "Update member SET password='" + TextBox1.Text + "',Nickname='" + TextBox2.Text + "',Birthday='" + TextBox3.Text + "', Education='" + TextBox4.Text + "', Title='" + TextBox5.Text + "', Post='" + TextBox6.Text + "',Unit='" + TextBox7.Text + "',OfficePhone='" + TextBox8.Text + "',Fax='" + TextBox9.Text + "',Email='" + TextBox10.Text + "' WHERE Name='" + Session["Name"].ToString() + "'";
OleDbConnection con = new OleDbConnection(str);
//尽可能晚的打开连接,尽早的关闭连接
con.Open();
OleDbCommand com = new OleDbCommand(UpdateStr, con);
int a = com.ExecuteNonQuery();
if (a > 0)
{
Response.Write("<script>alert('更新成功!!')</script>");
}
}catch(Exception ex)
{
Response.Write(ex.ToString());
}
}
执行的时候说我Update语句语法错误