Gridview Detailsview Master-Detail Relationship DataKeyField

by Caroline Bogart on March 31, 2006

‹%@ Page Language=”C#” MasterPageFile=”~/MasterAdmin.master” AutoEventWireup=”true” CodeFile=”admin_testimonial.aspx.cs” Inherits=”admin_testimonial” Title=”Untitled Page” %›
‹asp:Content ID=”idContent” ContentPlaceHolderID=”leftcontent” runat=”server”

‹asp:sqldatasource id=”ds_view” runat=”server” connectionstring=”"›”
SelectCommand=”SELECT [idTestimonial], [company] FROM [testimonial]“›

‹/asp:SqlDataSource›

‹asp:GridView ID=”GridView1″ runat=”server”
AutoGenerateColumns=”False”
DataSourceID=”ds_view”
DataKeyNames=”idTestimonial”
SelectedIndex=”0″›
‹columns›
‹asp:templatefield›
‹itemtemplate›
‹asp:linkbutton commandname=”Select” runat=”server”›
‹%#Eval(”idTestimonial”) %›‹/asp:LinkButton›
‹/itemtemplate›
‹/asp:TemplateField›
‹/columns›

‹/asp:GridView›

‹asp:SqlDataSource ID=”ds_edit” runat=”server”
SelectCommand=”Select * from testimonial where idTestimonial=@idTestimonial” ConnectionString=”‹%$ ConnectionStrings:ryason %›”

‹selectparameters›
‹asp:controlparameter controlid=”GridView1″ name=”idTestimonial” propertyname=”SelectedValue”›
‹/selectparameters›
‹/asp:SqlDataSource›

‹asp:DetailsView ID=”details” DataSourceID=”ds_edit” runat=”server”
AutoGenerateRows=”false”
DataKeyNames=”idTestimonial”›
‹fields›
‹asp:templatefield›
‹headertemplate›Edit:‹/headertemplate›
‹itemtemplate›
‹asp:button commandname=”Edit” text=”Edit” runat=”server”›
‹/itemtemplate›
‹/asp:TemplateField›

‹asp:boundfield datafield=”idTestimonial” readonly=”true”›
‹/fields›
‹/asp:DetailsView›

‹/asp:Content›

{ 0 comments… add one now }