import contacts from Excel to DataGrid?

Question

0.00/5 (No votes)

See more:

Hi sir,

A File upload area where the person can select an excel file to upload, a button to upload and then a datagrid which will display the uploaded data.

how to do this sir?

The details in this gridview are then saved to a database but before that they can be edited and some rows removed if necessary

i tried to display Excel to Datagrid but Error is occured when i Fill the data into dataset that Error message is Cannot update. Database or object is read-only. my code is:

Dim savePath As String = "~/ExcelFiles/"
Dim fileName As String = Server.HtmlEncode(fuImportContacts.FileName)
savePath = savePath & fileName

Dim strCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=Server.MapPath(savePath);" & "Extended Properties=Excel 8.0;"

Dim ds As DataSet = New DataSet()
Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM [SHEET1$]", strCon)

da.TableMappings.Add("Table", "ExcelTest")
da.Fill(ds)
DataGrid1.DataSource = ds.Tables(0)
DataGrid1.DataBind()

please give a solution

Posted 26-Aug-10 19:03pm

ajay.raju531

Updated 26-Aug-10 19:44pm

v3

Add a Solution

Comments

Christian Graus 27-Aug-10 1:47am

How bizarre, you keep editing your post, but I can't see any difference in what you posted, and it doesn't change that my answer is almost certainly correct. Do you understand what I said ? Oh, you posted the code that proves my answer is correct. I see it now.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2010-08-26T19:19:00

Solution 1

This code does not try to update or change your file, so I don't understand your error message. However, I do notice that your data source contains the literal 'savePath', where I suspect that's a variable name that you meant to concatenate, as in (" & Server.MapPath(savePath) & ");"

Posted 26-Aug-10 19:19pm

Christian Graus

Updated 26-Aug-10 19:48pm

v2