I'm trying to figure out how to insert a record by using a UserControl. I have a Master Gridview with a child gridview and want to be able to insert a new record into the child grid. I have created a UserControl "InsertOil.ascx" and added a reference to it in the RadGrid but when I click on the Add New Record button I only get the built in edit/insert form which works so I guess I have not configured the grid to call the UserControl properly. I will post the relevant code in hopes that someone can stewer me in the right directio before I go completely mad. Thanks for any help.
Here is the User Control
<%@ Page Title="" Language="VB" MasterPageFile="~/Facilities.master" AutoEventWireup="false" CodeFile="OilAdditions.aspx.vb" Inherits="SiteReporting_OilAdditions" %> |
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" Runat="Server"> |
<telerik:RadGrid ID="RadGrid1" |
runat="server" |
DataSourceID="sdsGenerators" |
GridLines="None" |
ShowGroupPanel="True" Skin="Hay" |
AutoGenerateColumns="False" |
Width="500px"> |
<MasterTableView DataSourceID="sdsGenerators" |
GroupLoadMode="Client" |
DataKeyNames="EquipmentID" |
HierarchyLoadMode="Client" |
> |
<DetailTables> |
<telerik:GridTableView runat="server" |
DataSourceID="sdsOilAdditions" |
AllowAutomaticInserts="True" |
GroupLoadMode="Client" |
HierarchyLoadMode="Client" AllowPaging="True" |
CommandItemDisplay="Top"> |
<ParentTableRelation> |
<telerik:GridRelationFields DetailKeyField="EquipmentID" |
MasterKeyField="EquipmentID" /> |
</ParentTableRelation> |
<Columns> |
<telerik:GridBoundColumn DataField="DateAdded" DataFormatString="{0:dd MMM, yy}" HeaderText="DateAdded" DataType="System.DateTime" UniqueName="DateAdded"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Quantity" HeaderText="Qty (Gals)" DataType="System.Double" UniqueName="Quantity"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Scheduled" HeaderText="Added During RWP" DataType="System.Boolean" UniqueName="Scheduled"> |
</telerik:GridBoundColumn> |
</Columns> |
</telerik:GridTableView> |
</DetailTables> |
<ExpandCollapseColumn Visible="True"></ExpandCollapseColumn> |
<Columns> |
<telerik:GridBoundColumn DataField="EquipmentID_Old" |
HeaderText="Generator" |
SortExpression="EquipmentID_Old" |
UniqueName="EquipmentID_Old"> |
</telerik:GridBoundColumn> |
</Columns> |
<EditFormSettings UserControlName="InsertOil.ascx" EditFormType="WebUserControl"> |
<EditColumn UniqueName="EditCommandColumn1"> |
</EditColumn> |
</EditFormSettings> |
</MasterTableView> |
</telerik:RadGrid> |
<asp:SqlDataSource ID="sdsGenerators" runat="server" |
ConnectionString="<%$ ConnectionStrings:AAIOMSConnectionString %>" |
SelectCommand="spSelectFAC_PowerPlantsBySiteID" |
SelectCommandType="StoredProcedure"> |
<SelectParameters> |
<asp:SessionParameter DefaultValue="7" Name="SiteID" SessionField="SiteID" |
Type="Int32" /> |
</SelectParameters> |
</asp:SqlDataSource> |
<asp:SqlDataSource ID="sdsOilAdditions" runat="server" |
ConnectionString="<%$ ConnectionStrings:AAIOMSConnectionString %>" |
SelectCommand="spSelectFAC_OilAdditionsByEquipmentID" |
SelectCommandType="StoredProcedure" |
InsertCommand="spInsertFAC_OilAdditions" InsertCommandType="StoredProcedure"> |
<SelectParameters> |
<asp:SessionParameter Name="EquipmentID" SessionField="EquipmentID" |
Type="Int32" /> |
</SelectParameters> |
<InsertParameters> |
<asp:Parameter Name="EquipmentID" Type="Int32" /> |
<asp:Parameter Name="DateAdded" Type="DateTime" /> |
<asp:Parameter Name="Scheduled" Type="Boolean" /> |
<asp:Parameter Name="Quantity" Type="Double" /> |
<asp:Parameter Name="AddedBy" Type="String" /> |
</InsertParameters> |
</asp:SqlDataSource> |
</asp:Content> |
Here is the User Control
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="InsertOil.ascx.vb" Inherits="WorkOrders_InsertOil" %> |
EquipmentID<asp:TextBox ID="txtEquipmentID" runat="server"></asp:TextBox><br /> |
Date Added<asp:TextBox ID="txtDateAdded" runat="server"></asp:TextBox><br /> |
Quantity<asp:TextBox ID="txtQuantity" runat="server"></asp:TextBox><br /> |
Added By<asp:TextBox ID="txtAddedBy" runat="server"></asp:TextBox><br /> |
Scheduled<asp:CheckBox ID="chkScheduled" runat="server" /> |