/// <summary> /// Binds the grid. /// </summary> private void BindGrid() { pnlUpdateMessage.Visible = false; pnlResults.Visible = true; int?accountId = apAccount.SelectedValue.AsIntegerOrNull(); if (!accountId.HasValue) { return; } var dateRange = SlidingDateRangePicker.CalculateDateRangeFromDelimitedValues(drpSlidingDateRange.DelimitedValues); DateTime?start = dateRange.Start ?? (DateTime?)System.Data.SqlTypes.SqlDateTime.MinValue; DateTime?end = dateRange.End ?? ( DateTime? )System.Data.SqlTypes.SqlDateTime.MaxValue; var minPledgeAmount = nrePledgeAmount.LowerValue; var maxPledgeAmount = nrePledgeAmount.UpperValue; var minComplete = nrePercentComplete.LowerValue; var maxComplete = nrePercentComplete.UpperValue; var minGiftAmount = nreAmountGiven.LowerValue; var maxGiftAmount = nreAmountGiven.UpperValue; int includeOption = rblInclude.SelectedValueAsInt() ?? 0; bool includePledges = includeOption != 1; bool includeGifts = includeOption != 0; DataSet ds = FinancialPledgeService.GetPledgeAnalytics(accountId.Value, start, end, minPledgeAmount, maxPledgeAmount, minComplete, maxComplete, minGiftAmount, maxGiftAmount, includePledges, includeGifts); System.Data.DataView dv = ds.Tables[0].DefaultView; if (gList.SortProperty != null) { try { var sortProperties = new List <string>(); foreach (string prop in gList.SortProperty.Property.SplitDelimitedValues(false)) { sortProperties.Add(string.Format("[{0}] {1}", prop, gList.SortProperty.DirectionString)); } dv.Sort = sortProperties.AsDelimited(", "); } catch { dv.Sort = "[LastName] ASC, [NickName] ASC"; } } else { dv.Sort = "[LastName] ASC, [NickName] ASC"; } gList.DataSource = dv; gList.DataBind(); }