or

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" GridLines="None"> <MasterTableView Dir="RTL" > </MasterTableView> <ClientSettings> <Scrolling AllowScroll="true" UseStaticHeaders="true" /> </ClientSettings> </telerik:RadGrid>If Not Page.IsPostBack Then Dim dt As DataTable dt = OpenDT("SELECT * FROM my_table ") Dim column1 As New GridBoundColumn Dim j As Integer For j = 0 To 10 'dt.Columns.Count - 1 column1 = New GridBoundColumn RadGrid1.MasterTableView.Columns.Add(column1) column1.DataField = "DataEntryDate" column1.HeaderText = "Column " & j column1.ItemStyle.Width = "1000" Next j RadGrid1.DataSource = dt RadGrid1.DataBind()End If<telerik:RadChart ID="rcTotalCaseTypes" AutoLayout="true" runat="Server" Width="900px" Skin="Telerik" Style="margin: 0px auto;" IntelligentLabelsEnabled="True"> <Legend Visible="true"> <Appearance GroupNameFormat="#VALUE"> </Appearance> </Legend> <ChartTitle TextBlock-Text="Total Cases by Category"> <TextBlock> <Appearance TextProperties-Font="Verdana, 20px, style=Bold" TextProperties-Color="#00529B"> </Appearance> </TextBlock> </ChartTitle> <PlotArea> <Appearance Dimensions-Margins="18%, 22%, 12%, 14%"> </Appearance> <XAxis DataLabelsColumn="PrettyMonthYr"> <Appearance> <TextAppearance TextProperties-Font="Verdana, 8pt, style=Bold"> </TextAppearance> </Appearance> </XAxis> <YAxis LabelStep="5" ScaleBreaks-Enabled="true" AutoScale="False"> <Appearance ValueFormat="None"> <TextAppearance TextProperties-Font="Verdana, 8pt, style=Bold"> </TextAppearance> <MajorGridLines Width="3" PenStyle="Dash" /> <MinorGridLines Visible="false" /> </Appearance> </YAxis> </PlotArea> </telerik:RadChart>var data = SPs.RptNumberOfCasesByType(locationID).ExecuteTypedList<InvoiceCategoryNumbers>();ChartMonths = new List<DateTime>();var primaryKnee = new ChartSeries{ Name = "PK Cases", Type = ChartSeriesType.Bar, YAxisType = ChartYAxisType.Primary};var revisionKnee = new ChartSeries{ Name = "RK Cases", Type = ChartSeriesType.Bar, YAxisType = ChartYAxisType.Primary};var hipCases = new ChartSeries{ Name = "Hip Cases", Type = ChartSeriesType.Bar, YAxisType = ChartYAxisType.Primary};var rxCases = new ChartSeries{ Name = "Rx Cases", Type = ChartSeriesType.Bar, YAxisType = ChartYAxisType.Primary};var otherCases = new ChartSeries{ Name = "Other Cases", Type = ChartSeriesType.Bar, YAxisType = ChartYAxisType.Primary};data.ForEach(c => { ChartMonths.Add(Convert.ToDateTime(c.YearMo + "-01")); var barTooltip = string.Format("<b>{0}</b><br /># of Cases: {1}<br />Total Sales: {2:C}", c.Category, c.NumInvoices, c.TotalSold); var barSeriesItem = new ChartSeriesItem(Convert.ToDouble(c.NumInvoices), c.Category) { Name = c.Category }; barSeriesItem.Label.Visible = false; barSeriesItem.Label.ActiveRegion.Tooltip = barTooltip; barSeriesItem.ActiveRegion.Tooltip = barTooltip; switch (c.InvoiceCategoryID) { case -1: otherCases.AddItem(barSeriesItem); break; case 1: primaryKnee.AddItem(barSeriesItem); break; case 2: revisionKnee.AddItem(barSeriesItem); break; case 3: hipCases.AddItem(barSeriesItem); break; case 11: rxCases.AddItem(barSeriesItem); break; } });rcTotalCaseTypes.Series.Add(primaryKnee);rcTotalCaseTypes.Series.Add(revisionKnee);rcTotalCaseTypes.Series.Add(hipCases);rcTotalCaseTypes.Series.Add(rxCases);rcTotalCaseTypes.Series.Add(otherCases);rcTotalCaseTypes.DataBind();rcTotalCaseTypes.PlotArea.XAxis.Clear();if (ChartMonths.Count > 0){ var uniqueMonths = new HashSet<DateTime>(ChartMonths); uniqueMonths.ToList().ForEach(m => rcTotalCaseTypes.PlotArea.XAxis.AddItem(m.ToString("MM/yyyy")));}rcTotalCaseTypes.PlotArea.YAxis.ScaleBreaks.Segments.Add(new AxisSegment() { MinValue = 0, MaxValue = 150, Step = 10 });rcTotalCaseTypes.PlotArea.YAxis.ScaleBreaks.Segments.Add(new AxisSegment() { MinValue = 151, MaxValue = 500, Step = 10 });