Monthly Archives: October 2008

A asp.net ajax login template

Posted on October 22, 2008 by aspgen

This is a generic login page with asp.net ajax: Note: Sys.Debug.trace("pageLoading") only works with a <textarea id="TraceConsole" rows="100" cols="50"></textarea> somewhere on the form. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login1.aspx.cs" Inherits="Login1"    Theme="default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;<html xmlns="http://www.w3.org/1999/xhtml"&gt;<head … Continue reading →

Posted in Computers and Internet | Leave a comment

BLL template

Posted on October 21, 2008 by aspgen

Refer to http://www.asp.net/learn/data-access/?lang=cs for a good tutorial on using tableadapter which is used extensively in my data centric projects.  I have yet to find anything better and easier and more efficient than tableadapter.  <%@ CodeTemplate Src="TemplateCode.cs" Inherits="MyCodeTemplate.MyTemplateCode" Language="C#" TargetLanguage="C#"     … Continue reading →

Posted in Computers and Internet | Leave a comment

Use SchemaExplorer.CommandSchema for stored procedure oriented development

Posted on October 21, 2008 by aspgen

In many companies, using stored procedures to access data is a mandate.  DBAs don’t want to give users free access to their underlying tables.  It’s just too risky. Imagine a seemingly innocuous update command without "where" clause!  But the trend … Continue reading →

Posted in Computers and Internet | Leave a comment

codesmith t-sql search template

Posted on October 21, 2008 by aspgen

Be careful with data type char(n) or nchar(n), change them to varchar(n) or nvarchar(n), otherwise it won’t work <%——————————————————————————————* Author: Eric J. Smith * Description: This template will generate standard CRUD stored procedures for a given *   database table.——————————————————————————————%><%@ CodeTemplate … Continue reading →

Posted in Uncategorized | 6 Comments