C# DB2(ACCESS)数据库显示和插入操作

#region 显示DB2中Excle导入的数据
        /// <summary>
        /// Function: 显示DB2中Excle导入的数据
        /// Author: ZHOU
        /// CreateTime: 2014-04-21
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public DataTable GetExcelDB2()
        {
            try
            {
                DataTable reDt = new DataTable();
                string sql = "select * from ExcelImport";
                return reDt = DB2Helper.Instence.GetDS(sql).Tables[0];
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        #endregion

 

#region 插入Excel表数据到DB2数据库
        /// <summary>
        /// Function: 插入Excel表数据到DB2数据库
        /// Author: ZHOU
        /// CreateTime: 2014-04-21
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public void ExcelInsertDB2(DataTable dt)
        {
            try
            {
                string sql = "";
                string sqlDelete = "DELETE FROM ExcelImport";
                DB2Helper.Instence.SetDS(sqlDelete);
                for (int k = 0; k < dt.Rows.Count; k++)
                {
                    sql = string.Format("INSERT INTO ExcelImport(CartonCode,CartonNum,CartStoreNum, "
                                        + "ContainerNum,CUSTOMER,CUSTOMERPO,PONum,CCutNum,CStyleNum,CColor, "
                                        + "CInnerLength,CPriTicket,CHanger,RatioSize,RatSizQty,TotalQty,POQUTY, "
                                        + "SHIPQUTY,TOTALCARON,Completeornot,Remark) "
                                        + "VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}', "
                                        + "'{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}', "
                                        + "'{20}')",
                                        dt.Rows[k][0].ToString(), dt.Rows[k][1].ToString(), dt.Rows[k][2].ToString(),
                                        dt.Rows[k][3].ToString(), dt.Rows[k][4].ToString(), dt.Rows[k][5].ToString(),
                                        dt.Rows[k][6].ToString(), dt.Rows[k][7].ToString(), dt.Rows[k][8].ToString(),
                                        dt.Rows[k][9].ToString(), dt.Rows[k][10].ToString(), dt.Rows[k][11].ToString(),
                                        dt.Rows[k][12].ToString(), dt.Rows[k][13].ToString(), dt.Rows[k][14].ToString(),
                                        dt.Rows[k][15].ToString(), dt.Rows[k][16].ToString(), dt.Rows[k][17].ToString(),
                                        dt.Rows[k][18].ToString(), dt.Rows[k][19].ToString(), dt.Rows[k][20].ToString());
                    DB2Helper.Instence.SetDS(sql);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        #endregion