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

}

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

2508

---

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

2116

---

Code for Creating a Form Using PlaceHolder Controls?

2356

---

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

2148

---

how to track links visited in google using iframes

2287

---

---

Code for Communicating over Sockets?

1954

---

Coding for .NET Delegates?

2102

---

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

3575

---

Code for Document Validation in XML.NET?

1990

---

Code for Using Keyboard Events?

2137

---

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

2367

---

How to get Dynamically Linked Comboboxes Set?

2032

---

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

3224

---

ArrayList declaration in .net

2754

---

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

2558

---