版主 我用insert into values语句怎么修改不了的
OleDbCommand myOleDbCommand = new OleDbCommand("Insert into db2 values('sfd','jkl','hf','jy');", myOleDbConection);

insert into values
是增加字段吧,而且;好象是没有的吧.

对啊 不知道“而且;好象是没有的吧.”是什么意思啊
还请教下

Insert into db2(字段1，字段2，字段3，字段4) values('sfd','jkl','hf','jy')

"Insert into db2 values('sfd','jkl','hf','jy');"
你在SQL查询分析器里能这样写吗
Insert into db2 values('sfd','jkl','hf','jy');
分号可以写吗

这个意思啊

不是；代表语句结束啊

哦,这样啊。知道了.
还有4楼的方法就是你要的啊应该可以的吧

我试过了大侠的方法 但是还是出错啊
不知道为什么啊
string connectionString =
               "provider=Microsoft.Jet.OLEDB.4.0;" +
               "data source=C:\\Documents and Settings\\Administrator.310C7DBA925B462\\桌面\\db2.mdb";
            OleDbConnection myOleDbConection = new OleDbConnection(connectionString);
            OleDbCommand myOleDbCommand = new OleDbCommand("Insert into db2(customerID, CompanyName, contactName, Address) values('sfd','jkl','hf','jy');", myOleDbConection);/*SELECT customerID, CompanyName, contactName, Address "+
"FROM db2 "+
"WHERE (((customerID)='ALFKI'));", myOleDbConection);*/
            
           /* string sql;
            sql = "SELECT customerID, CompanyName, contactName, Address " +
"FROM db2 " +
"WHERE (((customerID)='ALFKI'));" + "CREAT TABLE 学生 (学号 CHAR(5) NOT NULL UNIQUE,姓名 CHAR(8) NOT NULL,年龄 SMALLINT,性别 CHAR(2),所在系 CHAR(20));";// +
//"DEFOAULT C1 20 FOR 年龄，CONSTRAINT C2 CHECK (性别 IN('男','女')));";
            OleDbCommand myOleDbCommand = new OleDbCommand(sql, myOleDbConection);*/


            /*OleDbCommand myOleDbCommand = myOleDbConection.CreateCommand();//new OleDbCommand("select * from db2", myOleDbConection);
             =
                "SELECT customerID,CompanyName,contactName,Adress " +
                "FROM db2 " +
                "WHERE cunstomerID ='ALFKI';";*/
            myOleDbConection.Open();
            OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();

            OleDbCommand myOleDbCommand1 = new OleDbCommand("SELECT customerID, CompanyName, contactName, Address " +
"FROM db2 " +
"WHERE (((customerID)='ALFKI'));", myOleDbConection);
            //myOleDbConection.Open();
            OleDbDataReader myOleDbDataReader1 = myOleDbCommand1.ExecuteReader();

            myOleDbDataReader.Read();
            Console.WriteLine(myOleDbDataReader1["customerID"]);
            Console.WriteLine(myOleDbDataReader1["CompanyName"]);
            Console.WriteLine(myOleDbDataReader1["contactName"]);
            Console.WriteLine(myOleDbDataReader1["Address"]);
            myOleDbDataReader1.Close();
            myOleDbConection.Close();
            string wait = Console.ReadLine();

修改？？？？

INSERT是新增啊，大哥

修改是UPDATE

发的好乱啊.
OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();
是读数据吧.这个命令可以用insert命令吗.
是不是这里出错了