or


<telerik:GridTemplateColumn HeaderText="Need Call" ItemStyle-HorizontalAlign="Center" > <ItemTemplate> <telerik:RadToolTip ID="RadToolTipCall" runat="server" TargetControlID="chkNeedCall" AutoCloseDelay="10000" RelativeTo="Element" Position="MiddleRight"> <%# Eval("UsernameNeedCall") %> </telerik:RadToolTip> <telerik:RadButton ID="chkNeedCall" runat="server" Width="22px" Height="22px" ToggleType="CheckBox" ButtonType="LinkButton" CommandArgument='<%# Eval("Id") %>' AutoPostBack="True" OnCommand="btnNeedCall_Click"> <Image EnableImageButton="True" ImageUrl='<%# Eval("NeedCall") %>' IsBackgroundImage="True"></Image> </telerik:RadButton> </ItemTemplate></telerik:GridTemplateColumn>protected void gridShow_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e){ try { if (!e.IsFromDetailTable) { var db = new MyDataContext(); var reciveMsg = db.TBL_ReceiverMsgs.ToList().Select((c, index) => new { RowIndex = index + 1, c.Id, c.Body, NeedCall = c.NeedCall ? "../Images/Sms/deliveryorange.png" : "../Images/Sms/deliveryok.png", NeedFollow = c.NeedFollow ? "../Images/Sms/deliveryorange.png" : "../Images/Sms/deliveryok.png", c.UsernameNeedCall }); gridShowSms.DataSource = reciveMsg; } } catch (Exception) { lblException.Text = @"Error!!"; }}<telerik:GridTemplateColumn HeaderText="Body" ItemStyle-HorizontalAlign="Center" > <ItemTemplate> <telerik:RadToolTip ID="RadToolTipBody" runat="server" TargetControlID="lblBody" RelativeTo="Element" Position="Center" > <%# DataBinder.Eval(Container, "DataItem.Body") %> </telerik:RadToolTip> <div style="Width:100px" ID="lblBody" runat="server"><%# Eval("Body") %></div> </ItemTemplate></telerik:GridTemplateColumn><telerik:RadHtmlChart ID="RadHtmlChart2" runat="server" DataSourceID="SqlDataSource1" Height="400px" Width="1200px" InvokeLoadData="OnPageLoad"> <PlotArea> <Series> <telerik:LineSeries DataFieldY="47" Name="Lync"></telerik:LineSeries> <telerik:LineSeries DataFieldY="48" Name="Outlook"></telerik:LineSeries> <telerik:LineSeries DataFieldY="49" Name="IE"></telerik:LineSeries> </Series> <XAxis DataLabelsField="YDate" Name="ExecutionDate" Visible="true"></XAxis> <YAxis Name="ExecutionCount" MaxValue="1000" MinValue="0" Step="100"></YAxis> </PlotArea> </telerik:RadHtmlChart><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SmartButton3ConnectionString %>" SelectCommand="SELECT * FROM (SELECT CoreTriggerPluginID, CONVERT(VARCHAR(10),CreatedDateTime,101) as YDateFROM [SmartButton3].[Universal].[TblCoreTriggerPluginUsage] where CoreTriggerPluginID IN (47,48,49)) XPIVOT(COUNT(X.CoreTriggerPluginID) FOR X.CoreTriggerPluginID IN ([47], [48], [49])) AS PVTTable ORDER BY PVTTable.YDate"></asp:SqlDataSource>