Binding GridDropDownColumn To SQL Data source

[Amit]

Hey,

I am not able to Populate dropdownlist with sql data source--aspx is

<telerik:GridDropDownColumn HeaderText="Items" UniqueName="column1" DataSourceID="SqlDataSource1"
                     ListTextField="ProductName" ListValueField="Pid" DataField="ProductName" >
                    </telerik:GridDropDownColumn>

Ans datasource is--

<asp:SqlDataSource ID="SqlDataSource1" runat="server" DataSourceMode="DataReader"
            ConnectionString="<%$ ConnectionStrings:ChalkHillConnectionString3 %>"
            SelectCommand="SELECT [ProductName] FROM [tblProducts] ORDER BY [Pid]"></asp:SqlDataSource>

I am trying to populate ddl from ProductName column of my tblProducts.
Does'nt seem to be workin'.I am getting this error--

'System.Data.Common.DataRecordInternal' does not contain a property with the name 'Pid'

Plz help..
Thanks
Amit

[Pavlina]

Hi Amit,

You should set the ListValueField property to the name of the field in the lookup table that supplies the value for the field specified by the DataField property.

For more information on configuring GridDropDownColumn, see Customize/Configure GridDropDownColumn.

Greetings,

Pavlina
the Telerik team

 

[Amit]

hey pavlina,

My db table tblProducts has Columns--Pid(PK),ProductName,Rate and Quantity.
I want grid dropdown column to have all the Values under ProductName Field when in edit mode.So,I am setting its ListValueField to "Pid" and TextField tp ProductName.Now,could you plz elaborate a bit about the solution.

Thanks
Amit

[Pavlina]

Hello Amit,

Try changing your code as shown below and let me know if it helps:
ASPX:

<telerik:GridDropDownColumn HeaderText="Items" UniqueName="column1" DataSourceID="SqlDataSource1"
                     ListTextField="ProductName" ListValueField="ProductName" DataField="ProductName" >
                    </telerik:GridDropDownColumn>

Kind regards,
Pavlina
the Telerik team