对ACCESS数据库进行添加操作有问题,会的请进
为了完成插入操作,我建了三个类:person.cs用来建参数,operateperson.cs用来进行操作代码的编写,还有个loginuser.cs是复用的连接数据库类.
person.cs类中我定义了几个参数:
public string account;
public string password;
public string name;
public string user_no;
public string e_mail;
public string sex;
operateperson.cs类中我写了插入的代码:
public static bool insertOperate(person p)
{
try
{
OleDbConnection objectConnection=loginuser.CreateConnection();
objectConnection.Open();
OleDbCommand cmd=new OleDbCommand("insert into DB values('"+p.account+"','"+p.password+"','"+p.user_no+"','"+p.name+"','"+p.e_mail+"','"+p.sex+"')",objectConnection);
OleDbParameter para=new OleDbParameter("@paccount",OleDbType.VarChar);
para.Value=p.account;
cmd.Parameters.Add(para);
para=new OleDbParameter ("@password",OleDbType.VarChar);
para.Value=p.password;
cmd.Parameters.Add(para);
para=new OleDbParameter("@name",OleDbType.VarChar);
para.Value=p.name;
cmd.Parameters.Add(para);
para=new OleDbParameter("@user_no",OleDbType.VarChar);
para.Value=p.user_no;
cmd.Parameters.Add(para);
para=new OleDbParameter("@e_mail",OleDbType.VarChar);
para.Value=p.e_mail;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
return true;
}
catch(Exception E)
{
return false;
}
}
loginuser.cs类用来连接:
public static OleDbConnection CreateConnection()
{
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;Data Source=E:\\Inetpub\\wwwroot\\business\\loginManage.mdb;";
OleDbConnection objConnection=new OleDbConnection(strConnection);
return objConnection;
}
最后是主页面上的:
private void finish_Click(object sender, System.EventArgs e)
{
person p=new person();
p.account=this.username.Text;
p.password=this.key1.Text;
p.user_no=this.user_no.Text;
p.e_mail=this.e_mail.Text;
p.name=this.name.Text;
if (this.man.Checked)
{
p.sex="男";
}
else
{
p.sex="女";
}
if (operateperson.insertOperate(p))
{
Response.Write("插入成功");
}
else
{
Response.Write("插入失败");
}
}
ACCESS中的字段分别是account, password, name, user_no, e_mail, sex
执行后一直提示插入失败,不知道为什么?求教!!!!