Why I Don't Use DataSets in My ASP.NET Applications

Why I Don't Use DataSets in My ASP.NET Applications

SharpMap - Open Source Mapping Engine for the 2.0 Common Language Runtime - Home

SharpMap - Open Source Mapping Engine for the 2.0 Common Language Runtime - Home

ASP.NET AJAX Random Image Rotator - Shawn Weisfeld [MVP]

ASP.NET AJAX Random Image Rotator - Shawn Weisfeld [MVP]

Web Forms User Controls

Paging for Gridview used Store procedure



ALTER PROCEDURE [dbo].[ProductGetAttributeNOTEmpty]
(
@CurrentPage tinyint=0,
@PageSize As tinyint=20,
@TotalRecords As int OUTPUT
)
AS
BEGIN

SET NOCOUNT ON;

-- Declare variables.
Declare @FirstRec int
Declare @LastRec int

-- Initialize variables.
Set @FirstRec = (@CurrentPage - 1) * @PageSize
Set @LastRec = (@CurrentPage * @PageSize + 1)

-- Create a temp table to hold the current page of data
-- Add an ID column to count the records
Create Table #TempTable
(
[TempId] int IDENTITY(1,1) PRIMARY KEY,
[productID] [int],
[productName] [nvarchar](150),
[createdOn] [datetime],
[createdBy] [nvarchar](50),
[modifiedOn] [datetime],
[modifiedBy] [nvarchar](50)
)

--Fill the temp table with the reminders
Insert Into #TempTable
(
[productID],
[attribute],
[productName],
[createdOn],
[createdBy],
[modifiedOn],
[modifiedBy]

)
Select
*
From
[dbo].[Product]
WHERE DATALENGTH([Products].[attribute]) <> 0

--Select one page of data based on the record numbers above
Select *
From
#TempTable As Products
Where
TempID > @FirstRec
And TempID < @LastRec

--Return the total number of records available as an output parameter
Select
@TotalRecords = Count(*)
From #TempTable
END

GridView Examples for ASP.NET 2.0

GridView Examples for ASP.NET 2.0

Creating a Stored Procedure for Custom Paging with the ASP.NET DataGrid Control

Creating a Stored Procedure for Custom Paging with the ASP.NET DataGrid Control: "@CurrentPage As tinyint, @PageSize As tinyint, @TotalRecords As int OUTPUT"

HOW TO: Using sorting / paging on GridView w/o a DataSourceControl DataSource - ASP.NET Forums

HOW TO: Using sorting / paging on GridView w/o a DataSourceControl DataSource - ASP.NET Forums

Multiple Fields Validator - An ASP.NET Validation Control - The Code Project - ASP.NET

Multiple Fields Validator - An ASP.NET Validation Control - The Code Project - ASP.NET

Custom Templated Pager Control - The Code Project - ASP.NET

Custom Templated Pager Control - The Code Project - ASP.NET

Insert user control every N records in gridview

Insert user control every N records in gridview: "e.Row.Cells.Clear();"

Drag and Drop Products to the Shopping Basket Using JavaScript - The Code Project - ASP.NET

Drag and Drop Products to the Shopping Basket Using JavaScript - The Code Project - ASP.NET

Web Forms User Controls

Web Forms User Controls

Web Server Controls Templates

Web Server Controls Templates: "er Control Templates Dynamically"