protected void btnSave_Click(object sender, EventArgs e) { string FileName = lblFileName.Text; string Extension = Path.GetExtension(FileName); string FolderPath = Server.MapPath(ConfigurationManager.AppSettings["FolderPath"]); string CommandText = ""; switch (Extension) { case ".xls": //Excel 97-03 CommandText = "spx_ImportFromExcel03"; break; case ".xlsx": //Excel 07 CommandText = "spx_ImportFromExcel07"; break; } //Read Excel Sheet using Stored Procedure //And import the data into Database Table String strConnString = ConfigurationManager.ConnectionStrings["CARGONETConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(strConnString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = CommandText; cmd.Parameters.Add("@SheetName", SqlDbType.VarChar).Value = ddlSheets.SelectedItem.Text; cmd.Parameters.Add("@FilePath", SqlDbType.VarChar).Value =FolderPath + FileName; cmd.Parameters.Add("@HDR", SqlDbType.VarChar).Value =rbHDR.SelectedItem.Text; cmd.Parameters.Add("@TableName", SqlDbType.VarChar).Value = "TB_TransAgentSeaFreightRate"; cmd.Connection = con; try { con.Open(); object count = cmd.ExecuteNonQuery(); lblMessage.ForeColor = System.Drawing.Color.Green; lblMessage.Text = count.ToString() + " records inserted."; } catch (Exception ex) { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = ex.Message; } finally { con.Close(); con.Dispose(); Panel1.Visible = true; //Panel2.Visible = false; dg_AgentSFR.Visible = true; } }
My error was gone I run the below code: USE [master] GO EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1 GO EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1 GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)