how to upload an excel in c# ASP.Net?

Answer Posted / kris

protected void btnUpload_Click(object sender, EventArgs e)
{
if (fuUpload.HasFile)
{
string filename = fuUpload.PostedFile.FileName;

string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
+"Data Source="+ filename +";" +"Extended Properties=Excel
8.0;";
OleDbConnection con = new OleDbConnection(strConn);
con.Open();
OleDbCommand cmd = new OleDbCommand("select *
from [Sheet1$]",con);
OleDbDataAdapter dad = new OleDbDataAdapter();
dad.SelectCommand = cmd;
DataSet ds= new DataSet();
dad.Fill(ds);
DataGrid1.DataSource = ds.Tables[0].DefaultView;
DataGrid1.DataBind();
con.Close();
}

}

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we use ajax in asp.net through javaScript. Please givee me an example.

2508


how to track links visited in google using iframes

2287


How to get Dynamically Linked Comboboxes Set?

2032


Coding for .NET Delegates?

2102


How to Bind Nested XML to a Repeater Control with Container.DataItem?

3223






Code for Document Validation in XML.NET?

1989


Code for Communicating over Sockets?

1952


Coding for Synchronizing Cache Access in ASP.NET?

3126


ArrayList declaration in .net

2753


Code for Presenting Parent/Child Data in a Data Grid Row?

2114


Common UI for Multiple web applications. Suppose there are 35 websites using same third party controls.These 3rd party controls are made together that all 35 websites can use these controls.If we put all 3rd party controls and use its dll in 35 websites,only class files will be accessable. But I want to use CSS,images also in all 35 websites. how I can design the N-tier solution for this project.

2252


how to create a search bar which access data from various websites and retrieves the data

2556


Code for Creating a Form Using PlaceHolder Controls?

2355


What is the code of Password Recovery or Forget your password? Plz tell in c # language.

3575


How to use Client-side Script to Focus Controls in ASP.NET?

2366