01.FileInfo excel = new FileInfo(Server.MapPath(@"Xls/myData.xlsx"));
02.using (var package = new ExcelPackage(excel))
03.{
04. var workbook = package.Workbook;
05.
06.
07. var worksheet = workbook.Worksheets.First();
08.
09. string strConnString = @"Server=localhost;UID=sa;PASSWORD=;database=mydatabase";
10. var objConn = new SqlConnection(strConnString);
11. objConn.Open();
12.
13.
14. int totalRows = worksheet.Dimension.End.Row;
15. for (int i = 2; i <= totalRows; i++)
16. {
17. string strSQL = "INSERT INTO myTable (Column1,Column2,Column3,Column4,Column5) "
18. + " VALUES ("
19. + " '" + worksheet.Cells[i, 1].Text.ToString() + "', "
20. + " '" + worksheet.Cells[i, 2].Text.ToString() + "', "
21. + " '" + worksheet.Cells[i, 3].Text.ToString() + "', "
22. + " '" + worksheet.Cells[i, 4].Text.ToString() + "', "
23. + " '" + worksheet.Cells[i, 5].Text.ToString() + "' "
24. + ")";
25. var objCmd = new SqlCommand(strSQL, objConn);
26. objCmd.ExecuteNonQuery();
27. }
28.
29. objConn.Close();
30.}
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
