调试易

OleDbCommand comm = new OleDbCommand(str, conn);
         int val = comm.ExecuteNonQuery();

ADO.NET为什么不用？？？？？？？没用过那个。
在网上找的例子class Program
    {
        private static ADODB.Connection cn;
        private static ADODB.Recordset rs;
        static void Main(string[] args)
        {
            string strConn = @"PROVIDER=SQLOLEDB;SERVER=WANGQINGKUN\SQLEXPRESS;DATABASE=wxd;UID=sa;PWD=password";
            cn = new ADODB.Connection();
            cn.ConnectionString = strConn;            //打开数据库
            try
            {
                cn.Open(strConn, "sa", "password", -1);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                Console.WriteLine(cn.State);
            }
            //打开记录集
            rs = new ADODB.Recordset();
            string sql = "select * from Admin";
            rs.Open(sql, cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, (int)ADODB.CommandTypeEnum.adCmdText);
            //如果记录集为空，输出一个错误信息
            if (rs.BOF || rs.EOF)
            {
                Console.WriteLine("没有找到任何记录，请检查你的sqlserver的表！");
                throw new Exception("没有找到任何记录，请检查你的sqlserver的表！");
            }
            //循环输出Address
            Console.WriteLine("---原始记录集:");
            while (!rs.EOF)
            {
                Console.WriteLine(rs.Fields["Address"].Value.ToString());
                rs.MoveNext();
            }
            //把记录的第一条修改一下
            rs.MoveFirst();
            rs.Update("Address", "上海同济大学");
            rs.Update("Name", "Jack Lee");
            rs.UpdateBatch(ADODB.AffectEnum.adAffectCurrent);
            //在记录集的最后添加一条新纪录
            rs.MoveLast();
            object[] objOne = new object[8];
            objOne[0] = "CID";
            objOne[1] = "Name";
            objOne[2] = "Sex";
            objOne[3] = "Address";
            objOne[4] = "Post";
            objOne[5] = "Price";
            objOne[6] = "Birth";
            objOne[7] = "Bool";
            object[] objTwo = new object[8];
            objTwo[0] = "18";
            objTwo[1] = "Steven Bobs";
            objTwo[2] = "male";
            objTwo[3] = "西雅图Microsoft";
            objTwo[4] = "200000";
            objTwo[5] = "12.5";
            objTwo[6] = "1";
            objTwo[7] = "1";
            rs.AddNew(objOne, objTwo);
            //再把记录集滚动最前面，重新输出记录集
            rs.MoveFirst();
            Console.WriteLine("---更改了第一行，又添加了新行的记录集：");
            while (!rs.EOF)
            {
                Console.WriteLine(rs.Fields["Address"].Value.ToString());
                rs.MoveNext();
            }
            //把记录集还原到原始状态
            rs.MoveFirst();
            rs.Update("Address", "HeNan University");
            rs.Update("Name", "Jim Steven");
            rs.UpdateBatch(ADODB.AffectEnum.adAffectCurrent);
            rs.MoveFirst();
            object dummy;
            sql = "delete Admin where CID=7";
            cn.Execute(sql, out dummy, -1);//向数据源发送SQL语句或运行存储过程
            //如果你向数据源发送的命令要求返回记录集，那么记录集对象会自动创建
            Console.WriteLine(dummy);
            //使用ADOCommand对象
            sql = "insert into Admin values(1001,'Jack','female','Haward NewYork','457500','35','0','0')";
            ADODB.Command cmd = new ADODB.Command();
            cmd.ActiveConnection = cn;
            cmd.CommandText = sql;
            cmd.CommandType = ADODB.CommandTypeEnum.adCmdText;
            cmd.Execute(out dummy, ref dummy, -1);
            Console.WriteLine(dummy);
            rs.Close();
            cn.Close();
            Console.ReadLine();
        }