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>

Where the cookie value is stored?

942

---

When maintaining session through sql server, what is the impact of read and write operation on session objects?

988

---

Is post back property in asp net?

1029

---

How can you display all validation messages in one control?

992

---

Is viewstate enabled by default?

976

---

Why the javascript validation not run on the asp.net button but run successfully on the html button?

962

---

Is asp.net and .net same?

973

---

Why asp.net is better than php?

980

---

To bind columns manually which tags do you need to add within the asp:datagrid ?

967

---

What setting must be added in the configuration file to deny a particular user from accessing the secured resources?

1042

---

What is the used of "ispostback" property?

1123

---

What is the difference between user control an custom control?

1117

---

What is the difference between ASP.NET Webforms and ASP.NET MVC?

1159

---

How to sign out from forms authentication?

1068

---

What is form method?

930

---