Code Archive

.Net
JavaScript
SQL

Access GridView Row Items from Button Click Event	Insert blank item in control when binding to SqlDataSource
Add or Remove File Attributes	Iterate NameValuecollection from request.form
AddHandler example in VB	List files in directory
Adding Meta Tags to Child Pages	Load menu items dynamically
Asp.net Connection String shortcut	Loading javaScript server side in code behind
Assigning a Theme in Code	Manually load ListBox control
Bind a delegate object to a shared method	Merging two text files
Binding a Delegate to an Instance Method	oleDB Connection string to text file
Check for null value in database updates	Parsing comma-delimited file
Check for valid date range	Pass value to another page using PreviousPage
Class Definition Example	Passing array to web service
Class for sorting Array or ArrayList by Name Length or Last Modified	Popup Calendar
Combine two arrays into one	Prevent page from being cached
Comparison<T> delegate	Read Database and return dataset
Connecting to Access Database	Read XML File with XmlTextReader
Copy one dataset to another	Read XML into DataSet
Custom Paging with repeaterItems	Reference user control's click event in main page
Custom Sorting with IComparer	Retrieve Output Parameter From Stored Procedure
Default ConnectionString for LocalSqlServer	Reverse Sort using generic delegate and generic list
Delete Confirmation Popup Box	Saving custom control values to viewstate
Disabling Back button in ASP.NET	Send Emial With SMTP Client
Display Session variables	Serialize DataSet to XML
Enable postback in jquery dialog	Simple Delegate example
Export DataSet to Comma-Delimited File	Singleton Pattern
Export Gridview to excel	Sleep thread to pause application
Export GridView to Word	Sort dataset table
Exporting dataset to comma delimited file	Sort directory list by creation date
Find Control in ContentPlaceHolder of PreviousPage	Sort in descending order using IComparer
FindControl and PreviousPage with Master Pages	Sorting an ArrayList
Formating Date and Time Using ToString	Trim Date Function with override to handle null dates
Get Physical path of web site directory	Using parameters in .Net console application
Get physical path using Server.MapPath	vbCRLF Equivelent in C#
Gmail as SMTP Server	Web Service Function that Adds Database Record
Gridview - conditional row coloring	Windows Media Player in .Net Page
Handling Arrays of HTML Input Elements with Request.Form	WithEvents - Adding event from a class
Implementing Collections.CollectionBase to save collection of objects	Writing dataset to coma delimited text File

CREATE SYNONYM for Schema Table	Numeric values to use in Convert for Dates
Create table for displaying convert numeric values	Passing Parameters to Stored Procedure in .Net
Display Date in YYYYMMDD Format in SQL	Pivot Syntax
Format Money fields in SQL	Pivot Table Example
Format SQL DateTime field as Short Date	Pivot Table Example Pre SQL Server 2005
Get DateTime with Time set to zero in T-SQL	Query SQL Database by type
Get random row from table in T-SQL	Script to Copy SQL Server 2000 Permissions
Grant Execute Rights To Stored Procedure	Script to Copy SQL Server 2005 Permissions
List open connections on SQL Server 2005	Search for a string in all stored procedures
List Stored Procedures	Search Routine in Stored Procedure
Logins created in the last x days	Stored Procedure with output parameter
Merging two database fields using pivot table as input	Using the Coalesce Statement in Select Queries

Create jQuery function	Maintain selected jQuery tab on postback in .Net
Function to open new window	Reference .Net control in jQuery
JavaScript to hide DIV	Test for values in an array

CurtisCook.net