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();
}
}

What is Difference between Production Serves and Development Servers? And Suppose, m adding/deleting C# file in a project based on the Specific Requirement. These Files are Automatically updated in Production Servers? So Which tool is needed to do This One?

2034

---

Explain how cookies work. Give an example of cookie abuse.

1096

---

How many types of session state management options available in asp.net?

1030

---

What are the differences between clr & cts?

1052

---

Will the asp.net validators run in server side or client side?

1120

---

witch is the best insistute in sharpoint course.what abt future of share point course.

3422

---

What is cached data phone?

1019

---

If I am developing an application that must accomodate multiple security levels though secure login and my asp.net web application is spanned across three web-servers (using round-robin load balancing). What would be the best approach to maintain login-in state for the users?

1066

---

What are html helpers in asp.net?

1067

---

What is ispostback method in asp.net? Why do we use that?

1193

---

What does session_start () do?

1070

---

Explain Areas in MVC?

1075

---

What are assemblies and namespaces and explain the difference between them ?

1069

---

I have an excel file with data, i am importing this excel file data into Sqlserver 2005 database. while importing i am getting wrong data(ie, special characters) in one column(description column), upto some limit the data in that column is coming fine,after that data is coming like below. The "Walter" leather storage bench is one of our most popular styles. The top with the tufting and double stitching finish a very impressive piece. The size is perfect in front of beds and the storage adds another functional bonus. Open it up and sneak al���Ƴ�Â��ƴ�Ã��ƶ�Å�� al���Ƴ�Â��ƴ�Ã��ƶ�Å�� Is there anywhy to resolve this? (I am using recordset in coding for developing import process.) please help me soon.

1897

---

Where sessions are stored in asp.net?

986

---