oledbdatareaderclass

http://authors.aspalliance.com/aspxtreme/sys/Data/oledb/oledbdatareaderclass.aspx

vbcr in c#

System.Environment.NewLine

Single Quotes

HttpUtility.HtmlEncode(mystring.Replace("'", "")

Data Binder Prefix

<%# "prefix " + Eval("random") %>

How To: Reading and Writing Text Files

Writing to a Text File

Listing 1: Writing Text Data to a File: TextFileWriter.cs


using System;
using System.IO;

namespace csharp_station.howto
{
class TextFileWriter
{
static void Main(string[] args)
{
// create a writer and open the file
TextWriter tw = new StreamWriter("date.txt");

// write a line of text to the file
tw.WriteLine(DateTime.Now);

// close the stream
tw.Close();
}
}
}


Reading From a Text File

Listing 2 shows how to read from a text file:

Listing 2: Reading Text Data from a File: TextFileReader.cs


using System;
using System.IO;

namespace csharp_station.howto
{
class TextFileReader
{
static void Main(string[] args)
{
// create reader & open file
Textreader tr = new StreamReader("date.txt");

// read a line of text
Console.WriteLine(tr.ReadLine());

// close the stream
tr.Close();
}
}
}


URL Rewriting in >NET

<urlMappings configSource="Mapping.xml" />
Mapping.xml
<?xml version="1.0" encoding="utf-8" ?>
<urlMappings>
<add url="~/Page1.aspx" mappedUrl="~/Default.aspx?ID=1" />
<add url="~/Page2.aspx" mappedUrl="~/Default.aspx?ID=2" />
</urlMappings>

SET NOCOUNT ON

SET IDENTITY_INSERT [dbo].[tblEcommunicationsEmailTemplates] ON
GO


PRINT 'Inserting values into [tblEcommunicationsEmailTemplates]'
INSERT INTO (ID) VALUES(2)

PRINT 'Done'

SET IDENTITY_INSERT [dbo].[tblEcommunicationsEmailTemplates] OFF
GO
SET NOCOUNT OFF

Force IE8 into compatibility mode

<meta equiv="X-UA-Compatible" content="IE=EmulateIE7">

More...
http://blogs.msdn.com/ie/archive/2008/06/10/introducing-ie-emulateie7.aspx

SQL - Useful Functions

Get Employees first name:

SELECT SUBSTRING(Name, 1, CHARINDEX(' ', Name)) AS FirstName

System.Web.HttpContext

System.Web.HttpContext.CurrentContext.Response.Write("");

System.Web.HttpContext.Current.User.Identity.IsAuthenticated