or
| <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml" > |
| <head id="Head1" runat="server"> |
| <title>ASP.NET Example</title> |
| </head> |
| <body> |
| <form id="form1" runat="server"> |
| <telerik:RadScriptManager runat="server"/> |
| <asp:DropDownList |
| id="DropDownList1" |
| runat="server" |
| AutoPostBack="True"> |
| <asp:ListItem Selected="True">Roland</asp:ListItem> |
| <asp:ListItem>Patrik</asp:ListItem> |
| <asp:ListItem>Petter</asp:ListItem> |
| </asp:DropDownList> |
| <asp:SqlDataSource |
| id="SqlDataSource1" |
| runat="server" |
| ConnectionString="???????" |
| SelectCommand="SELECT * FROM Sys_Users"> |
| <%-- FilterExpression="Login_Name='Patrik'"> |
| <FilterParameters> |
| <asp:ControlParameter Name="Title" ControlId="DropDownList1" PropertyName="SelectedValue"/> |
| </FilterParameters> |
| --%> </asp:SqlDataSource> |
| <p><telerik:RadGrid |
| id="GridView1" |
| runat="server" |
| DataSourceID="SqlDataSource1" |
| AutoGenerateColumns="False"> |
| <MasterTableView FilterExpression="([Login_Name]='Patrik')"> |
| <Columns> |
| <telerik:GridBoundColumn Visible="False" DataField="RecID" /> |
| <telerik:GridBoundColumn HeaderText="First Name" DataField="F_Name" /> |
| <telerik:GridBoundColumn HeaderText="Last Name" DataField="L_Name" /> |
| <telerik:GridBoundColumn HeaderText="Login" DataField="Login_Name" /> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |
| </form> |
| </body> |
| </html> |
The problem is a fairly straight foward one, or so I thought. On the ItemDatabound event, I need to check the value of a certain column of the DataItem. If the data starts with "PTC" then I need to change the data for that column to read "New Order" instead. I thought I had it figured out, but it didn't work. I am assuming it's a simple fix, if someone can take a quick look at it. Here's the codebehind;
| Private Sub rgPoOrders_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles rgPoOrders.ItemDataBound |
| Dim TrackURL As String |
| Dim Track As New PackageTrack |
| If TypeOf e.Item Is GridDataItem Then |
| Dim item As GridDataItem = DirectCast(e.Item, GridDataItem) |
| Dim TrackNum As String = String.Empty |
| Dim SubmittedBy As String = String.Empty |
| 'assign tracking number to variable |
| If item.OwnerTableView Is rgPoOrders.MasterTableView Then |
| TrackNum = item("cshortrmk").Text |
| SubmittedBy = item("SubmittedBy").Text |
| End If |
| 'Get URL for tracking number |
| TrackURL = Track.Track(TrackNum) |
| 'Set Hyperlink variable/control, and URL to hyperlink control |
| 'NOTE: UPS has to open separate browser window. |
| Dim TrackButton As HyperLink = DirectCast(item("hlTrackButton").Controls(0), HyperLink) |
| TrackButton.NavigateUrl = TrackURL |
| TrackButton.Target = "_blank" |
| 'Get Submitted by column, substitute .txt files for data |
| If SubmittedBy.StartsWith("PTC") = True Then |
| SubmittedBy = "New Order" |
| End If |
| End If |
| End Sub |
| <telerik:RadGrid ID="rgPoOrders" runat="server" DataSourceID="dsPurchaseOrders" |
| GridLines="None" AllowFilteringByColumn="True" AllowPaging="True" |
| AllowSorting="True" PageSize="25"> |
| <MasterTableView ItemStyle-HorizontalAlign="Center" AutoGenerateColumns="False" |
| Width="95%" DataKeyNames="cpono" DataSourceID="dsPurchaseOrders" |
| GridLines="Horizontal" AlternatingItemStyle-HorizontalAlign="Center" |
| HeaderStyle-HorizontalAlign="Center" PagerStyle-PageButtonCount="15"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px" /> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridBoundColumn DataField="cpono" HeaderText="PO #" ReadOnly="True" |
| SortExpression="cpono" UniqueName="cpono"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="cconfirmto" HeaderText="Submitted By" |
| ReadOnly="true" UniqueName="SubmittedBy" > |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DateOnly" DataType="System.DateTime" |
| HeaderText="Date Submitted" SortExpression="DateOnly" UniqueName="DateOnly"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="cshortrmk" HeaderText="Tracking #" |
| UniqueName="cshortrmk"> |
| </telerik:GridBoundColumn> |
| <telerik:GridHyperLinkColumn Text="Click Here To Track" HeaderText="" |
| UniqueName="hlTrackButton"> |
| </telerik:GridHyperLinkColumn> |
| </Columns> |
| <ItemStyle HorizontalAlign="Center" /> |
| <AlternatingItemStyle HorizontalAlign="Center" /> |
| <HeaderStyle HorizontalAlign="Center" /> |
| </MasterTableView> |
| </telerik:RadGrid> |
| <form id="form1" runat="server"> |
| <telerik:RadScriptManager ID="ScriptManager" runat="server" /> |
| <telerik:RadProgressManager ID="Radprogressmanager1" runat="server" /> |
| <telerik:RadUpload ID="RadUpload1" runat="server" onclientadded="increaseFileInputWidth" EnableEmbeddedSkins="false" EnableFileInputSkinning="true" Localization-Clear="" ControlObjectsVisibility="ClearButtons" /> |
| <asp:ImageButton ID="btnUpload" runat="server" ImageUrl="Images/Buttons/106x26UploadPDF.png" /> |
| </form> |