actually keep this piece of code in a class called util. so I'm just going to paste the function and also the setting in the config file.
Setting in Config File
<add key="FilePath" value="D:\logFile.txt"/>
public static void function in util.cs
public static void writeToLogFile(string logMessage)
{
string strLogMessage = string.Empty;
string strLogFile = System.Configuration.ConfigurationManager.AppSettings["logFilePath"].ToString();
StreamWriter swLog;
strLogMessage = string.Format("{0}: {1}", DateTime.Now, logMessage);
if (!File.Exists(strLogFile))
{
swLog = new StreamWriter(strLogFile);
}
else
{
swLog = File.AppendText(strLogFile);
}
swLog.WriteLine(strLogMessage);
swLog.WriteLine();
swLog.Close();
}
Showing posts with label File. Show all posts
Showing posts with label File. Show all posts
Tuesday, March 2, 2010
Wednesday, September 23, 2009
Create Excel File
public static bool CreateExcelFile(DataTable dataTable, string fileName)
{
try
{
string str = "";
";
string str3 = "";
string str4 = string.Empty;
StringBuilder builder = new StringBuilder();
foreach (DataColumn column in dataTable.Columns)
{
str3 = str3 + "" + column.ColumnName + " ";
}
str3 = str3 + " ";
foreach (DataRow row in dataTable.Rows)
{
builder.Append("");
for (int i = 0; i < dataTable.Columns.Count; i++)
{
str4 = " ";
if (!string.IsNullOrEmpty(row[i].ToString()))
{
str4 = row[i].ToString();
}
builder.Append("" + str4 + " ");
}
builder.Append(" ");
}
string s = str + str3 + builder.ToString() + str2;
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/vnd.xls";
HttpContext.Current.Response.Write(s);
HttpContext.Current.Response.Flush();
return true;
}
catch
{
return false;
}
}
{
try
{
string str = "
string str3 = "
string str4 = string.Empty;
StringBuilder builder = new StringBuilder();
foreach (DataColumn column in dataTable.Columns)
{
str3 = str3 + "
}
str3 = str3 + "
foreach (DataRow row in dataTable.Rows)
{
builder.Append("
for (int i = 0; i < dataTable.Columns.Count; i++)
{
str4 = " ";
if (!string.IsNullOrEmpty(row[i].ToString()))
{
str4 = row[i].ToString();
}
builder.Append("
}
builder.Append("
}
string s = str + str3 + builder.ToString() + str2;
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/vnd.xls";
HttpContext.Current.Response.Write(s);
HttpContext.Current.Response.Flush();
return true;
}
catch
{
return false;
}
}
Subscribe to:
Posts (Atom)