C#写入报错

[cc_fq86]

OleDbConnection zx = new OleDbConnection();
zx.ConnectionString = "Provider=Microsoft.jet.oledb.4.0;Data Source=" + ("sicc.mdb");
zx.Open();
OleDbCommand zc = new OleDbCommand("select * from zc where username='"+nametextBox.Text+"'",zx);
int zv = Convert.ToInt32(zc.ExecuteScalar());
if (zv > 0)
{
MessageBox.Show("注册失败此用户名存在", "提示");
zx.Close();
}
else
{

OleDbConnection xc = new OleDbConnection();
xc.ConnectionString = "Provider=Microsoft.jet.oledb.4.0;Data Source=" + ("sicc.mdb");
xc.Open();
OleDbCommand zb = new OleDbCommand("insert into zc values ('" + nametextBox.Text + "','" + pwdtextBox.Text + "','" + cspwdtextBox.Text + "','" + pwdtstextBox.Text + "','" + pwddatextBox.Text + "','" + mailtextBox.Text + "','" + naemmntextBox.Text + "','" + xmtextBox.Text + "','" + xbcomboBox.Text + "','" + sjhmtextBox.Text + "','" + dhtextBox.Text + "','" + zxqxcomboBox.Text + "')", xc);
int xv = Convert.ToInt32(zb.ExecuteNonQuery());
if (xv > 0)
{
this.Hide();
MessageBox.Show("注册成功！", "提示");
xc.Close();
}
else
{
MessageBox.Show("注册失败！", "提示");
}

报错原因:查询值的数目与目标字段中数目不相同

其中:数据库的ID为自动编号,

[lzr4304061988012]

up

[wuyu637]

c#，楼主搞错地方了。

[cc_fq86]

[Quote=引用 2 楼 wuyu637 的回复:]
c#，楼主搞错地方了。
[/Quote]
不好意思.刚才没有看到C#在哪儿呢,就发到这里来了

[lzr4304061988012]

.net技术那

[warrior]

将
OleDbCommand zb = new OleDbCommand("insert into zc values ('" + nametextBox.Text + "','" + pwdtextBox.Text + "','" + cspwdtextBox.Text + "','" + pwdtstextBox.Text + "','" + pwddatextBox.Text + "','" + mailtextBox.Text + "','" + naemmntextBox.Text + "','" + xmtextBox.Text + "','" + xbcomboBox.Text + "','" + sjhmtextBox.Text + "','" + dhtextBox.Text + "','" + zxqxcomboBox.Text + "')", xc);
改成
OleDbCommand zb = new OleDbCommand("insert into zc (name,pwd,cspwd,pwdts,pwddate,mail,naemmn,xm,xb,sjhm,dh,zxqx) values ('" + nametextBox.Text + "','" + pwdtextBox.Text + "','" + cspwdtextBox.Text + "','" + pwdtstextBox.Text + "','" + pwddatextBox.Text + "','" + mailtextBox.Text + "','" + naemmntextBox.Text + "','" + xmtextBox.Text + "','" + xbcomboBox.Text + "','" + sjhmtextBox.Text + "','" + dhtextBox.Text + "','" + zxqxcomboBox.Text + "')", xc);

红色部分替换成与后面Values相对应的字段名，这样可以跳过ID这个自动编号字段