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();
}

}

Code for Communicating over Sockets?

2431

---

how to track links visited in google using iframes

2773

---

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

2602

---

Code for Using Keyboard Events?

2667

---

Code for Document Validation in XML.NET?

2426

---

How to get Dynamically Linked Comboboxes Set?

2503

---

i have a gird with columns all are coming from database,this will bind in item templete in gridview as textboxex.and i have button below named Update.i want to update all the records in the grid,but if user change the value of one textbox,what is the easy way 2 do this

2621

---

ArrayList declaration in .net

3266

---

Coding for Synchronizing Cache Access in ASP.NET?

3702

---

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

3021

---

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

3040

---

Code for Creating a Form Using PlaceHolder Controls?

2895

---

Coding for .NET Delegates?

2626

---

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

4034

---

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

3681

---