1.数据库ID建:自动编号
2.问题:在注册页面内容不能与数据库的内容,不能对应。
代码: 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("注册失败!", "提示");
}
}
我是新手请多多指教哈,谢谢!!
2.问题:在注册页面内容不能与数据库的内容,不能对应。
代码: 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 用户名,密码。
报错原因:“查询值的数目与目标字段中的数目不同。”
也就是说,页面有“2”个列,数据库有3列。
注册不能成功,
我想问一下,怎样解决这个问题?谢谢哈