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 to create a search bar which access data from various websites and retrieves the data

2942

---

How to get Dynamically Linked Comboboxes Set?

2405

---

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

2509

---

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

2530

---

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

2944

---

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

2916

---

Coding for .NET Delegates?

2499

---

Code for Communicating over Sockets?

2308

---

Code for Document Validation in XML.NET?

2334

---

ArrayList declaration in .net

3184

---

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.

2660

---

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

3598

---

Code for Using Keyboard Events?

2545

---

how to track links visited in google using iframes

2692

---

Code for Creating a Form Using PlaceHolder Controls?

2781

---