Archive for February 2009


Asp.Net Session ve Handler

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

Insert DataTable to Excel Sheet

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#

Page 2 of 212

Back to top