Monday, July 13, 2009

Access Session variables inside an asp.net handler

http://www.codedigest.com/CodeDigest/23-Accessing-Session-Variable-in-HttpHandler-in-ASP-Net.aspx

Failed to access IIS metabase

http://geekswithblogs.net/narent/archive/2007/03/23/109573.aspx

Create a web application using SharePoint Designer

http://blogs.technet.com/brenclarke/archive/2009/04/14/creating-a-quiz-web-application-using-sharepoint-designer.aspx

Read XLS and XLSX files using .net

string filenames = path.Substring(path.LastIndexOf("\\") + 1);
string ext = filenames.Substring(filenames.LastIndexOf(".") + 1);
if (ext == "xls" || ext == "xlsx")
{

String strExcelConn = "Provider=Microsoft.ACE.OLEDB.12.0;"
+ "Data Source=" + path
+ ";Extended Properties='Excel 8.0;HDR=Yes'";
OleDbConnection connExcel = new OleDbConnection(strExcelConn);
OleDbCommand cmdExcel = new OleDbCommand();
cmdExcel.Connection = connExcel;
connExcel.Open();
System.Data.DataTable dtExcelSchema;
dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

System.Data.DataSet ds = new System.Data.DataSet();
string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
cmdExcel.CommandText = "SELECT Top 10 * From [" + SheetName + "]";
System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter(cmdExcel);
System.Data.OleDb.OleDbDataReader dr = cmdExcel.ExecuteReader();
}

Saturday, July 11, 2009

An ASP.NET setting has been detected that does not apply in the Integrated managed pipeline mode

http://blog.benhall.me.uk/2008/05/aspnet-setting-has-been-detected-that.html

Add a managed handler

http://technet.microsoft.com/en-us/library/cc753249(WS.10).aspx

Create & Deploy ASP.NET Handler

http://support.microsoft.com/kb/308001