Ok, I'm a complete novice with Infragistics controls, but I've been doing .NET and other 3rd party controls for years.
I just downloaded the latest version and I'm starting a new project - I thought that I'd start with a simple task - bind a list of products to the Webdropdown. After all, I've done this for years using the standard <asp:dropdownlist> control.
When I run the page, the webDropDown contains "System.Object[]" repeated 6 times (because my sql statement is only returning 6 rows). Why isn't it databinding??
Yes, the SQL works.... Yes, If I databind to a <asp:Dropdownlist> it works...... So why does the WebDropDown display "System.Object[]" ?
Thanks - Jim
HTML:
<ig:WebDropDown ID="WebDropDown_Products" runat="server" Width="200px"> </ig:WebDropDown>
Code Behind:
protected void Load_WebDropDown_Products() { string queryString = "select top 6 prod_code from ProductCodes";
using (SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["xxxxxx_ConnectionString"].ConnectionString)) { System.Data.SqlClient.SqlCommand mysqlCommand = new System.Data.SqlClient.SqlCommand(queryString, myConnection); myConnection.Open(); SqlDataReader myDataReader = mysqlCommand.ExecuteReader(); WebDropDown_Products.DataSource = myDataReader; WebDropDown_Products.ValueField = "prod_code"; WebDropDown_Products.TextField = "prod_code"; WebDropDown_Products.DataBind(); myDataReader.Close(); } }
Hi,
We've all gone through the same problem. The dropdown is very sophisticated and can work with a table or a webdatagrid in the dropdown which makes it powerful but setting it up for the first time can be rough. Just look at the samples at Infragistics online samples and look at the markup there. It's worth it.
Ed
Thanks for the hint, but I have looked at their samples and haven't found one that does what I want.
Jim