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>

Is redux flux?

943

---

What are the various ways to send content from one page to another?

905

---

Is asp.net and .net are same or different?

974

---

What do you mean by role-based security?

975

---

What are the two properties that are common on every validation control?

1019

---

What is difference Between Authentication and authorization?

1122

---

What is the use of global.asax file?

1041

---

List the types of authentication supported by asp.net?

930

---

Where is the view state data stored in asp net?

1007

---

What is variable and constant in .net programming language?

799

---

Explain server side state management system.

948

---

What are the main differences between asp and asp.net?

1021

---

What is paging in context of Memory?

1095

---

Why we use content place holder in asp.net?

1023

---

What is the web.config file in asp?

1146

---