Code Archive

.Net
JavaScript
SQL

Access GridView Row Items from Button Click Event	List files in directory
Add or Remove File Attributes	Load menu items dynamically
AddHandler example in VB	Loading javaScript server side in code behind
Adding Meta Tags to Child Pages	Manually load ListBox control
Asp.net Connection String shortcut	Merging two text files
Assigning a Theme in Code	oleDB Connection string to text file
Bind a delegate object to a shared method	Parsing comma-delimited file
Binding a Delegate to an Instance Method	Pass value to another page using PreviousPage
Check for null value in database updates	Passing array to web service
Check for valid date range	Popup Calendar
Class Definition Example	Prevent page from being cached
Class for sorting Array or ArrayList by Name Length or Last Modified	Read Database and return dataset
Combine two arrays into one	Read XML File with XmlTextReader
Comparison<T> delegate	Read XML into DataSet
Connecting to Access Database	Reference user control's click event in main page
Copy one dataset to another	Retrieve Output Parameter From Stored Procedure
Custom Paging with repeaterItems	Reverse Sort using generic delegate and generic list
Custom Sorting with IComparer	Saving custom control values to viewstate
Default ConnectionString for LocalSqlServer	Send Emial With SMTP Client
Delete Confirmation Popup Box	Serialize DataSet to XML
Display Session variables	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#
Gridview - conditional row coloring	Web Service Function that Adds Database Record
Handling Arrays of HTML Input Elements with Request.Form	Windows Media Player in .Net Page
Implementing Collections.CollectionBase to save collection of objects	WithEvents - Adding event from a class
Insert blank item in control when binding to SqlDataSource	Writing dataset to coma delimited text File
Iterate NameValuecollection from request.form

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