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>

How would you enable impersonation in the web.config file?

949

---

Explain how is a property designated as read-only?

963

---

What are the disadvantages of view state?

1049

---

What are the security types in asp.net?

1003

---

What are the differences between code behind and code inline?

1013

---

Describe a Windows Service and its lifecycle ?

1082

---

Explain how asp.net page works?

976

---

Write a code for sending an email from asp.net application.

985

---

Describe the difference between inline and code behind - which is best in a?

1086

---

Can you explain one critical mapping? Performance issue which one is better?

848

---

Are there any resources for drop-in replacements for the default css that comes with the ASP.NET Website template?

953

---

Does web services support data reader like pom project?

876

---

What kind of data can be stored in viewstate?

941

---

What are the events in a page life cycle?

902

---

What is the difference between c# and .net?

1002

---