自己写的读取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数据的，主要是打算读取数据后，对以前买过的股票进行一些分析汇总