/// <summary> ///Get Excel file/// </summary> /// <param name= "Sender" ></param> /// <param name= "E" ></param> Private voidButton1_Click (Objectsender, EventArgs e) {OpenFileDialog Dlg=NewOpenFileDialog (); Dlg. Filter="Excel File (*.xls) |*.xls"; if(DLG. ShowDialog () = =DialogResult.OK) {stringFilePath =dlg. FileName; This. TextBox1.Text =FilePath; } } /// <summary> ///Import an Excel file/// </summary> /// <param name= "Sender" ></param> /// <param name= "E" ></param> Private voidButton2_Click (Objectsender, EventArgs e) { if(TextBox1.Text.Length = =0) {MessageBox.Show ("Please select the execl file for importing data"); } Else { Try{oledbconnectionstringbuilder Connectstringbuilder=NewOledbconnectionstringbuilder (); Connectstringbuilder.datasource= This. TextBox1.Text.Trim (); Connectstringbuilder.provider="microsoft.jet.oledb.4.0"; Connectstringbuilder.add ("Extended Properties","Excel 8.0"); using(OleDbConnection cn =NewOleDbConnection (connectstringbuilder.connectionstring)) {DataSet DS=NewDataSet (); stringsql ="Select * FROM [sheet1$]"; OleDbCommand cmdliming=NewOleDbCommand (SQL, CN); cn. Open (); using(OleDbDataReader drliming =Cmdliming.executereader ()) {ds. Load (drliming, Loadoption.overwritechanges,New string[] {"Sheet1" }); DataTable DT= ds. tables["Sheet1"]; if(dt. Rows.Count >0) { for(inti =0; i < dt. Rows.Count; i++) { //Write database Data stringMYSQL ="INSERT into clientinfo values ('"+dt. rows[i]["name"]. ToString () +"', '"+dt. rows[i]["name"]. ToString ()+"' , ' 0 ', '"+dt. rows[i]["Notes"]. ToString () +"' , ' 0 ', '"+i.tostring () +"')"; Newdataaccess (). SQLExecute (MYSQL); } MessageBox.Show ("Data Import Successful! "); } Else{MessageBox.Show ("Check to see if there is data in your Excel"); } } } } Catch(Exception ex) {MessageBox.Show (ex). ToString ()); } } } /// <summary> ///data manipulation General class/// </summary> /// <param name= "SQL" ></param> /// <returns></returns> Public BOOLSQLExecute (stringSQL) { Try{OleDbConnection conn=NewOleDbConnection (connect_string); Conn. Open (); OleDbCommand Comm=NewOleDbCommand (); Comm. Connection=Conn; Comm.commandtext=SQL; Comm. ExecuteNonQuery (); Comm. Connection.close (); Conn. Close (); return true; } Catch { return false; } }