use same DetailsView for multiple purposes?

[Guest]

In some cases I would like to allow a user to select a row from a GridView to
update in another page using a DetailsView form (passing the key in
QueryString).

In other cases I would like to use the same DetailsView form to allow
general edit/insert/delete functions with Paging=true.

I can't figure out how to change the select statement from one case to the
other, e.g. if I have an SqlDataSource with:

SelectCommand="SELECT [VanId], ... [Active] FROM [Vans] WHERE
(VanId=@VanId)"
<SelectParameters>
<asp:QueryStringParameter QueryStringField="pk" Name="VanId" ... />
</SelectParameters>

How do I change the SelectCommand on the fly, e.g. when I want general
editing I would like to use:
SelectCommand="SELECT [VanId], ... [Active] FROM [Vans]"
and not use WHERE clause.

Any suggestions would be appreciated.

 

[Guest]

You could set the SQL statement without the where clause and then use the
SQLDataSource.FilterExpression property when you want to filter the results.
if you wanted to simulate.

SELECT field1,field2 from table where field1 = value

you would set the SelectCommand property to

SQLDataSource.SelectCommand="SELECT field1,field2 from table ";

then set

SQLDataSource.FilterExpression="field1 = value";

when you wanted to simulate the where clause.

To supply paramaters to the filter expression you can use
SQLDataSource.FilterParameters

 

[Guest]

Thanks that worked. I took it a step further, using FindControl to locate
the SqlDataSource and actually change the SelectCommnand string. That way
only the rows I want are selected instead of selecting all the rows and then
applying a filter.

Thanks again.

Michael

You could set the SQL statement without the where clause and then use the
SQLDataSource.FilterExpression property when you want to filter the results.
if you wanted to simulate.

SELECT field1,field2 from table where field1 = value

you would set the SelectCommand property to

SQLDataSource.SelectCommand="SELECT field1,field2 from table ";

then set

SQLDataSource.FilterExpression="field1 = value";

when you wanted to simulate the where clause.

To supply paramaters to the filter expression you can use
SQLDataSource.FilterParameters

In some cases I would like to allow a user to select a row from a GridView to
update in another page using a DetailsView form (passing the key in
QueryString).

In other cases I would like to use the same DetailsView form to allow
general edit/insert/delete functions with Paging=true.

I can't figure out how to change the select statement from one case to the
other, e.g. if I have an SqlDataSource with:

SelectCommand="SELECT [VanId], ... [Active] FROM [Vans] WHERE
(VanId=@VanId)"
<SelectParameters>
<asp:QueryStringParameter QueryStringField="pk" Name="VanId" ... />
</SelectParameters>

How do I change the SelectCommand on the fly, e.g. when I want general
editing I would like to use:
SelectCommand="SELECT [VanId], ... [Active] FROM [Vans]"
and not use WHERE clause.

Any suggestions would be appreciated.