DaniWeb IT Discussion Community - View Single Post - Master/Detail DropDownList and DataGrid

Re: Master/Detail DropDownList and DataGrid

Dec 2nd, 2008

As i understood from you code in selectindexchanged event:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
daItems.SelectCommand.CommandText = "Select ProductName, UnitPrice, UnitsInStock, ProductImage from dbo.Products where CategoryID = "                + ddlItems.SelectedItem.Value;
daItems.SelectCommand.CommandText = "Select ProductName, UnitPrice, UnitsInStock, ProductImage from dbo.Products where CategoryID = "                + ddlItems.SelectedItem.Value;

You are passing param "categoryId", therefore u need to bind
dddl1.DataValueField = "categoryid"

Pls. let me know your exact concern

$Yousuf$
$Software Developer$