This is a migrated thread and some comments may be shown as answers.

Working with 2 Radgrids

2 Answers 26 Views
Grid
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 1
David asked on 02 Oct 2008, 06:06 PM
I'm using 2 radGrids. The second one display data based on the selection on the first grid. The second grid is been populate by a store proc that expect one parameter. When I use the name of the data column from the first data set as @Column it gives me an error as Must declare the scalar variable "@Column".  I tried hard coding the value in the second datasource (SelectCommand) and is working fine. How I'm suppost to declare or handle this column name? If you look the example on the web it looks like:

SelectCommand="SELECT [OrderID], [OrderDate], [CustomerID], [ShipCountry] FROM [Orders] WHERE ([CustomerID] = @CustomerID)

Thanks for any help on this.

2 Answers, 1 is accepted

Sort by
0
Vladimir
Top achievements
Rank 1
answered on 02 Oct 2008, 07:14 PM
Hi David,

You can use SelectParameters to achieve this.

Vlad
0
David
Top achievements
Rank 1
answered on 02 Oct 2008, 07:34 PM
It works. Thanks.
Tags
Grid
Asked by
David
Top achievements
Rank 1
Answers by
Vladimir
Top achievements
Rank 1
David
Top achievements
Rank 1
Share this question
or