代码如下.
谢谢帮忙看下啊//----------------------------------using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;public partial class _Default : System.Web.UI.Page
{
protected System.Data.OleDb.OleDbConnection Conn;
protected System.Data.OleDb.OleDbCommand Comm;
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);
}
}
谢谢帮忙看下啊//----------------------------------using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;public partial class _Default : System.Web.UI.Page
{
protected System.Data.OleDb.OleDbConnection Conn;
protected System.Data.OleDb.OleDbCommand Comm;
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);
}
}
解决方案 »
- 刚参加工作的应届菜鸟求助
- 怎样才能学好asp.net
- 在Web中用MSNPSharp获取好友时,为什么用VS浏览时可以获取,而用IIS打开的网页就获取不到呢?
- 请问,在ASP。NET中<%......%>与 <script...></script>这两个标记有什么区别???
- datalist的itemdatabound事件
- 页面中敲会车缩定某一个按钮事件如何实现
- 发现个好的支持 .net 的免费空间
- 调用问题
- 老问题:如何绑定DataGrid控件中的CheckBox?
- 用VS.NET开发用户自定义控件如何显示在其属性工具栏中。
- <% if(setDisplay.Text.Equals("Y")){ %> 如何用变量代替
- 数据显示问题,在线等待中
你注释掉了
我吧这个设置为
Comm.ExecuteNonQuery();
就提示我是这里出错,说是
INSERT INTO 语句的语法错误。
但是我看那个语句是对的啊,晕的我.
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);
zhqs1000(子鱼)
xinke_li(科科) 是因为那个表名的事情,是要加上[]才行的,但是这里我看别人的程序有的不写就可以执行,是为什么啊?
//我刚注册这里,我研究下,杂给加分,马上就好.