Error::
Fatal error encountered during command execution.
Con.Open();
string path = fileuploadExcel.PostedFile.FileName;
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("orders.xlsx") + ";Extended Properties=Excel 12.0;Persist Security Info=False";
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
DataTable dt = new DataTable();
excelConnection.Open();
try
{
dt.Columns.AddRange(new DataColumn[11] { new DataColumn("Date", typeof(DateTime)),
new DataColumn("Ref_No", typeof(string)),
new DataColumn("Partys_Name",typeof(string)),
new DataColumn("Pending", typeof(float)),
new DataColumn("<30 days ", typeof(float)),
new DataColumn("30to60days", typeof(float)),
new DataColumn("60 to 90 days", typeof(float)),
new DataColumn("90 to 120 days", typeof(float)),
new DataColumn("(> 120 days )", typeof(float)),
new DataColumn("Post-Dated", typeof(string)),
new DataColumn("Final", typeof(float))});
OleDbCommand cmd = new OleDbCommand("Select * from [Sheet1$]", excelConnection);
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
MySqlCommand cm = new MySqlCommand("insert into tbl_upload values(@Date,@Ref_No,@Partys_Name,@Pending,@<30 days,@30to60days,@60 to 90 days,@90 to 120 days,@(> 120 days ),@Post-Dated,@Final)", Con);
cm.Parameters.AddWithValue("Date", "Date");
cm.Parameters.AddWithValue("Ref_No", "Ref_No");
cmd.Parameters.AddWithValue("Partys_Name", "Partys_Name");
cm.Parameters.AddWithValue("<30 days ", "less30days");
cm.Parameters.AddWithValue("30to60days", "bet30to60days");
cm.Parameters.AddWithValue("60 to 90 days", "bet60to90days");
cm.Parameters.AddWithValue("90 to 120 days", "bet90to120days");
cm.Parameters.AddWithValue("(> 120 days )", "greater120days");
cm.Parameters.AddWithValue("Post-Dated", "Posted_Dated");
cm.Parameters.AddWithValue("Final", "Final");
int i = cm.ExecuteNonQuery();
if (i > 0)
{
Label2.Text = "Data inserted successfully";
}
}
catch (Exception ex)
{
Label2.Text =ex.Message;
}
excelConnection.Close();
Con.Close();
}