{

          cn.Open();

          OracleDataAdapter da = new OracleDataAdapter(cmd);

          DataSet ds = new DataSet();

          da.Fill(ds,"TestTable");

          cn.Close();

          int count = ds.Tables["TestTable"].Rows.Count;

          /*打印原始记录*/

          Console.WriteLine("Old Records is:");

          for( int i = 0;i <= count - 1;i++ )

         {

              string id = ds.Tables["TestTable"].Rows[i]["ID"].ToString();

              string name = ds.Tables["TestTable"].Rows[i]["NAME"].ToString();

              string age = ds.Tables["TestTable"].Rows[i]["AGE"].ToString();

              Console.WriteLine("Record {0}:",i+1);

              Console.WriteLine("ID:{0}\tName:{1}\tAge:{2}\n",id,name,age);

         }

         da.SelectCommand = cmd;     //为DataAdapter指定SelectCommand

         OracleCommand updateCmd = new OracleCommand("TestPackage.UpdateRecords",cn);

         updateCmd.CommandType = CommandType.StoredProcedure;

         updateCmd.Parameters.Add("id_in",OracleType.Number,3,"ID");

         updateCmd.Parameters.Add("newName",OracleType.VarChar,20,"NAME");

         updateCmd.Parameters.Add("newAge",OracleType.Number,3,"AGE");

         da.UpdateCommand = updateCmd;        //为DataAdapter指定UpdateCommand

         OracleCommand deleteCmd = new OracleCommand("TestPackage.DeleteRecords",cn);

         deleteCmd.CommandType = CommandType.StoredProcedure;

         deleteCmd.Parameters.Add("id_in",OracleType.Number,3,"ID");

         da.DeleteCommand = deleteCmd;        //为DataAdapter指定DeleteCommand

         OracleCommand insertCmd = new OracleCommand("TestPackage.InsertRecords",cn);

          insertCmd.CommandType = CommandType.StoredProcedure;

 &

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9]  下一页