Gridview Detailsview master-detail SelectParameter ControlParameter

‹%@ Page Language=”C#” MasterPageFile=”~/MasterAdmin.master” AutoEventWireup=”true” CodeFile=”admin2_testimonial.aspx.cs” Inherits=”admin2_testimonial” Title=”Untitled Page” %›
‹asp:Content ID=”Content1″ ContentPlaceHolderID=”leftcontent” Runat=”Server”›
‹asp:GridView ID=”gv” runat=”server” AutoGenerateColumns=”False” DataKeyNames=”idTestimonial” DataSourceID=”ds_view” OnSelectedIndexChanged=”gv_SelectedIndexChanged”›
‹Columns›
‹asp:CommandField ShowSelectButton=”True” /›
‹asp:HyperLinkField DataTextField=”idTestimonial” Text=”Select” /›
‹asp:BoundField DataField=”idTestimonial” HeaderText=”idTestimonial” InsertVisible=”False”
ReadOnly=”True” SortExpression=”idTestimonial” /›
‹asp:BoundField DataField=”company” HeaderText=”company” SortExpression=”company” /›
‹/Columns›
‹/asp:GridView›

‹asp:DetailsView ID=”dv” runat=”server” AutoGenerateRows=”False” DataKeyNames=”idTestimonial” DataSourceID=”ds_edit”›
‹Fields›
‹asp:TemplateField HeaderText=”idTestimonial” InsertVisible=”False” SortExpression=”idTestimonial“›
‹EditItemTemplate›
‹asp:Label ID=”Label1″ runat=”server” Text=’‹%# Eval(”idTestimonial“) %›’›‹/asp:Label›
‹/EditItemTemplate›
‹ItemTemplate›
‹asp:Label ID=”Label1″ runat=”server” Text=’‹%# Bind(”idTestimonial“) %›’›‹/asp:Label›
‹/ItemTemplate›
‹/asp:TemplateField›
‹asp:BoundField DataField=”firstName” HeaderText=”firstName” SortExpression=”firstName” /›
‹asp:BoundField DataField=”lastName” HeaderText=”lastName” SortExpression=”lastName” /›
‹asp:BoundField DataField=”email” HeaderText=”email” SortExpression=”email” /›
‹asp:BoundField DataField=”phone” HeaderText=”phone” SortExpression=”phone” /›
‹asp:BoundField DataField=”company” HeaderText=”company” SortExpression=”company” /›
‹asp:BoundField DataField=”website” HeaderText=”website” SortExpression=”website” /›
‹asp:BoundField DataField=”street” HeaderText=”street” SortExpression=”street” /›
‹asp:BoundField DataField=”city” HeaderText=”city” SortExpression=”city” /›
‹asp:BoundField DataField=”state” HeaderText=”state” SortExpression=”state” /›
‹asp:BoundField DataField=”zip” HeaderText=”zip” SortExpression=”zip” /›
‹asp:BoundField DataField=”testimonial” HeaderText=”testimonial” SortExpression=”testimonial” /›
‹asp:CheckBoxField DataField=”phoneReference” HeaderText=”phoneReference” SortExpression=”phoneReference” /›
‹asp:CheckBoxField DataField=”emailReference” HeaderText=”emailReference” SortExpression=”emailReference” /›
‹asp:CheckBoxField DataField=”approved” HeaderText=”approved” SortExpression=”approved” /›
‹asp:CommandField ShowEditButton=”True” /›
‹/Fields›
‹/asp:DetailsView›
‹asp:SqlDataSource ID=”ds_view” runat=”server” ConnectionString=”‹%$ ConnectionStrings:ryason %›”
SelectCommand=”SELECT [idTestimonial], [company] FROM [testimonial]“›‹/asp:SqlDataSource›
‹asp:SqlDataSource ID=”ds_edit” runat=”server” ConnectionString=”‹%$ ConnectionStrings:ryason %›”
DeleteCommand=”DELETE FROM [testimonial] WHERE [idTestimonial] = @idTestimonial”
InsertCommand=”INSERT INTO [testimonial] ([firstName], [lastName], [email], [phone], [company], [website], [street], [city], [state], [zip], [testimonial], [phoneReference], [emailReference], [approved]) VALUES (@firstName, @lastName, @email, @phone, @company, @website, @street, @city, @state, @zip, @testimonial, @phoneReference, @emailReference, @approved)”
SelectCommand=”SELECT * FROM [testimonial] where idTestimonial=@idTestimonial”

UpdateCommand=”UPDATE [testimonial] SET [firstName] = @firstName, [lastName] = @lastName, [email] = @email, [phone] = @phone, [company] = @company, [website] = @website, [street] = @street, [city] = @city, [state] = @state, [zip] = @zip, [testimonial] = @testimonial, [phoneReference] = @phoneReference, [emailReference] = @emailReference, [approved] = @approved WHERE [idTestimonial] = @idTestimonial“›
‹SelectParameters›
‹asp:ControlParameter ControlID=”gv” DefaultValue=”7″ Name=”idTestimonial” PropertyName=”SelectedValue” Type=”int32″ /›
‹/SelectParameters›
‹DeleteParameters›
‹asp:Parameter Name=”idTestimonial” Type=”Int32″ /›
‹/DeleteParameters›
‹UpdateParameters›
‹asp:Parameter Name=”firstName” Type=”String” /›
‹asp:Parameter Name=”lastName” Type=”String” /›
‹asp:Parameter Name=”email” Type=”String” /›
‹asp:Parameter Name=”phone” Type=”String” /›
‹asp:Parameter Name=”company” Type=”String” /›
‹asp:Parameter Name=”website” Type=”String” /›
‹asp:Parameter Name=”street” Type=”String” /›
‹asp:Parameter Name=”city” Type=”String” /›
‹asp:Parameter Name=”state” Type=”String” /›
‹asp:Parameter Name=”zip” Type=”String” /›
‹asp:Parameter Name=”testimonial” Type=”String” /›
‹asp:Parameter Name=”phoneReference” Type=”Boolean” /›
‹asp:Parameter Name=”emailReference” Type=”Boolean” /›
‹asp:Parameter Name=”approved” Type=”Boolean” /›
‹asp:Parameter Name=”idTestimonial” Type=”Int32″ /›
‹/UpdateParameters›
‹InsertParameters›
‹asp:Parameter Name=”firstName” Type=”String” /›
‹asp:Parameter Name=”lastName” Type=”String” /›
‹asp:Parameter Name=”email” Type=”String” /›
‹asp:Parameter Name=”phone” Type=”String” /›
‹asp:Parameter Name=”company” Type=”String” /›
‹asp:Parameter Name=”website” Type=”String” /›
‹asp:Parameter Name=”street” Type=”String” /›
‹asp:Parameter Name=”city” Type=”String” /›
‹asp:Parameter Name=”state” Type=”String” /›
‹asp:Parameter Name=”zip” Type=”String” /›
‹asp:Parameter Name=”testimonial” Type=”String” /›
‹asp:Parameter Name=”phoneReference” Type=”Boolean” /›
‹asp:Parameter Name=”emailReference” Type=”Boolean” /›
‹asp:Parameter Name=”approved” Type=”Boolean” /›
‹/InsertParameters›
‹/asp:SqlDataSource›

‹/asp:Content›

‹asp:Content ID=”Content2″ ContentPlaceHolderID=”rightcontent” Runat=”Server”›
‹/asp:Content›