一个问题发了200分? 就没人能解决了吗?????高人呢????

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.OracleClient;

using System.Data.OleDb;

using System.Data.Odbc;

using System.IO;





namespace WindowsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();



        }







        public static DataSet ImportExcel(string file)

        {

            System.IO.FileInfo fileInfo = new FileInfo(file);

            if (!fileInfo.Exists)

                return null;



            string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'";

            OleDbConnection objConn = new OleDbConnection(strConn);

            DataSet dsExcel = new DataSet();

            try

            {

                objConn.Open();

                string strSql = "select * from  [Sheet3$]";

                OleDbDataAdapter odbcExcelDataAdapter = new OleDbDataAdapter(strSql, objConn);

                odbcExcelDataAdapter.Fill(dsExcel);

                return dsExcel;

            }

            catch (Exception ex)

            {

                throw ex;

            }

            finally

            {

                objConn.Close();

            }

        }





        private void button4_Click(object sender, EventArgs e)

        {

            DataSet ds;

            OpenFileDialog openFile = new OpenFileDialog();

            openFile.Multiselect = false;

            openFile.RestoreDirectory = true;

            openFile.Filter = "Text files (*.xls)|*.xls|All files (*.*)|*.*";



            if (openFile.ShowDialog() == DialogResult.OK)

            {

                textBox1.Text = openFile.FileName;

                ds = ImportExcel(openFile.FileName);//获得Excel   

            }

            else

            {

                return;

            }



            int odr = 0;



            OracleConnection conn = new OracleConnection("Data Source=wzinner;Persist Security Info=True;User ID=common;password=common;Unicode=True");        //获得conn连接   





            try

            {

                conn.Open();





                string queryString = "insert into em_transferss_t (transfers_id,transfers_OLDLANDNUM) values (:A,:B)";

                OracleCommand com = new OracleCommand(queryString, conn);



                int dsLength = ds.Tables[0].Rows.Count;// 获得Execle长度



                for (int i = 0; i < dsLength; i++)

                {

                    com.Parameters.Add("A", OracleType.Int32).Value = ds.Tables[0].Rows[i][0];



                    com.Parameters.Add("B", OracleType.VarChar).Value = ds.Tables[0].Rows[i][1];





                    odr = com.ExecuteNonQuery();//提交   







                }

                conn.Close();





                if (odr > 0)

                {

                    MessageBox.Show("成功!");

                    if (MessageBox.Show("确认要更新吗?？", "", MessageBoxButtons.OKCancel) != DialogResult.OK)

                    {

                        conn.Open();

                        int co = 0;

                        string sql = "delete from em_transferss_t";

                        OracleCommand comm = new OracleCommand(sql, conn);

                        co = comm.ExecuteNonQuery();

                        if (co > 0)

                        {

                            MessageBox.Show("数据未上传");

                        }

                    }

                    else

                    {

                        conn.Open();

                        int a = 0;

                        string updatesql = "update (select/*+ BYPASS_UJVC */  em_transfers_t.TRANSFERS_OLDLANDNUM a1,em_transfers_t.TRANSFERS_ID b1,em_transferss_t.TRANSFERS_OLDLANDNUM a2,em_transferss_t.TRANSFERS_ID b2" +

            " from em_transfers_t,em_transferss_t) set a1=a2 where b1 =b2";

                        OracleCommand commm = new OracleCommand(updatesql, conn);

                      a = commm.ExecuteNonQuery();

                       if (a > 0)

                       {

                           MessageBox.Show("数据上传成功!");



                       }

                    }



                }



            }

            catch (Exception ee)

            {

                MessageBox.Show(ee.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

            finally

            {

                conn.Close();

            }





        }

    }

}