| art# | CodeCategory | Title |
| 1 | NotSet |
C#
URL Request.QueryString
|
| 2 | NotSet |
SEC
FormsIdentity
|
| 3 | NotSet |
MAIL
MailMessage 1.1 and 2.0
|
| 4 | NotSet |
ERR
ex block example
|
| 5 | NotSet |
dGrd
set cell to a url example
|
| 6 | NotSet |
MAIL
Send a mail message different method
|
| 7 | NotSet |
URL
URLENCODE
|
| 8 | NotSet |
DATE
Date add with Ctype
|
| 9 | NotSet |
SQL
NOCOUNT
|
| 10 | NotSet |
SQL
Conditional Where with CASE
|
| 11 | NotSet |
dLst
Databinder example
|
| 12 | NotSet |
VS
Add reference
|
| 13 | NotSet |
CASE
Example of case
|
| 14 | NotSet |
ibtn
habdle dynamic link button example
|
| 15 | NotSet |
FONT
Setting font size at run time
|
| 16 | NotSet |
STR
String FORMATTING Date
|
| 17 | NotSet |
CSS
a link for css reference
|
| 18 | NotSet |
DLST
Retreave a key from view state example
|
| 19 | NotSet |
link
links examples
|
| 20 | NotSet |
function
Calling function will return type
|
| 21 | NotSet |
cnfg
Location of the machine.config file
|
| 22 | NotSet |
err
custom error machine wide
|
| 23 | NotSet |
sec
Impersonation
|
| 24 | NotSet |
cnfg
Caching
|
| 25 | NotSet |
cache
examples cacheing
|
| 26 | NotSet |
session
set session to inproc
|
| 27 | NotSet |
DDL
Load a drop down list from datareader
|
| 28 | NotSet |
SQL
join to find the date of the last unlike
|
| 29 | NotSet |
regx
expression to not allow spaces and "="
|
| 30 | NotSet |
datareader
datareade function with stored procedure
|
| 31 | NotSet |
web.config
forms authentication and excludes
|
| 32 | NotSet |
iis config
register asp.net with iis
|
| 33 | NotSet |
insert
insert with dataset and adapter
|
| 34 | NotSet |
update
update a single row with a dataset and adapter
|
| 35 | NotSet |
string
split a string into akeayvalue collection
|
| 36 | NotSet |
datatable
make datatable at run time
|
| 37 | NotSet |
string
Left Right Mid
|
| 38 | NotSet |
JavaScript
confirm box for DOT.NET
|
| 39 | NotSet |
Format
Format strings
|
| 40 | NotSet |
DataGrid
Reference OnItemCommand
|
| 41 | NotSet |
DBNull
Handling Null values
|
| 42 | NotSet |
SQL
Check for Null Value
|
| 43 | NotSet |
SQL
XTAB Example on multi level join
|
| 44 | NotSet |
SQL
CASE
|
| 45 | NotSet |
Constants
creating a property
|
| 46 | NotSet |
exception
Example of manuelly throwing an exception
|
| 47 | NotSet |
SQL
UPDATE FROM Examples
|
| 48 | NotSet |
Task Sched
examples for settingup wn schedulers tasks
|
| 49 | NotSet |
SQL
Insert From Query (idxhst from idxhstBAK)
|
| 50 | NotSet |
SQL
Update From (update join)
|
| 51 | NotSet |
SQL
big multi join query
|
| 52 | NotSet |
sql
complicated self join
|
| 53 | NotSet |
SQL
Arrays and Lists in SQL Server
|
| 54 | NotSet |
SQL
Set the current datetime to date only not min or s
|
| 55 | NotSet |
webconfig
store variable in the web config file
|
| 56 | NotSet |
SQL
convert date to integer
|
| 57 | NotSet |
SQL
COALESCE
|
| 58 | NotSet |
SQL
update from ex. Via xtab
|
| 59 | NotSet |
dotnet fn
return only digits from a string
|
| 60 | NotSet |
vCalendar
create clickable apointments
|
| 61 | NotSet |
cfforms
valitation problem (not validating)
|
| 62 | NotSet |
CFM url
looping through the url parameters
|
| 63 | NotSet |
javascript
return to previous page link
|
| 64 | NotSet |
CFM
remove chars function
|
| 65 | NotSet |
javascript
window self closer
|
| 66 | NotSet |
javascript
script form to show a close button
|
| 68 | NotSet |
js print
print button in javascript
|
| 69 | NotSet |
sql
4 level join
|
| 70 | NotSet |
regex
a regex for email
|
| 71 | NotSet |
MySQL
concatination
|
| 72 | NotSet |
javascript
Check for var defined
|
| 73 | NotSet |
SQL
complex join and union query
|
| 74 | NotSet |
SQL
simple select no match
|
| 75 | NotSet |
SQL
Date format using function
|
| 76 | NotSet |
CFM
Function to return beginning of day
|
| 77 | NotSet |
CFM
Email cleaner function injection attack
|
| 78 | NotSet |
javascript
DOM change names of form fields and…
|
| 79 | NotSet |
dotnet
get a list of installed printers
|
| 80 | NotSet |
cf JAVA
example of CF calling JAVA
|
| 81 | NotSet |
sql
identity after insert
|
| 82 | NotSet |
javascript
using "this" in function calls
|
| 84 | NotSet |
HTML
underline trick
|
| 85 | NotSet |
sql
use of CASE in a sum
|
| 86 | GeneralInfo |
ajax
for dot net name spaces
|
| 87 | NotSet |
SQL
set last day of the month
|
| 88 | NotSet |
SQL UDF
date functions
|
| 89 | NotSet |
SQL -UDF
business days function
|
| 90 | NotSet |
Javascript
date diff in days
|
| 91 | TSql |
SQL UDF
Table Function
|
| 92 | NotSet |
asp.net
custom validator
|
| 93 | NotSet |
SQL
dynamic select parameters
|
| 94 | NotSet |
CFM
call a function direct with create component
|
| 95 | NotSet |
ipscanner
angry ipscanner
|
| 96 | NotSet |
WIN FS
setup shadow copy and retreve
|
| 97 | NotSet |
DOT.NET
run a dot.net website off a CD
|
| 98 | NotSet |
CFM
Output Generator
|
| 99 | NotSet |
sql
table variable example
|
| 100 | NotSet |
HTTP
HTTP URL SERVICE: http://tinyurl.com/
|
| 101 | NotSet |
Contribute
MM FTP Checker
|
| 102 | NotSet |
sql 2k5
insert deleted into
|
| 103 | NotSet |
SQL
Running total TSQL Example
|
| 104 | NotSet |
SQL
list return functions agragate
|
| 105 | NotSet |
AJAX
cfc
|
| 106 | NotSet |
AJAX
aspx AJAX
|
| 107 | NotSet |
javascript
set value of form field
|
| 108 | NotSet |
SQL
Delete join example
|
| 109 | NotSet |
SQL
Truncate Log on check point
|
| 110 | NotSet |
SQL
use result from a sp into a temptable
|
| 111 | NotSet |
SQL
Delete duplacates form table example
|
| 112 | NotSet |
aspnet
check for null db return fields
|
| 113 | NotSet |
CFM
Time Delay
|
| 115 | NotSet |
SQL
Full Text with partial name search included
|
| 116 | NotSet |
SQL
freetexttable example
|
| 117 | NotSet |
SQL
tempdb issues
|
| 118 | NotSet |
DotNET SQL
function to return the return code from an ap
|
| 119 | NotSet |
Dot.net JS
display popup warning messages
|
| 120 | NotSet |
SQL Date
DATE Format from Integer function
|
| 121 | NotSet |
DOT.NET
Gridview Extra Header rows
|
| 122 | NotSet |
dot.net
arrays Jagged and rectangular
|
| 123 | NotSet |
DOTNETCCN
credit card stuff
|
| 124 | NotSet |
Email
dot.net formatted email with graphics
|
| 125 | NotSet |
SQL
Default params for stored proc (ex here is date)
|
| 126 | NotSet |
SQL
Get return code from SP
|
| 127 | NotSet |
SQL
Row Number example
|
| 128 | NotSet |
SQL
Replace CR FL in fields on select
|
| 129 | NotSet |
SQL
Trigger that updates another table
|
| 130 | NotSet |
javascript
check uncheck all boxes
|
| 131 | NotSet |
SQL
Example of VAR input type for condition in SP
|
| 132 | NotSet |
SQL
convert date to string mm/dd/yyyy
|
| 133 | NotSet |
CFM
Manuel Query (table in Dot.Net)
|
| 134 | NotSet |
JAVAScript
Imporved popup window
|
| 135 | NotSet |
vb.net
Extract number from string
|
| 136 | NotSet |
SQL
QUERY to get the date prior to the selected date
|
| 137 | NotSet |
SQL
XTAB example using pivot
|
| 138 | NotSet |
SQL
resursive date generator
|
| 139 | NotSet |
SQL
Recursive select
|
| 140 | NotSet |
SQL
XTAB
|
| 141 | NotSet |
SQL *
Using WITH CTE (Common table expression)
|
| 142 | NotSet |
SQL
TEN WEEK update with 10wk averages
|
| 143 | NotSet |
ASP.NET
Profile setup
|
| 144 | NotSet |
DOT.NET
ADO.NET request time out for datasource
|
| 145 | NotSet |
SQL
NOLOCK
|
| 146 | NotSet |
SQL
compare all data with previous day USING CTE
|
| 147 | NotSet |
Dot.Net
MD5 Encryption vb and C#
|
| 148 | NotSet |
ASP.NET
Recursive function call example
|
| 149 | NotSet |
ASP.NET
loop through datareader
|
| 150 | NotSet |
ASP.NET
Roles/Profiles reference in class
|
| 151 | NotSet |
ASP.NET
ObjectDataProvider
|
| 152 | NotSet |
ASP.NET
data table
|
| 153 | NotSet |
SQL
Add Constraint
|
| 154 | NotSet |
DOT.NET
Basic DataReader Function
|
| 155 | NotSet |
DOT.NET
function to return code from sp
|
| 156 | NotSet |
DOT.NET
Find index of a GV rw from an added button
|
| 157 | NotSet |
ASP.NET
IMAGE and FILE UPLOAD CLASS (Resize)
|
| 158 | NotSet |
ASP.NET
SPECTRIUM Colors for a gridview
|
| 159 | NotSet |
asp.net
RECURSIVE Function for menus
|
| 160 | NotSet |
asp.net
mixing cs and vb
|
| 161 | NotSet |
C#
Get data item from gridview
|
| 162 | NotSet |
C#
find control two methods
|
| 163 | NotSet |
asp.net
facts a created and assigned stylesheet (C#) and and merging styles
|
| 164 | NotSet |
C#
copy yall base attributes from one control to another xxx.CopyBaseAttributes(this.Label1);
|
| 165 | NotSet |
CSS
swap out and or change style on mouseover
|
| 166 | NotSet |
SQL
Last 50 day average and today query using CTE
|
| 167 | NotSet |
C# vars
example of a simple static property
|
| 168 | NotSet |
DOT.NET VB
Display popup window from code behind
|
| 169 | NotSet |
C#
quick sort
|
| 170 | CsDotNet |
C# loop
loop through all controls on a page
|
| 171 | NotSet |
C# Arrays
array clone example
|
| 172 | TSql |
ASP.NET
TableAdapter C#
|
| 173 | NotSet |
C# isDBNul
how to acces sthe isdbnull in c# from the data reader
|
| 174 | NotSet |
asp.net
EVENTS can be wired to the same function
|
| 175 | TSql |
ARL
QUERY to show the index differeices for one date only! And 2nd to UPDATE FROM
|
| 176 | NotSet |
SQL
proc and function set to list column lypes
|
| 177 | NotSet |
C#
Convert.Int32(null)
|
| 178 | NotSet |
asp.net
add node function and sp
|
| 179 | NotSet |
C#
SWTICH and CASE
|
| 180 | NotSet |
vb.NET
To check if a value is an integer *** Integer.TryParse(i5c.ToString, j)
|
| 181 | NotSet |
JAVASCRIPT
sets body to focus on load onLoad="window.focus();"
|
| 182 | NotSet |
SQL
INSERT FROM with exclusion
|
| 183 | NotSet |
vb.net
simple function to convert MM/DD/YYYY to YYYYMMDD
|
| 184 | NotSet |
vb.net
Creates and returns a table
|
| 185 | NotSet |
asp.net
ABORT PAGE
|
| 186 | NotSet |
C# lists
simple example of creating and using lists
|
| 187 | NotSet |
DotNetNuke
links
|
| 188 | NotSet |
SQL
Utility sp_generate_inserts
|
| 189 | NotSet |
SQL
script to generate users from 200 for import into 2k5 and more
|
| 190 | NotSet |
asp.net
logout trick
|
| 191 | NotSet |
asp.net
asp.net 2.0 login authentication
|
| 192 | NotSet |
sql
rand int in a select
|
| 193 | NotSet |
php
replace with regx
|
| 194 | NotSet |
SQL
Trigger
|
| 195 | NotSet |
SQL
Example of EXISTS (and CTE)
|
| 196 | NotSet |
SQL
CREATE SCHEMA and user with default on schema
|
| 197 | VbDotNet |
Asp.net
table function of dates with day of week (text)
|
| 198 | NotSet |
SQL
if then else with update joins
|
| 199 | NotSet |
javascript
resize image
|
| 200 | NotSet |
SQL
Very complicated search query
|
| 201 | NotSet |
asp.net
Cross page postback with master page
|
| 202 | NotSet |
asp.net
recursive function to find controls of a type
|
| 204 | NotSet |
asp.net
eNum Stuff
|
| 205 | NotSet |
vb/C#
iif
|
| 206 | NotSet |
asp.net
add subheader or extra header
|
| 207 | NotSet |
SQL
view to list all collumns and related objects
|
| 208 | NotSet |
dot.net
simple recursive directory list
|
| 209 | NotSet |
dot.net
isolated storage
|
| 210 | NotSet |
macro
attach to asp.net shortcut macro for vs2k8
|
| 211 | NotSet |
SQL
Alter table not null, alter table add column
|
| 212 | NotSet |
Dot.Net
Inheareted controls
|
| 213 | NotSet |
TSQL
insert into temp table from stored proc
|
| 214 | NotSet |
TSQL
check for temptable existance
|
| 215 | NotSet |
dot.net
loop through properties in a business object
|
| 216 | NotSet |
dot.net
find difference between two dates
|
| 217 | NotSet |
VIEWSTATE
conversation with BF
|
| 218 | NotSet |
c#
function to find the cell number of a control
|
| 219 | NotSet |
dot.net
simple shapes using graphics
|
| 220 | NotSet |
dot.net
using IEnumerator
|
| 221 | NotSet |
dot.net
ApplicationSettingsBase
|
| 222 | NotSet |
SQL
ROW_NUMBER OVER today and yesterday join
|
| 223 | NotSet |
SQL SVR
collation sequence problem with SMS2008
|
| 224 | NotSet |
c#
simple dynamic Assembly example
|
| 225 | NotSet |
SQL
check for table existance
|
| 226 | NotSet |
cs.net
example og variable params in function call
|
| 227 | NotSet |
cs.net
Generic example
|
| 228 | NotSet |
dot.net
Enum get string using value
|
| 229 | NotSet |
dot.net
Spaced out camel case
|
| 230 | NotSet |
asp.net
Adding a hyperlink column to a gridview program
|
| 231 | NotSet |
Regex
dot.net regex to make email safe from spammers
|
| 232 | NotSet |
DOT.NET
IO to file
|
| 233 | NotSet |
SQL2K8
save Changes to Table Warning
|
| 234 | NotSet |
C#
simple deligate example
|
| 235 | NotSet |
c# asp.net
OnInit
|
| 236 | NotSet |
asp.net
display current row number in a gridview item template
|
| 237 | NotSet |
C#
Using reflection to get at the enums in the business layer
|
| 238 | NotSet |
Enum
Get Enum using name or numeric value
|
| 239 | CsDotNet |
.net css
Adding attributes to list control items
|
| 240 | NotSet |
c#
Pragma warning disable
|
| 241 | NotSet |
C# Lam, d
simple lamda and simple delegate examples
|
| 242 | NotSet |
asp.net
URLEncode DECode
|
| 245 | CsDotNet |
email connect dot.net
smtp connect dot.net
|
| 246 | GeneralInfo |
Server Administration
Remote Console from conmmand prompt
|
| 247 | CsDotNet |
PreRender
Hold Password Accross posts
|
| 248 | CsDotNet |
method to set connection
Email Client
|
| 249 | CsDotNet |
c# Shorthand example
short hand if then else if
|
| 250 | SQLStoredProcedure |
SP Get data from last DOM
get data from last business day of the month
|
| 251 | TSql |
tsql parse string list
isql to parse list into a table
|
| 252 | TSql |
Enable clr
Enable CLR on sqlserver
|
| 253 | SQLStoredProcedure |
THIS ARTICLE
SEARCH/FILTER Stored Procedure For This Article
|
| 254 | Iis |
VS Debugging
Debuging Howto's
|
| 255 | ASPNET |
format in binding expression
format in Eval
|
| 256 | SQLStoredProcedure |
Large Stored Procedure
Large Stored Procedure
|
| 257 | CsDotNet |
add to Constant contact
Add To constandContact
|
| 258 | TSql |
Date Functions
Get Last day of month
|
| 259 | GeneralInfo |
Jquery
jQuery IntelliSense in Visual Studio 2008
|
| 260 | GeneralInfo |
Guid problem
MVC app issues
|
| 261 | CsDotNet |
custom databinder
custom databinder for MVC
|