代码无误，却插不进数据库

[liccmouse007]

用.net和access作的，编译通过可是，当输入用户名，密码等等时，却总是出现“添加失败”，
困扰我好几天了，并且我的access数据库也已经加入了everyone 的“写的权限”了,哪位高手能
帮帮忙，真是要抓狂了。。。。
代码如下：using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 Region : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void btnClear_Click(object sender, EventArgs e)
{
tbxLoginName.Text = " ";
tbxBlogName.Text = " ";
tbxPassword.Text = " ";
tbxEmail.Text = " ";
}
protected void btnRegion_Click(object sender, EventArgs e)
{




//string strConnection = "Provider=Microsoft.Jet.OleDb.4.0; ";
//strConnection += @ "Data Source=E:\BLOGDB.mdb ";
OleDbConnection objConnection = new OleDbConnection( "provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Server.MapPath( "BLOG.mdb "));
// OleDbConnection objConnection = new OleDbConnection(strConnection);

try
{if(objConnection .State ==ConnectionState.Closed )
objConnection .Open();
string inn = "insert into USER_INFO (LoginName,Password,BlogName,Email) values( ' "+this.tbxLoginName.Text.Trim()+ " ', ' "+this.tbxPassword.Text.Trim()+ " ', ' "+this.tbxBlogName.Text.Trim()+ " ', ' "+this.tbxEmail.Text.Trim()+ " ') ";

OleDbCommand cmd = new OleDbCommand(inn, objConnection);

// objConnection.Open();
cmd.ExecuteNonQuery();
objConnection.Close();
Response.Write( " <script language=javascript> ");
Response.Write( "alert( '添加成功！ '); ");
//Response.Write( "history.go(-1); ");
Response.Write( " </script> ");
objConnection.Close();

}
catch
{
Response.Write( " <script language=javascript> ");
Response.Write( "alert( '添加失败！ '); ");
//Response.Write( "history.go(-1); ");
Response.Write( " </script> ");
}


}

}

[cpio]

不要try不行吗？运行的时候会到出错的地方中断，这样就知道错误了

这样写小心被注入啊

[hbzy123]

string inn = "insert into USER_INFO (LoginName,[Password],BlogName,Email)
---------
password是关键字.加上"[]"

[boblaw]

樓上正確，[Password]

[heqi915]

樓上正確，password是关键字.加上 "[] "

[ptpa]

up,ms 正解

[jfar1]

在OleDbCommand cmd = new OleDbCommand(inn, objConnection); 加断点 看一下那个string 到底是啥样子, 然后找错.

[gimse7en]

出错了也得objConnection.Close();啊

[wyw1997]

单步运行。跟踪一哈

[yixianggao]

去掉try...catch，把异常信息贴出来！

[as13019625389]

权限问题。。。。。。。。。。。。

[None465465535]

objConnection.Close()怎么调用了2次啊