Working with 2 Radgrids

[David]

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.

[Vladimir]

Hi David,

You can use SelectParameters to achieve this.

Vlad

[David]

It works. Thanks.