Answer Posted / a

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Runtime.InteropServices.ComTypes;
using System.Data.OleDb;
using System.IO;

public partial class ReadExcel : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
string strFilePath = @"D:\Development\Test.xlsx";
string strBatchPath = @"D:\Development\test.txt";
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;

StreamWriter sr = File.AppendText(strBatchPath);
string cmd = string.Empty;
for (int i = 0; i < dtCSV.Rows.Count; i++) {
cmd = "xcopy /Y \"" + dtCSV.Rows[i][0]
+ "\" " + "\"D:/\"";
WriteText(cmd, sr);
}
sr.Close();
} catch (Exception ex) {
} finally {
}
}

public void WriteText(string message, TextWriter tr) {
tr.WriteLine(message);
tr.Flush();
}
}

Name the two properties are on every validation control?

1037

---

Can you explain composite pattern?

1092

---

In Data grid the question is below quantity price total these are 3 fields available in data grid if you enter quantity the total has to update automatically.Price field is already filled completely

2064

---

What are custom user controls in asp.net?

1055

---

Why is global asax is used?

1069

---

What happens if an ASP.NET server control with event-handling routines is missing from its definition?

1157

---

Explain asp.net web forms.

1139

---

Which dll handles the request of .aspx page?

1006

---

Explain diff. Betn dataset and recordset?

1058

---

What is asp.net response object?

1100

---

What is a postback in asp net?

1145

---

Can I read the hard disk serial # of the client computer using asp.net?

1164

---

Define page fragment caching?

971

---

Is it possible to develop a single web application using ASP.NET webforms and ASP.MVC?

1111

---

What are the different types of sessions in asp.net?

1001

---