Forums - C# Corner

Forum guidelines
Dinesh Santhalingam

Dinesh Santhalingam

  • 1k
  • 487
  • 19.8k

how to store the data table content to sql data base

Dec 8 2016 1:52 AM
I have a excel file.I Store the data from excel to a data table .Now i want to store the data table content to sql table .how to store the data table to data base ?
 
 
 
Am storing the data table content from excel by using below procedure.
 
 
 
 
string filePath = Server.MapPath("~/Files/") + Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(filePath);
//string filePath=@"C:\Users\350154\Desktop\Sample.xlsx";
try
{
using (XLWorkbook workBook = new XLWorkbook(filePath))
{
//Read the first Sheet from Excel file.
IXLWorksheet workSheet = workBook.Worksheet(1);
//Create a new DataTable.
DataTable dt = new DataTable();
bool firstRow = true;
foreach (IXLRow row in workSheet.Rows())
{
if (firstRow)
{
foreach (IXLCell cell in row.Cells())
{
dt.Columns.Add(cell.Value.ToString());
}
firstRow = false;
}
else
{
//Add rows to DataTable.
dt.Rows.Add();
int i = 0;
foreach (IXLCell cell in row.Cells())
{
dt.Rows[dt.Rows.Count - 1][i] = cell.Value.ToString();
i++;
}
}
 

Answers (4)