代码如下.
谢谢帮忙看下啊
protected void Page_Load(object sender, EventArgs e)
{
String StrConn = "provider=Microsoft.Jet.OLEDB.4.0;data source='" + Server.MapPath(ConfigurationManager.AppSettings["dns"]) + "'";
//连接本地数据库
Conn = new OleDbConnection(StrConn);
//Response.Write(Conn.State);
}
protected void post_Click(object sender, EventArgs e)
{
Conn.Open();
Comm = new OleDbCommand("insert into User (Uname) values ('"+Convert.ToString(Uname.Text.Trim())+"')", Conn);
//Comm.ExecuteNonQuery();
Comm.Dispose();
Conn.Close();
Response.Write("<script language=javascript>alert('添加成功!');</script>");
Label3.Text = Uname.Text + "ok";
Response.Write(Uname.Text);
}
}
xinke_li(科科) ( )
Comm = new OleDbCommand("insert into User (Uname) values ('"+Convert.ToString(Uname.Text.Trim())+"')", Conn);
USER这个表名应该用中括号括起来,改成:
Comm = new OleDbCommand("insert into [User] (Uname) values ('"+Convert.ToString(Uname.Text.Trim())+"')", Conn);
资料来源:http://community.csdn.net/Expert/topic/4728/4728046.xml?temp=.5412104