自己写的读取excel数据，写入到SQL server数据库中的代码

  private   static   void  ExcelToSQL()
         ... {
            string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=E:/test.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1;" ";

            OleDbConnection con = new OleDbConnection(str);
            OleDbCommand cmd = con.CreateCommand();
            cmd.CommandText = "SELECT * FROM [Sheet1$]";
            double id, price, quantity, money;
            string customid, stockid, stockname, type;
            DateTime date;
            
            try
            ...{
                con.Open();
                OleDbDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                ...{
                    id = reader.GetDouble(0);
                    customid = reader.GetString(1);
                    stockid = reader.GetString(2);
                    stockname = reader.GetString(3);
                    type = reader.GetString(4);
                    price = reader.GetDouble(5);
                    quantity = reader.GetDouble(6);
                    money = reader.GetDouble(7);
                    date = reader.GetDateTime(8);


                    historystockDataSetTableAdapters.stockTableAdapter myadapter = new stock.historystockDataSetTableAdapters.stockTableAdapter();
                    myadapter.Insert(id, customid, stockid, stockname, type, price, quantity, money, date);
                }
            }
            catch (Exception ex)
            ...{
                throw new Exception(ex.Message);
            }
            finally
            ...{
                cmd.Dispose();
                con.Close();
            }
            
        }

 这段程序是读取excel数据的，主要是打算读取数据后，对以前买过的股票进行一些分析汇总