or
<telerik:RadDropDownList ID="BatchRadDropDownList" runat="server" OnItemSelected="BatchNameSelected" AutoPostBack="true" DefaultMessage="- Batch Names -"></telerik:RadDropDownList>protected void RadGridActionItem_NeedDataSource(object sender, GridNeedDataSourceEventArgs e){ // Provides RadGrid with Action Item data. List<IDataParameter> Parms = null; string SQL = string.Empty; DataTable dt; try { using (DataAccess da = new DataAccess()) { SQL = COMPLIANCE_SQL.GET_ALL_NEW_ACTION_ITEMS(); dt = da.GetDataSet(SQL, Parms).Tables[0]; RadGridActionItem.DataSource = dt; } } catch (Exception ex) { throw ex; }}protected void BatchNameSelected(object sender, DropDownListEventArgs e) { List<IDataParameter> Parms = null; string SQL = string.Empty; DataTable dt; try { // Query for batch names and bind data to Batch RadDropDownList. using (DataAccess da = new DataAccess()) { SQL = COMPLIANCE_SQL.GET_ACTION_ITEM_VIA_BATCH_NAME(ref Parms, e.Text); dt = da.GetDataSet(SQL, Parms).Tables[0]; RadGridActionItem.DataSource = dt; RadGridActionItem.Rebind(); } } catch (Exception ex) { throw ex; } }protected void RadGridActionItem_PageIndexChanged(object sender, GridPageChangedEventArgs e){ // Allows for RadGrid paging property. RadGridActionItem.CurrentPageIndex = e.NewPageIndex;}protected void Page_Load(object sender, EventArgs e){ FillBatchDropDown();}