ServerVersion = “con.ServerVersion”引发了“System.InvalidOperationException”类型的异常 string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=supmar.mdb"; //数据库的链接 OleDbConnection con = new OleDbConnection(conStr);
OleDbCommand com = new OleDbCommand();
com.CommandText = "insert into sales(Serial,商品编号,商品名称,单价,会员价) select (Serial,商品编 号,商品名称,单价,会员价)from goods where 商品编号='3011ea929200fe0000000001'";
com.Connection = con;向各位大侠求救
OleDbCommand com = new OleDbCommand();
com.CommandText = "insert into sales(Serial,商品编号,商品名称,单价,会员价) select (Serial,商品编 号,商品名称,单价,会员价)from goods where 商品编号='3011ea929200fe0000000001'";
com.Connection = con;向各位大侠求救
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM goods where 商品编号='" + ID + "'", con);
DataTable ds = new DataTable();
da.Fill (ds);
dataGridView1.DataSource = dt;程序里执行这段语句是成功的。就是上面那段不成功,郁闷
System.InvalidOperationException内连接错误。http://www.cnblogs.com/wukun52/archive/2008/06/26/1230511.html