/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

Named Recordsets

Hits: 545
*****
0.0

Nesting repeaters in .NET

Hits: 962
*****
1.0
Allowing multiple choices of
This is an example code
This article by James Shaw
Data repeaters in .NET are
data observations enables
showing how to conduct
demonstrates how to
very useful to display
people to customize views of
searches on a database to
dynamically add properties
database records onto
your data and adds value to
display hyperlinked
to an object (expando
screen. This tutorial shows
your applications. This
summaries that can be
properties) - by
you how easy nesting
example utilizes our db on
clicked on to display detail
implementing a function to
repeaters to save time.
the career statistics of
data.
create named recordsets.
Features example code and
Hammerin’ Hank Greenberg.
 
 
full explaination.
The years he played are
 
 
 
available to select from in
 
 
 
a dropdown menu. When
 
 
 
multiple years are selected
 
 
 
they are passed comma
 
 
 
delimited. Utilizing the
 
 
 
where in statement in our
 
 
 
sql the comma delimited
 
 
 
selections are appended to
 
 
 
our sql statement to display
 
 
 
only those years selected.
 
 
 


Date: Oct, 04 2000


Date: May, 21 2001


Date: Dec, 16 2000


Date: Feb, 03 2006
A discussion of how to use
You all must have seen and
Paging is basically querying
Dropdowns or combo boxes are
null values effectively in
done stuff with the
a database and presenting a
an excellent way to get
your database tables.
RecordSet object, infact
page full of the query's
input from a user. One of
Includes a discussion of the
everything is done with the
results. In ASP and SQL
the biggest problems with
logic behind nulls and some
RecordSet object. Now, this
Server programming, there
user input is spelling and
practical programming
acticle explains how to use
are three approaches to
formatting. Here is how to
techniques.
GetRows to page through the
paging. This article
use and populate dropdowns
 
records that you recieve
compares the approaches and
from a database.
 
from the SELECT. It's much
explains which one is the
 
 
faster than MoveNext,
most efficient when dealing
 
 
because it closes the
with very large sets of data.
 
 
database connection
 
 
 
immediately whereas MoveNext
 
 
 
loops through the records
 
 
 
with the overhead of the
 
 
 
database connection. Plus
 
 
 
GetRows let's you count the
 
 
 
records correctly!
 
 


Date: May, 01 2001


Date: Oct, 04 2003


Date: Mar, 08 2001


Date: Aug, 05 2002
{ Copyright } ©2019 NuclearScripts.com