UC知道急 ！！！ winform ＋access
来源：百度知道 编辑：UC知道 时间：2024/05/08 17:49:03
插入数据时出现问题
未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。
代码是
string sex = this.comboBox1.Text;
string xing = this.textBox1.Text;
string ming = this.textBox2.Text;
if(fu == "" && yo == "" && mi =="")
{
//kong
}
else
{
OleDbConnection conn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Date Source= c:\game.mdb");
string sql="insert into gamep values ('" + sex + " ','" + xing + " ','" + ming + " ')";
OleDbCommand cmd =
new OleDbCommand(sql, conn);
if (conn.State ==ConnectionState.Closed)
{
conn.Open();
}
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.textBox1.Text=ex.Message ;
}
未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。
代码是
string sex = this.comboBox1.Text;
string xing = this.textBox1.Text;
string ming = this.textBox2.Text;
if(fu == "" && yo == "" && mi =="")
{
//kong
}
else
{
OleDbConnection conn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Date Source= c:\game.mdb");
string sql="insert into gamep values ('" + sex + " ','" + xing + " ','" + ming + " ')";
OleDbCommand cmd =
new OleDbCommand(sql, conn);
if (conn.State ==ConnectionState.Closed)
{
conn.Open();
}
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.textBox1.Text=ex.Message ;
}
十有八九是sql错误：
string sql="insert into gamep values ('" + sex + " ','" + xing + " ','" + ming + " ')";
检查gamep 的结构和类型
string sex = this.comboBox1.Text.Replace("'","''"); //最好做一下防止SQL注入
string xing = this.textBox1.Text.Replace("'","''");
string ming = this.textBox2.Text.Replace("'","''");
string sql="insert into gamep(字段1,字段2,字段3) values ('" + sex + " ','" + xing + " ','" + ming + " ')"; //最好指明字段名
gamep 什么结构的 sql INSERT into gamep(列名1，列名2，列名3) values('1','2','3')