or
<telerik:RadGrid ID="grdWebForm" CssClass="infoDisplayGrid" runat="server" Skin="Office2007" AllowPaging="true" OnPageIndexChanged="grdWebForm_PageIndexChanged" OnPageSizeChanged="grdWebForm_OnPageSizeChanged" PageSize="25" AllowSorting="true" OnSortCommand="grdWebForm_SortCommand" OnNeedDataSource="grdWebForm_NeedDataSource" OnItemDataBound="grdWebForm_ItemDataBound" AutoGenerateColumns="false" OnUpdateCommand="grdWebForm_UpdateCommand" OnDeleteCommand="grdWebForm_DeleteCommand" OnInsertCommand="grdWeForm_InsertCommand" OnPreRender="grdWebForm_PreRender"> <PagerStyle AlwaysVisible="true" /> <MasterTableView DataKeyNames="RTFieldQCId" EditMode="InPlace" CommandItemDisplay="Top"> <Columns> <telerik:GridDropDownColumn UniqueName="FullName" HeaderText="Tech Name" DataField="TechId" ListValueField="TechId" ListTextField="FullName" DropDownControlType="DropDownList"></telerik:GridDropDownColumn> <telerik:GridBoundColumn UniqueName="LegacyMeterSerial" SortExpression="LegacyMeterSerial" HeaderText="Legacy Meter #" DataField="LegacyMeterSerial"></telerik:GridBoundColumn> <telerik:GridDateTimeColumn UniqueName="QCDate" PickerType="DatePicker" HeaderText="Date" DataField="QCDate" DataFormatString="{0:MM/dd/yyyy}" EditDataFormatString="MMMM dd"> <ItemStyle Width="120px" /> </telerik:GridDateTimeColumn> <telerik:GridNumericColumn UniqueName="Score" SortExpression="Score" HeaderText="Score" DataField="Score" ColumnEditorID="GridNumericColumnEditor1"></telerik:GridNumericColumn> <telerik:GridNumericColumn UniqueName="MaxScore" SortExpression="MaxScore" HeaderText="Max Score" DataField="MaxScore" ColumnEditorID="GridNumericColumnEditor1"></telerik:GridNumericColumn> <telerik:GridBoundColumn UniqueName="Action" SortExpression="Action" HeaderText="Action" DataField="Action"> </telerik:GridBoundColumn> <telerik:GridEditCommandColumn UpdateText="Update" UniqueName="EditCommandColumn" CancelText="Cancel" EditText="Edit"> <HeaderStyle Width="85px"></HeaderStyle> </telerik:GridEditCommandColumn> <telerik:GridButtonColumn UniqueName="DeleteColumn" Text="Delete" CommandName="Delete" /> </Columns> </MasterTableView> </telerik:RadGrid> <telerik:GridNumericColumnEditor ID="GridNumericColumnEditor1" runat="server"> <NumericTextBox MaxLength="4" EmptyMessage="Ext." runat="server"> <NumberFormat GroupSeparator="," /> </NumericTextBox> </telerik:GridNumericColumnEditor>protected void grdWebForm_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { //if (rt_table != string.Empty) //{ grdWebForm.DataSource = GetWebFormData(); //} } protected void grdWebForm_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridEditableItem && e.Item.IsInEditMode) { GridEditableItem editedItem = e.Item as GridEditableItem; GridEditManager editMan = editedItem.EditManager; GridDropDownColumnEditor editor = editMan.GetColumnEditor("FullName") as GridDropDownColumnEditor; List<TechInfo> techList = BuildTechSelectLists(false); editor.DataSource = techList; // BuildTechSelectLists(false); editor.DataTextField = "FullName"; editor.DataValueField = "UserId"; editor.DataBind(); } if (e.Item is GridDataItem) { GridDataItem item = (GridDataItem)e.Item; DataRowView row = (DataRowView)e.Item.DataItem; item["FullName"].Text = row["FullName"].ToString(); } } public DataTable GetWebFormData() { SqlConnection connection = new SqlConnection( ConfigurationManager.ConnectionStrings["ProFieldMeter"].ConnectionString); DataTable dt = new DataTable(); string strquery = "Select qc.RTFieldQCID,qc.TechId,qc.LegacyMeterSerial,qc.QCDate,qc.Score,qc.MaxScore,qc.Attachment,qc.Action, u.Lastname + ', ' + u.FirstName as FullName FROM RTFieldQC qc left join ProFieldCore.dbo.ProfieldUser u on qc.TechId = u.UserId"; SqlDataAdapter adapter = new SqlDataAdapter(strquery, connection); adapter.Fill(dt); return dt; }<EditFormSettings ColumnNumber="2" CaptionDataField="Plaintiffs" CaptionFormatString="Edit Single Record {0}" InsertCaption="New Product"> <FormTableItemStyle Wrap="False"></FormTableItemStyle> <FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle> <FormMainTableStyle GridLines="None" CellSpacing="0" CellPadding="3" BackColor="White" Width="100%" /> <FormTableStyle CellSpacing="0" CellPadding="2" Height="110px" BackColor="White" /> <FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle> <EditColumn ButtonType="PushButton" UpdateText="Update record" UniqueName="EditCommandColumn1" CancelText="Cancel edit"> </EditColumn> <FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle> </EditFormSettings> 
<telerik:RadChart ID="RadChart3" runat="server" DefaultType="StackedBar100" SeriesOrientation="Horizontal" ChartImageFormat="Jpeg" DataSourceID="AccessDataSource4" Skin="BabyBlue" Width="500px"> <Appearance> <FillStyle MainColor="239, 255, 254"> </FillStyle> <Border Color="188, 229, 231" Width="8" /> </Appearance> <Series><telerik:ChartSeries Name="" Type="StackedBar100" DataLabelsColumn="contactdate By Month" DataYColumn="Expr1" DataYColumn2="Sum Of contactdates_custno" DataYColumn3="CountOfcustsales"> <Appearance> <FillStyle FillType="Solid" MainColor="194, 230, 252"> </FillStyle> <TextAppearance TextProperties-Color="78, 168, 188"> </TextAppearance> <Border Color="177, 215, 250" /> </Appearance> </telerik:ChartSeries></Series> <Legend> <Appearance Corners="Round, Round, Round, Round, 6" Dimensions-Margins="20%, 3%, 1px, 1px"> <ItemTextAppearance TextProperties-Color="120, 162, 19"> </ItemTextAppearance> <Border Color="194, 212, 109" /> </Appearance> </Legend> <PlotArea> <XAxis> <Appearance Color="226, 218, 202" MajorTick-Color="216, 184, 86" ValueFormat="Percent"> <MajorGridLines Color="244, 227, 195" Width="0" /> <TextAppearance TextProperties-Color="78, 168, 188"> </TextAppearance> </Appearance> <AxisLabel> <Appearance RotationAngle="270"> </Appearance> <TextBlock> <Appearance TextProperties-Color="78, 168, 188"> </Appearance> </TextBlock> </AxisLabel> </XAxis> <YAxis> <Appearance Color="226, 218, 202" MajorTick-Color="216, 184, 86" MinorTick-Color="216, 184, 86"> <MajorGridLines Color="244, 227, 195" /> <MinorGridLines Color="244, 227, 195" /> <TextAppearance TextProperties-Color="78, 168, 188"> </TextAppearance> </Appearance> <AxisLabel> <Appearance RotationAngle="0"> </Appearance> <TextBlock> <Appearance TextProperties-Color="78, 168, 188"> </Appearance> </TextBlock> </AxisLabel> </YAxis> <YAxis2> <AxisLabel> <Appearance RotationAngle="0"> </Appearance> </AxisLabel> </YAxis2> <Appearance Dimensions-Margins="20%, 24%, 12%, 10%"> <FillStyle MainColor="255, 249, 239" SecondColor="Transparent"> </FillStyle> <Border Color="226, 201, 156" /> </Appearance> </PlotArea> <ChartTitle> <Appearance Dimensions-Margins="4%, 10px, 10px, 7%"> <FillStyle MainColor=""> </FillStyle> </Appearance> <TextBlock Text="Customers Interested"> <Appearance TextProperties-Color="232, 140, 0" TextProperties-Font="Verdana, 20pt, style=Bold"> </Appearance> </TextBlock> </ChartTitle> </telerik:RadChart><telerik:GridCheckBoxColumn DataField="Requirement_Received" DataType="System.Boolean" HeaderText="Requirement Received?" SortExpression="Requirement_Received" UniqueName="Requirement_Received"> <HeaderStyle Width="125px" /> </telerik:GridCheckBoxColumn><telerik:RadAjaxLoadingPanel ID="usersGroupsLoadingPanel" runat="server" Skin="Vista" /> <telerik:RadAjaxPanel ID="usersGroupsPanel" runat="server" LoadingPanelID="usersGroupsLoadingPanel"> <telerik:RadTabStrip ID="RadTabStrip1" runat="server" Skin="Vista" MultiPageID="RadMultiPage1" SelectedIndex="0"> <Tabs> <telerik:RadTab Text="Users"> </telerik:RadTab> <telerik:RadTab Text="Groups"> </telerik:RadTab> </Tabs> </telerik:RadTabStrip> <telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0"> <telerik:RadPageView ID="RadPageView1" runat="server"> <telerik:RadGrid ID="usersRadGrid" runat="server" AutoGenerateColumns="false" AllowPaging="true" OnItemCommand="usersRadGrid_ItemCommand" OnItemDataBound="usersRadGrid_ItemDataBound"> <MasterTableView runat="server" CommandItemDisplay="Top" NoMasterRecordsText="No user records found. Please try another search." EditMode="PopUp"> <Columns> <telerik:GridEditCommandColumn /> <telerik:GridBoundColumn DataField="FirstName" AllowFiltering="true" HeaderText="First Name" /> <telerik:GridBoundColumn DataField="LastName" AllowFiltering="true" HeaderText="Last Name" /> <telerik:GridBoundColumn DataField="EmployeeID" AllowFiltering="true" HeaderText="Employee ID" /> <telerik:GridBoundColumn DataField="ID" AllowFiltering="true" HeaderText="ID" Visible="false" /> </Columns> <CommandItemSettings AddNewRecordText="Add New User" ShowAddNewRecordButton="true" /> <CommandItemTemplate> <telerik:RadTextBox ID="userSearchFirstName" runat="server" EmptyMessage="Search First Name" CssClass="padding" /> <telerik:RadTextBox ID="userSearchLastName" runat="server" EmptyMessage="Search Last Name" CssClass="padding" /> <telerik:RadTextBox ID="userSearchID" runat="server" EmptyMessage="Search Employee ID" CssClass="padding" /> <telerik:RadButton ID="userSearchBtn" runat="server" Text="Search" CssClass="padding" OnClick="userSearchBtn_Click" /> <asp:Label ID="userSearchNotify" runat="server" Text="* At Least One Field Must Be Filled Out" CssClass="error" Visible="false" /> <div style="float:right;padding-right:20px;margin:5px 5px 5px 0px;"> <input class="rgAdd" style="margin-right:0px;" /> <asp:LinkButton ID="userAddRecord" runat="server" CommandName="InitInsert">Add New User</asp:LinkButton> </div> </CommandItemTemplate> <EditFormSettings PopUpSettings-Modal="true" EditFormType="Template" PopUpSettings-Width="500px"> <FormTemplate> <table width="500px" border="0"> <tr> <td>First Name: </td> <td><telerik:RadTextBox ID="editUserFirstName" runat="server" /></td> <td>Last Name: </td> <td><telerik:RadTextBox ID="editUserLastName" runat="server" /></td> </tr> <tr> <td>Employee ID: </td> <td> <telerik:RadTextBox ID="editUserID" runat="server" /> <asp:Label ID="userID" runat="server" Text='<%#Bind("ID") %>' Visible="false" /> </td> <td>Department: </td> <td><telerik:RadTextBox ID="editUserDepartment" runat="server" EmptyMessage="No Department Set" /></td> </tr> <tr> <td>Email: </td> <td><telerik:RadTextBox ID="editUserEmail" runat="server" EmptyMessage="No Email Set" /></td> <td>Last Updated: </td> <td><telerik:RadTextBox ID="editUserLastUpdate" runat="server" ReadOnly="true" /></td> </tr> <tr> <td>Active: </td> <td> <telerik:RadComboBox ID="editUserActive" runat="server" Width="60px"> <Items> <telerik:RadComboBoxItem Value="1" Text="Yes" /> <telerik:RadComboBoxItem Value="0" Text="No" /> </Items> </telerik:RadComboBox> </td> <td>Vendor User: </td> <td> <telerik:RadComboBox ID="editUserVendor" runat="server" Width="60px"> <Items> <telerik:RadComboBoxItem Value="1" Text="Yes" /> <telerik:RadComboBoxItem Value="0" Text="No" /> </Items> </telerik:RadComboBox> </td> </tr> <tr> <td>User Name: </td> <td><telerik:RadTextBox ID="editUserUsername" runat="server" /></td> <td>Password: </td> <td><telerik:RadTextBox ID="editUserPassword" runat="server" EmptyMessage="No Password Set" /></td> </tr> <tr> <td>PIN: </td> <td colspan="3"><telerik:RadTextBox ID="editUserPIN" runat="server" /><asp:Label ID="PINvalue" runat="server" Visible="false" /></td> </tr> <tr> <td>User Groups: </td> <td><telerik:RadListBox ID="editUserCurrentGroups" runat="server" AllowTransfer="true" TransferToID="editUserAvailGroups" EnableDragAndDrop="true" SelectionMode="Multiple" EmptyMessage="User Doesn't Belong To Any Groups" width="190px" Height="200px"/></td> <td colspan="2"><telerik:RadListBox ID="editUserAvailGroups" runat="server" EnableDragAndDrop="true" SelectionMode="Multiple" EmptyMessage="No Groups Available" width="175px" Height="200px" /></td> </tr> <tr> <td colspan="1"><telerik:RadButton ID="editUserUpdateBtn" runat="server" Text="Save" CommandName="Update" /></td> <td colspan="1"><telerik:RadButton ID="editUserClearBtn" runat="server" Text="Clear Badge" OnClick="editUserClearBtn_Click" /></td> <td colspan="2"><asp:Label ID="editUserNotify" runat="server" Text="" CssClass="error" Visible="false" /></td> </tr> </table> </FormTemplate> </EditFormSettings> </MasterTableView> </telerik:RadGrid> </telerik:RadPageView> <telerik:RadPageView ID="RadPageView2" runat="server"> <telerik:RadGrid ID="groupsRadGrid" runat="server" AutoGenerateColumns="false" DataSourceID="groupsRadGridDataSource" AllowAutomaticUpdates="true"> <MasterTableView runat="server" CommandItemDisplay="Top" NoMasterRecordsText="No Groups Found" EditMode="InPlace" DataKeyNames="ID"> <Columns> <telerik:GridEditCommandColumn HeaderStyle-Width="60px" /> <telerik:GridBoundColumn DataField="Name" AllowFiltering="true" HeaderText="Group Name" /> </Columns> <CommandItemSettings AddNewRecordText="Add New Group" ShowRefreshButton="false" ShowAddNewRecordButton="false" /> </MasterTableView> </telerik:RadGrid> <asp:SqlDataSource ID="groupsRadGridDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:AssetWhereConnectionString %>" SelectCommand="SELECT ID, Name FROM dbo.UserGroup" SelectCommandType="Text" UpdateCommand="UPDATE dbo.UserGroup SET Name=@Name WHERE ID=@ID"> <UpdateParameters> <asp:Parameter Name="ID" /> <asp:Parameter Name="Name" /> </UpdateParameters> </asp:SqlDataSource> </telerik:RadPageView> </telerik:RadMultiPage> </telerik:RadAjaxPanel>