Hi ,

am using gridview in a edititemtemplate of the gridview  colums am using 3 dropdownlist .. In a Edit mode Based on the one dropdownlist selected value another 2 dropdownlist shold bind .How to do this .. For Example 

am binding Product table to gridview. First Colum is Product Code,Second Colum is Product Name, Third Colum is Product Price and Forth colum is Quantity  In the Edit mode based on the Selected Product Name colums Dropdownlist .First and Third Colums Dropdownlist will load ..

Can anybody help me to solve this ..

this is my aspx page 

AutoGenerateEditButton="True" CellPadding="4" DataKeyNames="OrdID" 
DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" 
onrowcommand="GridView1_RowCommand" onrowdatabound="GridView1_RowDataBound" 
onrowediting="GridView1_RowEditing" Width="593px">


ReadOnly="True" SortExpression="OrdID" Visible="False" />
SortExpression="ProductID" Visible="False" />


DataSourceID="sqldatasource_code" DataTextField="ProductCode" 
DataValueField="ProductCode">

ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [ProductCode] FROM [Product] WHERE ([ProductName] = @ProductName) 
and ([ProductRemarks] <> 'Dist')

">











DataSourceID="SqlDataSource_prdname" DataTextField="ProductName" 
DataValueField="ProductName" AutoPostBack="True" 
onselectedindexchanged="DropDownList30_SelectedIndexChanged">

ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT Distinct [ProductName], [ProductDiscounts] FROM [Product]
WHERE (([ProductRemarks] <> 'Nil') and ([ProductRemarks] <> 'Dist') 
and ([ProductRemarks] <> 'EXP')) ORDER BY [ProductDiscounts], [ProductName]" 
CancelSelectOnNullParameter="False">















DataSourceID="SqlDataSource_pricve" DataTextField="ProductBasePrice" 
DataValueField="ProductBasePrice">

ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 

SelectCommand="SELECT [ProductBasePrice] FROM [Product] WHERE ([ProductName] = @ProductName) and ([ProductRemarks] <> 'Dist')" 
ConflictDetection="CompareAllValues">

















Visible="False">


















ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
SelectCommand="SELECT [OrdID], [ProductID], [ProductCode], [ProductQty], [ProductName], [ProductBasePrice], [POValue], [Category] FROM [POTable] WHERE ([PONO] = @PONO)">



Thanks in advance