Uploading an Excel File to MS ACCESS Table using FileUpload

Hi all,

I think I am very close to suceeding but I am getting an error message.

The Scenario is I am using the FileUpload tool, Grabbing the Excel File and hitting an upload button.

Here is the code...

ASP

"FileUpload1" runat="server" />
"Button1" runat="server" Text="Upload Spreadsheet" OnClick="Upload"/>
"lblMessage" runat="server" Text="Label">

Code Behind

protected void Upload(object sender, EventArgs e)
{
string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
string contentType = FileUpload1.PostedFile.ContentType;
using (Stream fs = FileUpload1.PostedFile.InputStream)
{
using (BinaryReader br = new BinaryReader(fs))
{
byte[] bytes = br.ReadBytes((Int32)fs.Length);
string constr = ConfigurationManager.ConnectionStrings["SalesConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
con.Open();
string query = "INSERT INTO Upload VALUES (@Name, @ContentType)";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@Name", filename);
cmd.Parameters.AddWithValue("@ContentType", contentType);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
}
}

However I am getting the Error

Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Is it because I am pointing at my C: Drive rather than a Network?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
There is something wrong in your connectionstring
in visual studio open server tab and add new connection then right click on the datatabe and go to properties and copy the connectionstring and then paste it in your configuration file.
Kiran Mohanty5y ago
Hi,
Do you have a valid connection string ?