repeater and querrystring

[Kelly Zhu]

The repeater control works fine for me. But how can I make it accept a
querrystring? The repeater has a tag called selectcommand. Can I insert a
where clause including the querrystring? Thanks.

[Mike Placentra II]

On Nov 21, 12:27 pm, "Kelly Zhu" <kelly....@tstc .eduwrote:

The repeater control works fine for me. But how can I make it accept a
querrystring? The repeater has a tag called selectcommand. Can I insert a
where clause including the querrystring? Thanks.

You can use an SqlDataSource control with the Repeater, and the
SqlDataSource can get its parameters from the querystring. Here's an
example:

<asp:Repeater ID="Repeater1" runat="server"
DataSourceID="S qlDataSource1" />

<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="..."
SelectCommand=" SELECT @parameter AS data">
<SelectParamete rs>
<asp:QueryStrin gParameter Name="parameter "
QueryStringFiel d="parameter" />
</SelectParameter s>
</asp:SqlDataSour ce>

-Michael Placentra II

[=?Utf-8?B?QnJhdWxpbyBEaWV6?=]

This article explains you how to add pagination using the querystring on a
repeater:

http://weblogs.asp.net/scottgu/archi...07/434787.aspx

Well and more... how to do efficient paging throuh SQL.

Good luck
Braulio

/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"Kelly Zhu" wrote:

The repeater control works fine for me. But how can I make it accept a
querrystring? The repeater has a tag called selectcommand. Can I insert a
where clause including the querrystring? Thanks.