Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Reply
how to import data from excel to grid
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
anjumathi kumar
13y
1.8k
1
Reply
Hi
How to import data from Microsoft Excel 2010 to Gridview
am using web application.(visual studio 2010)
String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=D:\\Book1.xls;" + "Extended Properties=Excel 8.0;HDR=NO;";
DataTable ds = new DataTable();
string strSQL = "SELECT * FROM [Sheet1$]";
OleDbDataAdapter da = new OleDbDataAdapter(strSQL, strConn);
da.Fill(ds);
grvPatient.DataSource = ds;
grvPatient.DataBind();
m trying like this it provide error
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Error 542 The type 'ASP.H' exists in both 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\temporary asp.net files\efresh\d6a5ada8\84dac83f\App_Web_he4cqxdw.dll'
Html rendering in PDF... with asp.net, sql server 2005..