or
<telerik:RadScriptManager runat="server" ID="RadScriptManager1" /><br> <telerik:RadListBox runat="server" ID="SavedChangesList" Width="600px" Height="200px" Visible="false"></telerik:RadListBox><br> <telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" AllowAutomaticDeletes="True"<br> AllowAutomaticInserts="True" PageSize="10" Skin="Default" OnItemDeleted="RadGrid1_ItemDeleted" OnItemInserted="RadGrid1_ItemInserted"<br> OnItemUpdated="RadGrid1_ItemUpdated" OnPreRender="RadGrid1_PreRender" AllowAutomaticUpdates="True" AllowPaging="True"<br> AutoGenerateColumns="False" Width="1000px" OnBatchEditCommand="RadGrid1_BatchEditCommand" DataSourceID="sqlContractMatrix"><br> <MasterTableView CommandItemDisplay="TopAndBottom" DataKeyNames="ID" DataSourceID="sqlContractMatrix" HorizontalAlign="NotSet" EditMode="Batch" AutoGenerateColumns="False"><br> <BatchEditingSettings EditType="Cell" /><br> <SortExpressions><br> <telerik:GridSortExpression FieldName="SiteID,ProductID" SortOrder="Descending" /><br> </SortExpressions><br> <Columns><br> <telerik:GridTemplateColumn HeaderText="Site" HeaderStyle-Width="150px" UniqueName="SiteID" DataField="SiteID"><br> <ItemTemplate><br> <%# Eval("SiteName") %><br> </ItemTemplate><br> <EditItemTemplate><br> <telerik:RadDropDownList runat="server" ID="ddlSites" AppendDataBoundItems="true" DataValueField="SiteID" DataTextField="SiteName" DataSourceID="sqlSites"><br> <br> </telerik:RadDropDownList><br> </EditItemTemplate><br> </telerik:GridTemplateColumn><br> <br> <telerik:GridTemplateColumn HeaderText="Product" HeaderStyle-Width="150px" UniqueName="ProductID" DataField="ProductID"><br> <ItemTemplate><br> <%# Eval("ProductName") %><br> </ItemTemplate><br> <EditItemTemplate><br> <telerik:RadDropDownList runat="server" ID="ddlProducts" DropDownWidth="250" DropDownHeight="400" DefaultMessage="Product" AppendDataBoundItems="true" DataValueField="ProductID" DataTextField="ProductName" DataSourceID="sqlProducts"><br> <br> </telerik:RadDropDownList><br> </EditItemTemplate><br> </telerik:GridTemplateColumn><br> <br> <telerik:GridAttachmentColumn DataSourceID="sqlContractMatrix" MaxFileSize="1048576" HeaderStyle-Width="250px"<br> EditFormHeaderTextFormat="Upload File:" HeaderText="HTML Template" AttachmentDataField="BinaryData"<br> AttachmentKeyFields="ID" FileNameTextField="TemplateFileBinary" DataTextField="TemplateFileBinary"<br> UniqueName="TemplateFileBinary"><br> </telerik:GridAttachmentColumn><br> <br> <%--<br> <telerik:GridBoundColumn DataField="TemplateFile" HeaderStyle-Width="200px" HeaderText="Template"<br> SortExpression="TemplateFile" UniqueName="TemplateFile"><br> </telerik:GridBoundColumn><br> --%><br> <br> <telerik:GridBoundColumn DataField="PDFName" HeaderStyle-Width="200px" HeaderText="PDF Name"<br> SortExpression="PDFName" UniqueName="PDFName"><br> </telerik:GridBoundColumn><br> <telerik:GridButtonColumn ConfirmText="Delete this record?" ConfirmDialogType="RadWindow"<br> ConfirmTitle="Delete" HeaderText="Delete" HeaderStyle-Width="50px" ButtonType="ImageButton"<br> CommandName="Delete" Text="Delete" UniqueName="DeleteColumn"><br> </telerik:GridButtonColumn><br> </Columns><br> </MasterTableView><br> </telerik:RadGrid><br> <asp:SqlDataSource ID="sqlContractMatrix" runat="server" ConnectionString="<%$ ConnectionStrings:FitTrack %>"<br> DeleteCommand="DELETE FROM ContractMatrix WHERE ID = @ID" <br> InsertCommand="INSERT INTO ContractMatrix (SiteID, ProductID, TemplateFile, PDFName, LastModifiedDate, LastModifiedByID) VALUES (@SiteID, @ProductID, @TemplateFile, @PDFName, @LastModifiedDate, @LastModifiedByID)"<br> UpdateCommand="UPDATE ContractMatrix SET SiteID = @SiteID, ProductID = @ProductID, TemplateFile = @TemplateFile, PDFName = @PDFName, LastModifiedDate = GETDATE(), LastModifiedByID = @LastModifiedByID WHERE ID = @ID"><br> <DeleteParameters><br> <asp:Parameter Name="ID" Type="Int32"></asp:Parameter><br> </DeleteParameters><br> <InsertParameters><br> <asp:Parameter Name="SiteID" Type="Int32"></asp:Parameter><br> <asp:Parameter Name="ProductID" Type="Int32"></asp:Parameter><br> <asp:Parameter Name="TemplateFile" Type="String"></asp:Parameter><br> <asp:Parameter Name="PDFName" Type="String"></asp:Parameter><br> </InsertParameters><br> <UpdateParameters><br> <asp:Parameter Name="SiteID" Type="Int32"></asp:Parameter><br> <asp:Parameter Name="ProductID" Type="Int32"></asp:Parameter><br> <asp:Parameter Name="TemplateFile" Type="String"></asp:Parameter><br> <asp:Parameter Name="PDFName" Type="String"></asp:Parameter><br> <asp:Parameter Name="ID" Type="Int32"></asp:Parameter><br> </UpdateParameters><br> </asp:SqlDataSource><br> <br> <!-- SQL data sources for various lookup tables --><br> <asp:SqlDataSource ID="sqlSites" runat="server" ConnectionString="<%$ ConnectionStrings:FitTrack %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT SiteID, SiteName FROM gym.Site ORDER BY SiteID"></asp:SqlDataSource><br> <asp:SqlDataSource ID="sqlProducts" runat="server" ConnectionString="<%$ ConnectionStrings:FitTrack %>" ProviderName="System.Data.SqlClient"></asp:SqlDataSource>protected void RadGrid1_BatchEditCommand(object sender, Telerik.Web.UI.GridBatchEditingEventArgs e)<br> {<br> SavedChangesList.Visible = true;<br> }<br> <br> protected void RadGrid1_ItemUpdated(object source, Telerik.Web.UI.GridUpdatedEventArgs e)<br> {<br> GridEditableItem item = (GridEditableItem)e.Item;<br> string id = item.GetDataKeyValue("ID").ToString();<br> if (e.Exception != null)<br> {<br> e.KeepInEditMode = true;<br> e.ExceptionHandled = true;<br> NotifyUser("Record with ID " + id + " cannot be updated. Reason: " + e.Exception.Message);<br> }<br> else<br> {<br> NotifyUser("Record with ID " + id + " is updated!");<br> }<br> }<br> <br> protected void RadGrid1_ItemInserted(object source, GridInsertedEventArgs e)<br> {<br> if (e.Exception != null)<br> {<br> e.ExceptionHandled = true;<br> NotifyUser("Product cannot be inserted. Reason: " + e.Exception.Message);<br> }<br> else<br> {<br> NotifyUser("New product is inserted!");<br> }<br> }<br> <br> protected void RadGrid1_ItemDeleted(object source, GridDeletedEventArgs e)<br> {<br> GridDataItem dataItem = (GridDataItem)e.Item;<br> string id = dataItem.GetDataKeyValue("ID").ToString();<br> if (e.Exception != null)<br> {<br> e.ExceptionHandled = true;<br> NotifyUser("Product with ID " + id + " cannot be deleted. Reason: " + e.Exception.Message);<br> }<br> else<br> {<br> NotifyUser("Product with ID " + id + " is deleted!");<br> }<br> <br> }Dim tile = RadTileList1.GetAllTiles.Find(Function(x) x.ID = item.ID)If tile IsNot Nothing Then RadTileList1.GetAllTiles.Remove(tile)End If<telerik:RadDatePicker runat="server" Width="140px" DateInput-EmptyMessage="mm/dd/yyyy" MinDate="2000-01-01"></telerik:RadDatePicker><%@ Page Language="VB" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html><script runat="server"> Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load If Page.IsPostBack = False Then MultiPage.PageViews(0).Selected = True End If End Sub Protected Sub NextButton_Click(sender As Object, e As EventArgs) Handles NextButton.Click Dim TabIndex As Integer = 0 If TabIndexLabel.Text = 0 Then TabIndex = 1 End If TabIndexLabel.Text = TabIndex MultiPage.PageViews(TabIndex).Selected = True End Sub</script><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <asp:Label ID="TabIndexLabel" runat="server" Text="0" Visible="false"></asp:Label> <telerik:RadSplitter ID="RadSplitter1" runat="server"> <telerik:RadPane ID="RadPane1" runat="server" Scrolling="None" Width="100px"> <asp:Button ID="NextButton" runat="server" Text="Next Tab" /> </telerik:RadPane> <telerik:RadPane ID="RadPane2" runat="server" Scrolling="None"> <telerik:RadMultiPage ID="MultiPage" runat="server"> <telerik:RadPageView ID="PV0" runat="server"> <telerik:RadSplitter ID="Splitter0" runat="server"> <telerik:RadPane ID="RadPane7" runat="server"> </telerik:RadPane> <telerik:RadPane ID="RadPane8" runat="server"> </telerik:RadPane> </telerik:RadSplitter> </telerik:RadPageView> <telerik:RadPageView ID="PV1" runat="server"> <telerik:RadSplitter ID="Splitter1" runat="server"> <telerik:RadPane ID="RadPane13" runat="server"> </telerik:RadPane> <telerik:RadPane ID="RadPane14" runat="server"> </telerik:RadPane> </telerik:RadSplitter> </telerik:RadPageView> </telerik:RadMultiPage> </telerik:RadPane> </telerik:RadSplitter> </form></body></html>