Hi how do i fill ProductNameID on selection of ProductCategoryID dropdown by passing
ProductCategoryID .SelectedValue...
Please Reply ASAP its urgent
aspx Code
<asp:GridView ID="gridPosition" runat="server" AutoGenerateColumns="False" ShowFooter="True" OnRowDataBound="gridPosition_onRowDataBound"
DataKeyNames="SaleDetailID" OnRowEditing="gridPosition_RowEditing"
OnRowCancelingEdit="gridPosition_RowCancelingEdit" OnRowUpdating="gridPosition_RowUpdating"
OnRowDeleting="gridPosition_RowDeleting" ShowHeaderWhenEmpty="True" CssClass="manage-admin"
Width="500px" GridLines="None">
<Columns>
<asp:TemplateField HeaderText="ProductCategoryID">
<EditItemTemplate>
<asp:DropDownList ID="drpEditProductCategoryID" runat="server" CssClass="dropdown-b" AutoPostBack="true" OnSelectedIndexChanged="drpPartyName_SelectedIndexChanged"
DataSource='<%# getProductCategoryID() %>' DataTextField='ProductCategoryName'
DataValueField='ProductCategoryID' AppendDataBoundItems="true" SelectedValue='<%# Eval("ProductCategoryID").ToString() %>'>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblProductCategoryID" runat="server" Text='<%# GetProductCategoryName() %>' />
</ItemTemplate>
<FooterTemplate>
<span class="textfild">
<asp:DropDownList ID="drpProductCategoryID" runat="server" CssClass="dropdown-b" AutoPostBack="true" OnSelectedIndexChanged="drpPartyName_SelectedIndexChanged"
DataSource='<%# getProductCategoryID() %>' DataTextField='ProductCategoryName'
DataValueField='ProductCategoryID' AppendDataBoundItems="true">
</asp:DropDownList>
<br />
</span>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ProductNameID">
<EditItemTemplate>
<asp:DropDownList ID="drpEditProductNameID" runat="server" CssClass="dropdown-b" AutoPostBack="true"
DataSource='<%# getProductNameID() %>' DataTextField='ProductName' DataValueField='ProductID'
AppendDataBoundItems="true" SelectedValue='<%# Eval("ProductNameID").ToString() %>'>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblProductNameID" runat="server" Text='<%# GetProductName() %>' />
</ItemTemplate>
<FooterTemplate>
<span class="textfild">
<asp:DropDownList ID="drpProductNameID" runat="server" CssClass="dropdown-b" AutoPostBack="true"
DataSource='<%# getProductNameID() %>'
DataTextField='ProductName' DataValueField='ProductID' AppendDataBoundItems="true">
</asp:DropDownList>
<br />
</span>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ProductItemCodeID">
<EditItemTemplate>
<asp:DropDownList ID="drpEditProductItemCodeID" runat="server" CssClass="dropdown-b"
DataSource='<%# getProductItemCodeID() %>' DataTextField='ProductItemCode' DataValueField='ProductITemID'
AppendDataBoundItems="true" SelectedValue='<%# Eval("ProductItemCodeID").ToString() %>'>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblProductItemCodeID" runat="server" Text='<%# GetProductItemCode() %>' />
</ItemTemplate>
<FooterTemplate>
<span class="textfild">
<asp:DropDownList ID="drpProductItemCodeID" runat="server" CssClass="dropdown-b" AutoPostBack="true"
DataSource='<%# getProductItemCodeID() %>' DataTextField='ProductItemCode' DataValueField='ProductItemID'
AppendDataBoundItems="true">
</asp:DropDownList>
<br />
</span>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Qty">
<EditItemTemplate>
<asp:TextBox ID="txtEditQty" runat="server" Text='<%# Bind("Qty") %>' style="width:50px;" CssClass="textbox-b" />
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblQty" runat="server" Text='<%# Eval("Qty") %>' />
</ItemTemplate>
<FooterTemplate>
<span class="textfild">
<asp:TextBox ID="txtQty" runat="server" CssClass="textbox-a" style="width:50px;" onkeypress="return isNumberKey(event)" />
</span>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Rate">
<EditItemTemplate>
<asp:TextBox ID="txtEditRate" runat="server" Text='<%# Bind("Rate") %>' style="width:50px;" CssClass="textbox-b"
onkeypress="return isNumberKeyOrDot(event)" />
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblRate" runat="server" Text='<%# Eval("Rate") %>' />
</ItemTemplate>
<FooterTemplate>
<span class="textfild">
<asp:TextBox ID="txtRate" runat="server" CssClass="textbox-a" style="width:50px;" onkeypress="return isNumberKeyOrDot(event)" />
</span>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField ItemStyle-CssClass="nowrap" ItemStyle-HorizontalAlign="Center"
ItemStyle-Width="10%">
<EditItemTemplate>
<asp:LinkButton ID="lnkSavePosition" runat="server" Text="Save" CommandName="Update"
ValidationGroup="EditPosition" CausesValidation="true"> <img src="images/save.png" alt="Save" title="Save"/></asp:LinkButton>
<asp:LinkButton ID="lnkCancelPosition" runat="server" Text="Cancel" CommandName="Cancel"> <img src="images/icon_remove.png" alt="Cancel" title="Cancel"/></asp:LinkButton>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="lnkEditPosition" runat="server" Text="Edit" CommandName="Edit"
CausesValidation="false"> <img src="images/edit.png" alt="Edit" title="Edit"/></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<FooterTemplate>
<span class="add-button">
<asp:LinkButton ID="btnNewDel" runat="server" ValidationGroup="Position" CssClass="button-style"
OnClick="btnNewDel_Click"> <span>Add</span></asp:LinkButton></span>
</FooterTemplate>
</asp:TemplateField>
</Columns>
<EmptyDataTemplate>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17%">
<asp:DropDownList ID="drpProductCategoryID" runat="server" CssClass="dropdown-b" AutoPostBack="true" OnSelectedIndexChanged="drpPartyName_SelectedIndexChanged"
DataSource='<%# getProductCategoryID() %>' DataTextField='ProductCategoryName'
DataValueField='ProductCategoryID' AppendDataBoundItems="true">
</asp:DropDownList>
</td>
<td>
<asp:DropDownList ID="drpProductNameID" runat="server" CssClass="dropdown-b" AutoPostBack="true"
DataSource='<%# getProductNameID() %>' DataTextField='ProductName' DataValueField='ProductID'
AppendDataBoundItems="true">
</asp:DropDownList>
</td>
<td>
<asp:DropDownList ID="drpProductItemCodeID" runat="server" CssClass="dropdown-b" AutoPostBack="true"
DataSource='<%# getProductItemCodeID() %>' DataTextField='ProductItemCode' DataValueField='ProductItemID'
AppendDataBoundItems="true">
</asp:DropDownList>
</td>
<td>
<asp:TextBox ID="txtQty" runat="server" CssClass="textbox-a" width="50px" onkeypress="return isNumberKeyOrDot(event)" />
</td>
<td>
<asp:TextBox ID="txtRate" runat="server" CssClass="textbox-a" width="50px" onkeypress="return isNumberKeyOrDot(event)" />
</td>
<td>
<asp:LinkButton ID="btnemptyInsert" runat="server" ValidationGroup="Drug" CssClass="button-style"
OnClick="btnemptyInsert_Click"> <span>Add</span></asp:LinkButton>
</td>
<td width="17%">
</td>
<td width="16%">
</td>
</tr>
</table>
</EmptyDataTemplate>
</asp:GridView>