string cons1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\aaa.mdb;Persist Security Info=False";
string sqlinst = "Insert Into bmxx ([bmh],[xm],[xb]) Value (@bmh,@xm,@xb)";
OleDbConnection mycon1 = new OleDbConnection(cons1);
mycon1.Open();
OleDbCommand mycom1 = new OleDbCommand();
mycom1.Connection = mycon1;
mycom1.CommandType = CommandType.Text;
mycom1.CommandText = sqlinst ;
mycom1.Parameters.Add(new OleDbParameter("@bmh", OleDbType.Char));
mycom1.Parameters.Add(new OleDbParameter("@xm", OleDbType.Char));
mycom1.Parameters.Add(new OleDbParameter("@xb", OleDbType.Char));
DataTable dt1 = dsls.Tables["bmxx"];
for (int i = 0; i < dsls.Tables["bmxx"].Rows.Count; i++)
{ mycom1.Parameters["@bmh"].Value = dt1.Rows[i][1].ToString();
mycom1.Parameters["@xm"].Value = dt1.Rows[i][2].ToString();
mycom1.Parameters["@xb"].Value = dt1.Rows[i][3].ToString();
//sqlinst ="Insert Into bmxx ";
//sqlinst = sqlinst + "([bmh],[xm],[xb]) Value ('" + dt1.Rows[i][1].ToString() + "','" + dt1.Rows[i][2].ToString() + "','" + dt1.Rows[i][3].ToString() + "')"; mycom1.ExecuteNonQuery();
}
mycon1.Close();
总是在 mycom1.ExecuteNonQuery(); 处提示 insert into 语法错误,我已经把字段加上了[],可还是不行!
(bmxx表中只有3个字段,其中bmh为主键)
string sqlinst = "Insert Into bmxx ([bmh],[xm],[xb]) Value (@bmh,@xm,@xb)";
OleDbConnection mycon1 = new OleDbConnection(cons1);
mycon1.Open();
OleDbCommand mycom1 = new OleDbCommand();
mycom1.Connection = mycon1;
mycom1.CommandType = CommandType.Text;
mycom1.CommandText = sqlinst ;
mycom1.Parameters.Add(new OleDbParameter("@bmh", OleDbType.Char));
mycom1.Parameters.Add(new OleDbParameter("@xm", OleDbType.Char));
mycom1.Parameters.Add(new OleDbParameter("@xb", OleDbType.Char));
DataTable dt1 = dsls.Tables["bmxx"];
for (int i = 0; i < dsls.Tables["bmxx"].Rows.Count; i++)
{ mycom1.Parameters["@bmh"].Value = dt1.Rows[i][1].ToString();
mycom1.Parameters["@xm"].Value = dt1.Rows[i][2].ToString();
mycom1.Parameters["@xb"].Value = dt1.Rows[i][3].ToString();
//sqlinst ="Insert Into bmxx ";
//sqlinst = sqlinst + "([bmh],[xm],[xb]) Value ('" + dt1.Rows[i][1].ToString() + "','" + dt1.Rows[i][2].ToString() + "','" + dt1.Rows[i][3].ToString() + "')"; mycom1.ExecuteNonQuery();
}
mycon1.Close();
总是在 mycom1.ExecuteNonQuery(); 处提示 insert into 语法错误,我已经把字段加上了[],可还是不行!
(bmxx表中只有3个字段,其中bmh为主键)
解决方案 »
- C# 类型转换 疑惑
- try...catch...finally到底怎么用?
- 显示网络图片
- 关于如图数据动态显示的问题,请教!
- [100 分] 请教 .NET 中的进度条技术
- winform下,datagrid结合扫描枪定位问题
- 哪位能把这个PDF转化为WORD文件?http://csinjoin.hnu.cn/celeron/a.pdf
- C#生成Excel文件(带有Sheet多选项卡),服务器是否必须安装office?
- 请问在c#里怎样把文本框里的数据写入字符串数组里面啊?
- 求用c#读写文件的示例代码!
- 帅哥们帮帮忙..cmd.ExecuteReader()这个出了问题..
- html的option之间,如何加一条不能被选中的 分隔线
//sqlinst = sqlinst + "([bmh],[xm],[xb]) Values ('" + dt1.Rows[i][1].ToString() + "','" + dt1.Rows[i][2].ToString() + "','" + dt1.Rows[i][3].ToString() + "')"; value那里少个s