C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Abhi (58)
Appukuttan (40)
divya (36)

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Excel Fileupload control

Posted Date: 03 Jun 2008	Resource Type: Code Snippets	Category: ASP.NET WebForms
Author: Kumar Velu	Member Level: Diamond
Rating:	Points: 2

following code upload the excel file and display that one in gridview

protected void btnok_Click(object sender, EventArgs e)
{
if (fileupload1.HasFile)
{
if (fileupload1.FileName.ToUpper().EndsWith("XLS"))
{
Session["current"] = 1;
lbltext.Visible = true;
string path = fileupload1.PostedFile.FileName;// return full url
ViewState["path"] = path;
string filename = fileupload1.FileName;
ListOfSentence = GetSheetsNames(path);
string s = ListOfSentence[0].ToString();
Session["Noofsheet"] = s.Length;
string query = "select * from [" + s + "$]";
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0;";
OleDbDataAdapter adap = new OleDbDataAdapter(query, strConn);
DataSet ds = new DataSet();
adap.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
btnnext.Visible = true;
btnsheet.Visible = true;
}
else
{
lbltext.Visible = true;
lbltext.Text = "please select excel file";

}

}
else
{
lbltext.Visible = true;
lbltext.Text = "please select file";
}
}

Responses

Author: Kapil Dhawan 17 Jun 2008

Member Level: Gold Points : 2

Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code is going to help lots of guys.
Ton Thanks to you
Regards,
Kapil

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Concept of multivalue cookies
	Previous Resource: get a system address
	Return to Discussion Resource Index
	Post New Resource
	Category: ASP.NET WebForms

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design