Access数据库插入记录问题
代码如下:
private void btnSubmit_Click(object sender, System.EventArgs e)
{
string strCustomerName=customerName.Value.Trim();
string strPassword1=Password1.Value.Trim();
string strCompanyName=companyName.Value.Trim();
string strAddress=Address.Value.Trim();
//int intZip=int.Parse(zip.Value.Trim());
int intPhone=int.Parse(phone.Value.Trim());
int intFax=int.Parse(fax.Value.Trim());
string strEmail=email.Value.Trim();
string strCompanyDo=companyDo.Value.Trim();
string strSex=null;
if (Radio1.Checked==true)
strSex=Radio1.Value;
else if (Radio2.Checked==true)
strSex=Radio2.Value;
string strInsert="insert into customer2 (Name,password,company,address,sex,phone,fax,Email,companyDo) values ('"
+strCustomerName+"','"
+strPassword1+"','"
+strCompanyName+"','"
+strAddress+"','"
+strSex+"','"
+intPhone+"','"
+intFax+"','"
+strEmail+"','"
+strCompanyDo
+"')";
string strCon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("database/cailian.mdb");
//string strCon="Provider=SQLOLEDB;user id=sa;password=;database=test;server=c426";
try
{
OleDbConnection myCon=new OleDbConnection(strCon);
OleDbCommand myCom=new OleDbCommand (strInsert,myCon);
myCom.CommandType = CommandType.Text;
myCon.Open();
myCom.ExecuteNonQuery();
myCon.Close();
}
catch(Exception Err)
{
string strErr="<SCRIPT language=\"";
strErr+="JavaScript\"";
strErr+=">Windows.open("+ Err.Message.ToString()+")"+"</SCRIPT>";
Response.Write(strErr);
}
}
执行以后,发现插入记录没有成功,使用调试窗口跟踪,说是INSERT 语句语法错误,但我吧数据库到入SQL上,采用注释的连接串去连SQL,插入确实成功的.那位高人指点一下,问题该怎么解决啊.