Approaches to Paging through Large DataSet

Sql Server 2000

1. http://www.4guysfromrolla.com/webtech/042606-1.shtml - A More Efficient Method for Paging Through Large Result Sets
2. http://www.4guysfromrolla.com/webtech/041206-1.shtml - Efficiently Paging Through Large Result Sets in SQL Server 2000

Sql Server 2005

1. http://www.asp.net/learn/dataaccess/tutorial25vb.aspx?tabid=63 - ASP.NET 2.0

Pagin Cursor Approach

1. http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/20ce9a296fa23a81/509bbac9261f02a0?lnk=st&q=anonieko&rnum=1#509bbac9261f02a0

Articles by Saravana Kumar on ASP.NET 2.0 ans SQL

Good site to view articles at Extreme Experts
http://www.extremeexperts.com/Net/Articles/default.aspx

Running Different .NET versions in ASP.NET / Application Pool

Ken Egozi : IRresistible - Running ASP.NET applications of various versions side-by-side: "Running ASP.NET applications of various versions side-by-side
Some annoying problem I've encountered lately.
While developing on my XP machine, I have had some ASP.NET 1.1 applications and ASP.NET 2.0 applications running side-by-side, as virtual directories on the single website allowed by IIS5.1
When I've published an ASP.NET 2.0 application to a production server, running IIS6.0 (on Windows 2003 Server) with already installed ASP.NET 1.1 applications, I've found out that if the old applications are running, the new one returns 'Server Application Unavailable', and vice versa.
A quick search in the Event Viewer revealed that IIS isn't fond of running applications of different ,NET runtime version, in the same process. Quite reasonable that is, yet annoying.
That's when I remembered that I've always said to myself that I should look into the reason that IIS5.0 and IIS5.1 runs each ASP.NET application in a aspnet_wp.exe worker process, while IIS6.0 uses a single w3wp.exe worker process.
A little web search and I've found this: http://technet2.microsoft.com/WindowsServer/en/Library/d0a61f24-942e-4379-adad-8232be03441c1033.mspx, and adjacent pages.
So this is a new feature of ASP.NET, that makes it possible to run a few applications in the same process. Every few applications (virtual directories) are assigned to an application pool, and each application pool runs in its own process.
There are a few settings that can be done for each application pool. Those settings are overriding the defaults in the machine.config file.
Adding an application pool is done through inetmgr.msc, by just adding a new pool to the Application Pools section. Use the option to copy settings from t"

Grab Bags and Database Models

http://del.icio.us/jyotirmaya - list of grab bags free


http://www.databaseanswers.org/data_models/

a web developers cheat sheet list

a web developers cheat sheet list http://succor.co.uk/index.cfm/2006/3/21/a-web-developers-cheat-sheet

Great Online Ebook on C# Threading

c# supports parallel execution of code through multithreading. A thread is an independent execution path, able to run simultaneously with other threads.
A C# program starts in a single thread created automatically by the CLR and operating system (the "main" thread), and is made multi-threaded by creating additional threads. Here's a simple example and its output http://www.albahari.com/threading/

Biztalk Links

Virtual Labs Home: BizTalk Server

http://blogs.msdn.com/gsnowman/default.aspx

http://blogs.msdn.com/gsnowman/archive/2006/01/15/513159.aspx

A Primer on Using DB2 with .NET

15 Seconds : A Primer on Using DB2 with .NET: "
By Chip IrekRating: 4.4 out of 5
Rate this article


print this article

email this article to a colleague

suggest an article
Introduction
Working with DB2, from a .NET application developer's perspective, is just like working with any other relational database. One can find endless examples of how to perform databases tasks (from the mundane to the interesting) for Microsoft SQL Server and Oracle, but there is not as much similar documentation for accessing DB2 from Microsoft technologies, including .NET.
A developer currently has different access techniques to programmatically connect .NET programming clients to DB2. For each of these the code is basically the same thanks to the providers involved, but some interesting limitations exist that you should consider."

.NET XML Web Services Repertory

http://www.xmlwebservices.cc/index.htm

Christian Weyer is an expert for Microsoft and Web technologies with focus on .NET. Since the end of 1999 he plays and works with XML, SOAP and related Web Services technologies with having a background of DCOM, CORBA and Java. Being a founding partner of thinktecture he regularly speaks on developer conferences and other events - lately he has been elected as an official speaker for the European INETA speaker's bureau. Christian writes German and English articles about the latest and most promising technologies.Additionally, he is an MVP for ASP.NET and XML Web Services for being very active and knowledgeable in the .NET and Web Services community. Christian is also a Microsoft Regional Director for Germany.His hobbyhorse all around .NET and XML Web Services is the site known as '.NET XML Web Services Repertory'. This place is dedicated to building Web Services on the .NET platform, especially focused on ASP.NET. Here you can find lots of sample code (also available as online demos), a Web Services FAQ, an Essential Tools overview and a growing collection of useful links. Additionally it provides information on interoperability and integration with other SOAP or Web Services platforms - e.g. Systinet WASP, Apache SOAP, Apache Axis or IBM Web Services Toolkit.

Sandcastle plugins and gui creators

http://weblogs.asp.net/astopford/archive/2006/08/09/Sand-for-my-Sandcastle.aspx

ASP.NET Supervising Controller (Model View Presenter) From Schematic To Unit Tests to Code

http://haacked.com/archive/2006/08/09/ASP.NETSupervisingControllerModelViewPresenterFromSchematicToUnitTestsToCode.aspx

Aug 09, 2006 Add Comment Print Martin Fowler recently split the Model-View-Presenter pattern into two new patterns, Supervising Controller and Passive View. They are pretty much two different flavors of the MVP pattern differentiated by how much application logic is placed within the view.

ASPFAQ : SQL Server 2005

ASPFAQ : SQL Server 2005: "
Number of articles: 29
Last update: 2006-05-17
What version of SQL Server 2005 do I have?
How do I manage / connect to SQL Server Express?
Can I download Books Online separately?
What should I know about Express Manager (XM)?
Where do I post issues and questions about SQL Server 2005?
What happened to IntelliSense?
Why does SQL Server 2005 break SQL Server 2000 tools?
How do I view the code for system objects?
What happened to Database Diagrams?
What happened to the 'Open Table' feature?
Why don't Query Analyzer shortcut keys work?
When will SQL Server 2005 be released?
Why is xp_cmdshell disabled?
Why won't Profiler start?
Can I still modify system objects like in SQL Server 2000?
Where do I get SQL Server 2005?
How do I remove previous versions of SQL Server 2005 / Whidbey?
How do I change password policies in SQL Server 2005?
Where else can I learn about SQL Server 2005?
How do I hide system objects in Management Studio's Object Explorer?
How does SQL Server 2005 Express compare to MSDE?
How do I select multiple objects in Object Explorer?
Why is there still no LIMIT clause?
What happened to the DATE and TIME datatypes?
What parts of ANSI SQL-99 have been added to SQL Server 2005? (in progress)
How do I attach a database to SQL Server 2005? (in progress)
Are there better ways to page a resultset in SQL Server 2005? (in progress)
What are the problems with the new PIVOT and UNPIVOT operators? (in progress)
How can I use DDL triggers? (in progress)"

How to create a simple setup program for your administrator to run.

How to create a simple setup program for your administrator to run.

This post is better read in mono-space format.

Scenario: As usual you don't have the access right to do ClickOnce
'publish' option. It's just how big companies work so
you have to work with the deployment team.

Well, your ever witty manager tells you to write
an install file that will automatically unzip and copy
the deployment files. Let the administrator run it and
never you.

You know exactly that a virtual directory already
exists and the exact location of this in the server.
Say example "c:\inetpub\wwwroot\MyClient" It
was setup before by someone.

Let me think:

I can create an msi file but it is too much. Hmm...

I can not use Visual Studio 'Setup Project' to create
one msi because it is too much work. Besides it
is considering dependencies like .NET framework
automatically. The thing I don't need here.

So what do I do???


My Solution:

Use 7zip file to create a self extracting file.
It is open source and free It can be downloaded at 7zip.org

The instructions are less clear in 7zip.org but you can
follow it after a few trials. Don't worry, to speed
you up I will describe an example setup.

For example. Imagine you have a directory like these
note ('\' means a folder)


C:
|
+---\WorkArea
|
+---\ClickOnceFiles
| |
| +---\MyClickOnceApp_0_1_0_4
| | |
| | +--
| |
| +---MyClickOnceApp.application
| +---MyClickOnceApp_0_1_0_4.application
| +---publish.htm
| +---setup.exe
| +---run.bat
|
+---\Output
|
+---7za.exe
+---7zSD.sfx
+---config.txt
+---create.bat


First, you can publish locally to your computer to the
'ClickOnceFiles' Folder as above.


Secondly, note that 'run.bat' is copied inside the folder
together with the ClickOnce deployment files.
This is intentional because it will part of the zip
component.

All you have to do is the run CREATE.bat, and it will produce
MySetup.exe in the output directory.

Yes, give MySetup.exe to your system administrator.
(better give its md5 hash also for peace of mind).
And you will look 'cool' from now on.

-------------
Ok, now the descriptions and contents of these files.

The files 7za.exe, 7zSD.sfx can be downloaded from 7zip.org
Look for 7z Library, SFXs for installers


create.bat
----------

del TempFile.7z
7ZA a -r TempFile.7z C:\WorkArea\ClickOnceFiles\*.*
copy /b 7zSD.sfx + config.txt + TempFile.7z output\MySetup.exe
del TempFile.7z


config.txt
----------

;!@Install@!UTF-8!
Title=" Client ClickOnce Files Setup- (C)2006 "
BeginPrompt="Do you want to update Client Deployment Files?"
RunProgram="run.bat"
;!@InstallEnd@!



run.bat
-------

(I know, I know this is not optimized, you can probably use variables
to store the virtual directory path, etc...) but here it is.


@ECHO OFF
CLS


IF NOT EXIST c:\inetpub\wwwroot\MyClient GOTO ERROR_DIR

XCOPY *.* c:\inetpub\wwwroot\MyClient /s /Y 1> nul 2> nul
if ERRORLEVEL 1 GOTO :ERROR_COPYING
REM DEL c:\inetpub\wwwroot\MyClient\*.bat

@ECHO ******************************************
@ECHO * *
@ECHO * SUCCESS IN COPYING DEPLOYMENT FILES!! *
@ECHO * *
@ECHO * Thanks Mr. Admin! - ERV *
@ECHO * *
@ECHO ******************************************

GOTO END_BATCH

:ERROR_DIR
@ECHO ******************************************
@ECHO * *
@ECHO * ERROR! APP VIRTUAL DIR NOT FOUND *
@ECHO * *
@ECHO * For Client to deploy this virtual *
@ECHO * directory which point to folder *
@ECHO * *
@ECHO * c:\inetpub\wwwroot\MyClient must *
@ECHO * *
@ECHO * must exist! *
@ECHO * *
@ECHO * *
@ECHO ******************************************

GOTO END_BATCH

:ERROR_COPYING
@ECHO ******************************************
@ECHO * *
@ECHO * ERROR IN COPYING FILES. NOT DEPLOYED *
@ECHO * *
@ECHO ******************************************


:END_BATCH
PAUSE