
| Protected Sub RadGrid1_UpdateCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) |
| IF RadGrid1.SelectedItems.Count > 0 THEN |
| For Each SelectedItem As GridEditableItem In RadGrid1.SelectedItems |
| Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem) |
| Dim formItem As GridEditFormItem = CType(e.Item,GridEditFormItem) |
| Dim parentItem As GridDataItem = CType(formItem.ParentItem,GridDataItem) |
| Dim strProductID As String = parentItem("ProductID").Text |
| Dim strCategoryID As String = RadComboBoxBatchDescribeCat.SelectedValue |
| Dim Price As String = RadComboBoxBatchDescribePrice.SelectedValue |
| SqlHelper.ExecuteNonQuery(_connectionString, "Batch_Apply", strProductID,strCategoryID,Price) |
| Next |
| ELSE |
| End if RadGrid1.Rebind() |
| End Sub |
<EditFormSettings EditFormType="Template">
<FormTemplate>
<table width="100%">
<tr>
<td>
<asp:Label ID="lblUserName" runat="server" Text="User Name"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtUserName" runat="server" Text='<%# Bind("Username") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblInitialPwd" runat="server" Text="Initial Password"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtInitialPwd" runat="server" Text='<%# Bind("InitialPassword") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblUserpassword" runat="server" Text="User Password"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtUserpassword" runat="server" Text='<%# Bind("UserPassword") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblEmail" runat="server" Text="E-mail"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtEmail" runat="server" Text='<%# Bind("Email") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td width="10%">
</td>
<td width="90%">
<table>
<tr>
<td><span style="font-weight:bold; font-size:10pt"></span>
<asp:Label ID="lblAccountNumber" runat="server" Text='<%# Bind("AccountNumber") %>' Font-Bold="true" Font-Size="10"></asp:Label><br />
<asp:ListBox ID="lbAllAccountNumbers" DataSourceID="objAllAccountNumbers" runat="server" Width="200" Height="200"></asp:ListBox>
<asp:Button ID="btnSelect" runat="server" Text=">" />
<asp:Button ID="btnUnselect" runat="server" Text="<" />
<asp:ListBox ID="lbAvailableAccountNumbers" DataSourceID="objAllAccountNumbers" runat="server" Width="200" Height="200">
</asp:ListBox>
</td>
</tr>
</table>
</td>
</tr>
</table>
</FormTemplate>
</EditFormSettings>
I have two SqlDatSource 1 datasource for grid and one for ListBox.
I set up a Datakey name For the grid which will server as the parameter for the ListBox SqlDataSource.
I tried setting up the parameter for ListBox Datasource from Grid ItemDataBound but when doing Find Control method returns null.
below is my code behind
if
(e.Item is GridEditFormItem)
{
ListBox lbAllAccountNumbers = (ListBox)e.Item.FindControl("lbAllAccountNumbers");
SqlDataSource ds = (SqlDataSource)lbAllAccountNumbers.DataSource;
ds.SelectParameters[
"@LoginId"].DefaultValue = grdAffiliate.Items[e.Item.ItemIndex].OwnerTableView.DataKeyValues[e.Item.ItemIndex]["LoginId"].ToString();
lbAllAccountNumbers.DataSource = ds;
lbAllAccountNumbers.DataBind();
}
lbAllAccountNumbers is getting null value


| <telerik:RadGrid ID="_gridSPMIG" runat="server" AutoGenerateColumns="False" AllowPaging="True" AllowSorting="True" Skin="Telerik" PageSize="25" OnPageSizeChanged="OnPageSizeChanged" ShowGroupPanel="True"> | |
| <MasterTableView TableLayout="Fixed"> | |
| <RowIndicatorColumn> | |
| <HeaderStyle Width="20px" /> | |
| </RowIndicatorColumn> | |
| <ExpandCollapseColumn> | |
| <HeaderStyle Width="20px" /> | |
| </ExpandCollapseColumn> | |
| <Columns> | |
| <telerik:GridBoundColumn DataField="SPIN" HeaderText="SPIN" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="Suffix" HeaderText="Suffix" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="Nomenclature" HeaderText="Nomenclature" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="Modifier" HeaderText="Modifier" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="Category" HeaderText="Category" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="APL" HeaderText="APL" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="Part No." HeaderText="Part Number" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="SCAT Code" HeaderText="SCATCD" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="scat_ds" HeaderText="SCAT" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="NIIN" HeaderText="NIIN" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="Cage" HeaderText="Cage" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="Remarks" HeaderText="Remarks" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="ui_ds" HeaderText="Unit of Issue" UniqueName="column"> | |
| </telerik:GridBoundColumn> | |
| </Columns> | |
| </MasterTableView> | |
| <ClientSettings AllowDragToGroup="True"> | |
| <Scrolling AllowScroll="True" UseStaticHeaders="True" /> | |
| <Resizing AllowColumnResize="True" /> | |
| </ClientSettings> | |
| <PagerStyle Wrap="True" /> | |
| </telerik:RadGrid> |