February 10th, 2009 — 5:33am
Handlerlar default olarak session değerlerini getirmiyorlar.
Erişmek istediğinizde null oluyor. Eğer null olmasın istiyorsanız IRequiresSessionState veya IReadOnlySessionState interfacelerini implemente etmeniz gerekiyor.
using System.Web;
using System.Web.SessionState;
public class MyHandler : IHttpHandler, IRequiresSessionState
{
public MyHandler()
{
}
#region IHttpHandler Members
public bool IsReusable
{
get { return true; }
}
public void ProcessRequest(HttpContext context)
{
//do work
context.Session["MyValue"] = "New Value";
}
#endregion
}
Comment » | Asp.Net
February 10th, 2009 — 2:23am
Your datatable must have captions for better view.
Excel.Application xlApp = new Excel.Application();
xlApp.Visible = false;
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
Excel.Workbook wb = xlApp.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
Excel.Worksheet ws = (Excel.Worksheet)wb.Sheets[1];
//capion work you can delete it if you want
for (int r = 0; r < dtExcel.Columns.Count; r++)
{
Excel.Range field = (Excel.Range)ws.Cells[1, r + 1];
field.Formula = dtExcel.Columns[r].Caption;
}
for (int i = 0; i < dtExcel.Rows.Count; i++)
{
for (int j = 0; j < dtExcel.Columns.Count; j++)
{
Excel.Range field = (Excel.Range)ws.Cells[i + 2, j + 1];
field.Formula = dtExcel.Rows[i][j].ToString();
}
}
ws.Cells.EntireColumn.AutoFit();
wb.SaveAs(fileName, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value);
wb.Close(true, Missing.Value, Missing.Value);
xlApp.Quit();
Comment » | Csharp - C#