XLS file Import Database

Protectedvoid Btn_ok_click (Object sender,EventArgs e) {int num = 0;try {string x = Txtpath. Text;DirectoryInfo Thefolder = new DirectoryInfo (x);fileinfo[] FileInfo = Thefolder.getfiles ();foreach (FileInfo nextfile in FileInfo)//Traverse file//{b++;DataSet ds = GetConnect (x+nextfile.name);DataSet ds = GetConnect (x);DataTable xdatatable = ds. Tables[0];for (int i = 0; i < XDataTable.Rows.Count; i++) {num = i;var ISBN = Webutil.replacechar ((xdatatable.rows[i][0] + ""). Substring (1). Trim ());var ISBN = (xdatatable.rows[i][0] +""). Trim ();var bookname = xdatatable.rows[i][1] +"";var bookname = xdatatable.rows[i][1] + "";var cover =xdatatable.rows[i][2];var cover = xdatatable.rows[i][2] +"";var author = xdatatable.rows[i][3] +"";var bottle = Xdatatable.rows[i][4] +"";var Pricie = xdatatable.rows[i][5] +"";var publicationdate = xdatatable.rows[i][6] +"";var contentintroduced = xdatatable.rows[i][7] +"";var authorintroduced = xdatatable.rows[i][8] +"";var area = Xdatatable.rows[i][9] +"";Sqlitehelper.executenonquery (Insert into [Books] (isbn,bookname,cover,author,bottle,pricie,publicationdate,contentintroduced,authorintroduced , area,iscommend,isconver) VALUES (' "+ ISBN +"', '" + BookName +"', '" + cover +"', '" + author +"', '" + Bottle +"', '" + Pricie +"', '" + Publicationdate +"', '" + authorintroduced +"', '" + contentintroduced +"', '" + area +"', 0,0)"); }} lblshow. InnerText ="Import succeeded!"        "; }catch (Exception ex) {lblshow. InnerText ="Import failed!"        "+ num; }    }/// <summary>///Export data from an Excel table to myDataSet///</summary>PublicStaticDataSet GetConnect (String FilePath) {DataSet myDataSet =NewDataSet ();String Strcon ="Provider=Microsoft.Jet.OLEDB.4.0; Data source= "+ FilePath +"; Extended properties=\ "Excel 8.0; Hdr=yes; Imex=1;\ "";if (Path.getextension (FilePath). ToLower () = =". xlsx") Strcon ="Provider=microsoft.ace.oledb.12.0;data source=" + FilePath +"; Extended properties= ' Excel 12.0; Hdr=yes;imex=1 ' ";OleDbConnection myconn =NewOleDbConnection (Strcon);Conditional Query Excel tableString strcom ="SELECT * FROM [sheet1$]"; MyConn.Open ();//Open Data link to get a data set OleDbDataAdapter mycommand = new OleDbDataAdapter (strcom, myconn);        //Create a DataSet object //Get your own DataSet object Mycommand.fill (myDataSet, "[sheet1$]");        //Close this data link myconn.close ();    return mydataset; }

XLS file Import Database