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语句语法错误
{
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语句语法错误
解决方案 »
- PDF文件显示在iframe中,有没有办法调用adobe的print,在页面按钮上点打印,能弹出打印窗口?
- 秒杀系统中,用什么存储记录倒计时数值,实现所有人统一
- SQL 2005
- 0x01769bc0错误,大神请进。
- 二级域名中title的问题
- ★★★★★ASP.NET调用ActiveX的问题,马上给分★★★★★
- 求助! 关于ASP.NET
- ☆★☆★用数据集更新/插入记录的简单问题,大家快来帮忙呀!
- 问应用程序使用权限的问题?
- 关于 Html.ActioinLink
- 用.NET自带的工具以“Web安装项目”方式生成的msi安装包安装过程会中断退出,求教~
- 在 c# 里面 导数据到 EXCEl 速度慢是怎么回事 ?
copy到Access的查询里执行下 看什么地方出问题了
{
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)
{
string tempex=ex.ToString();
Response.Write(ex.ToString());//在此行设置断点,看tempex的具体内容。
}
}
是不是服务器 内存是1T的我也就是知道硬盘刚有1T的 ,弄个用户名密码放里面算是大方的了