개발자 창고

         private DataTable ReadExcelList()
        {
            OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\List.xls;Extended Properties=Excel 8.0");
            OleDbDataAdapter da = new OleDbDataAdapter("select * from  [Sheet1$];", con);
            DataTable dt = new DataTable();
            da.Fill(dt);

            return dt;
        }

가지고 온 DataTable을 SQL에 Insert

private void InsertDB(DataTable dt)
        {
            //dt.Rows[0][0].ToString();
            string strConnection = "Data Source=127.0.0.10\\JK_SQL; User ID=sa; Password=1q2w3e; Database=iViz30";
           
            for (int i = 1; i < dt.Rows.Count; i++)
            {
                string strSQL = String.Format("INSERT INTO TB_JK (A, B, C, D, E, F, G, H, I, J, K, L, M, N, O) VALUES ( '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}' )",
                                            dt.Rows[i][0].ToString(),
                                            dt.Rows[i][1].ToString(),
                                            dt.Rows[i][2].ToString(),
                                            dt.Rows[i][3].ToString(),
                                            dt.Rows[i][4].ToString(),
                                            dt.Rows[i][5].ToString(),
                                            dt.Rows[i][6].ToString(),
                                            dt.Rows[i][7].ToString(),
                                            dt.Rows[i][8].ToString(),
                                            dt.Rows[i][9].ToString(),
                                            dt.Rows[i][10].ToString(),
                                            dt.Rows[i][11].ToString(),
                                            dt.Rows[i][12].ToString(),
                                            dt.Rows[i][13].ToString(), 
                                            dt.Rows[i][14].ToString());

                SqlConnection con = new SqlConnection(strConnection);
                SqlCommand sc = new SqlCommand(strSQL, con);
                con.Open();
               
                sc.ExecuteNonQuery();
                con.Close();
            }

        }