Answer Posted / d

using System.Data.OleDb;

string strFilePath = @"D:\Development\Test.xlsx";
try {
string strConnectionString = string.Empty;
//strConnectionString =
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
strFilePath + @";Extended Properties=""Excel
8.0;HDR=YES;IMEX=1""";
strConnectionString =
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
strFilePath + @";Extended Properties=""Excel 12.0
Xml;HDR=YES;IMEX=1""";
OleDbConnection cnCSV = new OleDbConnection
(strConnectionString);
cnCSV.Open();
OleDbCommand cmdSelect = new OleDbCommand
(@"SELECT * FROM [Sheet1$]", cnCSV);
OleDbDataAdapter daCSV = new OleDbDataAdapter();
daCSV.SelectCommand = cmdSelect;
DataTable dtCSV = new DataTable();
daCSV.Fill(dtCSV);
cnCSV.Close();
daCSV = null;

Response.Write(dtCSV.Rows.Count);
gvTest.DataSource = dtCSV;
gvTest.DataBind();


} catch (Exception ex) {
} finally {
}


<asp:GridView ID="gvTest" runat="server"
AutoGenerateColumns="false">
<Columns>
<asp:BoundField HeaderText="GDCID" DataField="GDCID" />
<asp:BoundField HeaderText="EmpID" DataField="EmpID" />
</Columns>
</asp:GridView>

What is the difference between mechine.config and web.config?

1269

---

Does google crawl redirects?

1012

---

What is asp.net mvc5? : Asp.Net MVC

1077

---

Is viewstate secure?

1002

---

what is the difference between response.write() and response.output.write()?

1215

---

What is content place holder?

1026

---

Explain what the contents of cookie?

1101

---

What is the default Orientation property in a Menu control?

1082

---

How to implement globalization and localization in the use interface in .net.

1062

---

What is Dynamic Web and discuss its usage with the help of real life examples?

1092

---

Can we set master page as a start page?

1078

---

What are strong names?

1086

---

How to reduce the width of textbox in editcommandcolumn of datagrid?

1060

---

What is asp net objects?

1122

---

How can we use Web API with ASP.NET Web Form?

1154

---