Hello Jason Lee,
What about returning an empty array. Is that acceptable for you?
public RadComboBoxItemData[] GetProducts(object context)
{
IDictionary<string, object> contextDictionary = (IDictionary<string, object>) context;
SqlConnection connection =
new SqlConnection(ConfigurationManager.ConnectionStrings["TelerikConnectionString"].ConnectionString);
string filterString = ((string) contextDictionary["FilterString"]).ToLower();
SqlCommand selectCommand =
new SqlCommand(@" SELECT ID, ProductName FROM Products
WHERE LOWER(ProductName) LIKE '" + filterString + "%'", connection);
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
DataTable products = new DataTable();
adapter.Fill(products);
List<RadComboBoxItemData> result = new List<RadComboBoxItemData>(products.Rows.Count);
foreach (DataRow row in products.Rows)
{
RadComboBoxItemData itemData = new RadComboBoxItemData();
itemData.Text = row["ProductName"].ToString();
itemData.Value = row["ID"].ToString();
result.Add(itemData);
}
return result.ToArray();
}
You can leave the "result" list empty.
Regards,
Nick
the Telerik team