Home All Groups Group Topic Archive Search About

Integration of GridView and FormView

Author
27 Jul 2006 5:44 PM
gary7584
Hello,

I have set up a master-detail relationship with a GridView and FormView that
is working well, with the ability to select a record in the GridView and then
update or delete that record in the FormView, or insert a new record.  The
problem I’m having is after I make a modification to my table in the
FormView, I can’t get my GridView to display the changes that have been made.
It seems like a simple binding or refresh command would take care of this,
but I've come up empty so far.

Here is my code.  Thanks in advance for your help.

Gary

<html>
<head id="Head1" runat="server" />
<body>
  <form id="Form1" runat="server">

    <asp:SqlDataSource runat="server" ID="MySource"
      ConnectionString="SERVER=ResearchDB1;DATABASE=sqlbpa1"
      DataSourceMode="DataSet"        
      SelectCommand="SELECT pageid, pagetypeid, pagetemplateid, pagename
FROM page"
      UpdateCommand="UPDATE page SET pagetypeid=@pagetypeid,
pagetemplateid=@pagetemplateid, pagename=@pagename WHERE pageid=@pageid"
      InsertCommand="INSERT INTO page VALUES (@pageid, @pagetypeid,
@pagetemplateid, @pagename)"
      DeleteCommand="DELETE FROM page WHERE pageid=@pageid">
    </asp:SqlDataSource>

    <asp:SqlDataSource runat="server" ID="MyDetailSource"
      ConnectionString="SERVER=ResearchDB1;DATABASE=sqlbpa1"
      DataSourceMode="DataSet"
      SelectCommand="SELECT pageid, pagetypeid, pagetemplateid, pagename
FROM page"
      UpdateCommand="UPDATE page SET pagetypeid=@pagetypeid,
pagetemplateid=@pagetemplateid, pagename=@pagename WHERE pageid=@pageid"
      InsertCommand="INSERT INTO page VALUES (@pageid, @pagetypeid,
@pagetemplateid, @pagename)"
      DeleteCommand="DELETE FROM page WHERE pageid=@pageid"
      FilterExpression="pageid='{0}'">
      <filterparameters>
        <asp:ControlParameter Name="PageID" ControlID="grid"
PropertyName="SelectedValue" />
      </filterparameters>
   </asp:SqlDataSource>

    <asp:GridView runat="server" ID="grid" 
         DataSourceId="MySource"
         pagesize="4"
         allowpaging="true"
         autogenerateselectbutton="true"
         AutoGenerateColumns="false"
         DataKeyNames="PageID">
         <columns>
                <asp:boundfield datafield="PageID" headertext="PageID" />
                <asp:boundfield datafield="PageTypeID"
headertext="PageTypeID" />
                <asp:boundfield datafield="PageTemplateID"
headertext="PageTemplateID" />
                <asp:boundfield datafield="PageName" headertext="PageName" />
         </columns>
    </asp:GridView>

      <asp:FormView ID="FormView1" runat="server"
DataSourceID="MyDetailSource" DataKeyNames="PageID">
        <ItemTemplate>
       <table>
            <tr>
              <td>
                <p>PageID</p>
              </td>
              <td>
                <%#Eval("PageID")%>
              </td>
            </tr>
            <tr>
             <tr>
              <td>
                <p>PageTypeID</p>
              </td>
              <td>
                <%#Eval("PageTypeID")%>
              </td>
            </tr>
            <tr>
             <tr>
              <td>
                <p>PageTemplateID</p>
              </td>
              <td>
                <%#Eval("PageTemplateID")%>
              </td>
            </tr>
            <tr>
              <td>
                <p>PageName</p>
              </td>
              <td>
                <%#Eval("PageName")%>
              </td>
            </tr>
            <tr>
              <td colspan = "2">
                <asp:Button ID="Edit" Text="Edit" CommandName="Edit"
runat="server" />
                <asp:Button ID="New" Text="New..." CommandName="New"
runat="server" />
                <asp:Button ID="Delete" Text="Delete..."
CommandName="Delete" runat="server" />
             </td>
            </tr>
         </table>
        </ItemTemplate>
       <EditItemTemplate>
       <table>
            <tr>
              <td>
                <p>PageID</p>
              </td>
              <td>
                <%#Eval("PageID")%>             
                </td>
            </tr>
            <tr>
             <tr>
              <td>
                <p>PageTypeID</p>
              </td>
              <td>
                <asp:TextBox runat=server ID="PageTypeID" Text='<%#
Bind("PageTypeID") %>' />      
              </td>
            </tr>
            <tr>
             <tr>
              <td>
                <p>PageTemplateID</p>
              </td>
              <td>
                <asp:TextBox runat=server ID="PageTemplateID" Text='<%#
Bind("PageTemplateID") %>' />      
              </td>
            </tr>
            <tr>
              <td>
                <p>PageName</p>
              </td>
              <td>
                <asp:TextBox Width=500 runat=server ID="PageName" Text='<%#
Bind("pagename") %>' />      
              </td>
            </tr>
            <tr>
            <td colspan = "2">
                <asp:Button ID="UpdateButton" Text="Update"
CommandName="Update" runat="server" />
                <asp:Button ID="CancelButton" Text="Cancel"
CommandName="Cancel" runat="server" />           
            </td>
            </tr>
         </table>
        </EditItemTemplate>
       <InsertItemTemplate>
       <table>
            <tr>
              <td>
                <p>PageID</p>
              </td>
              <td>
                <asp:TextBox runat=server ID="PageID" Text='<%#
Bind("PageID") %>' />      
                </td>
            </tr>
            <tr>
             <tr>
              <td>
                <p>PageTypeID</p>
              </td>
              <td>
                <asp:TextBox runat=server ID="PageTypeID" Text='<%#
Bind("PageTypeID") %>' />      
              </td>
            </tr>
            <tr>
             <tr>
              <td>
                <p>PageTemplateID</p>
              </td>
              <td>
                <asp:TextBox runat=server ID="PageTemplateID" Text='<%#
Bind("PageTemplateID") %>' />      
              </td>
            </tr>
            <tr>
              <td>
                <p>PageName</p>
              </td>
              <td>
                <asp:TextBox Width=500 runat=server ID="PageName" Text='<%#
Bind("pagename") %>' />      
              </td>
            </tr>
            <tr>
            <td colspan = "2">
                <asp:Button ID="InsertButton" Text="Insert"
CommandName="Insert" runat="server" />
                <asp:Button ID="CancelButton" Text="Cancel"
CommandName="Cancel" runat="server" />           
            </td>
            </tr>
         </table>
        </InsertItemTemplate>
        <EmptyDataTemplate>
           <asp:Button ID="New" Text="New..." CommandName="New"
runat="server" />
        </EmptyDataTemplate>
      </asp:FormView>
  </form>
</body>
</html>

Author
27 Jul 2006 7:31 PM
Alessandro Zifiglio
hi, have you tried calling grid.DataBind() after the update, this should
force it to refresh.


Regards,
Alessandro Zifiglio
http://www.AsyncUI.net

Show quoteHide quote
"gary7584" <gary7***@discussions.microsoft.com> ha scritto nel messaggio
news:C55D9044-6D50-4CA1-B39E-C357E20A9236@microsoft.com...
> Hello,
>
> I have set up a master-detail relationship with a GridView and FormView
> that
> is working well, with the ability to select a record in the GridView and
> then
> update or delete that record in the FormView, or insert a new record.  The
> problem I'm having is after I make a modification to my table in the
> FormView, I can't get my GridView to display the changes that have been
> made.
> It seems like a simple binding or refresh command would take care of this,
> but I've come up empty so far.
>
> Here is my code.  Thanks in advance for your help.
>
> Gary
>
> <html>
> <head id="Head1" runat="server" />
> <body>
>  <form id="Form1" runat="server">
>
>    <asp:SqlDataSource runat="server" ID="MySource"
>      ConnectionString="SERVER=ResearchDB1;DATABASE=sqlbpa1"
>      DataSourceMode="DataSet"
>      SelectCommand="SELECT pageid, pagetypeid, pagetemplateid, pagename
> FROM page"
>      UpdateCommand="UPDATE page SET pagetypeid=@pagetypeid,
> pagetemplateid=@pagetemplateid, pagename=@pagename WHERE pageid=@pageid"
>      InsertCommand="INSERT INTO page VALUES (@pageid, @pagetypeid,
> @pagetemplateid, @pagename)"
>      DeleteCommand="DELETE FROM page WHERE pageid=@pageid">
>    </asp:SqlDataSource>
>
>    <asp:SqlDataSource runat="server" ID="MyDetailSource"
>      ConnectionString="SERVER=ResearchDB1;DATABASE=sqlbpa1"
>      DataSourceMode="DataSet"
>      SelectCommand="SELECT pageid, pagetypeid, pagetemplateid, pagename
> FROM page"
>      UpdateCommand="UPDATE page SET pagetypeid=@pagetypeid,
> pagetemplateid=@pagetemplateid, pagename=@pagename WHERE pageid=@pageid"
>      InsertCommand="INSERT INTO page VALUES (@pageid, @pagetypeid,
> @pagetemplateid, @pagename)"
>      DeleteCommand="DELETE FROM page WHERE pageid=@pageid"
>      FilterExpression="pageid='{0}'">
>      <filterparameters>
>        <asp:ControlParameter Name="PageID" ControlID="grid"
> PropertyName="SelectedValue" />
>      </filterparameters>
>   </asp:SqlDataSource>
>
>    <asp:GridView runat="server" ID="grid"
>         DataSourceId="MySource"
>         pagesize="4"
>         allowpaging="true"
>         autogenerateselectbutton="true"
>         AutoGenerateColumns="false"
>         DataKeyNames="PageID">
>         <columns>
>                <asp:boundfield datafield="PageID" headertext="PageID" />
>                <asp:boundfield datafield="PageTypeID"
> headertext="PageTypeID" />
>                <asp:boundfield datafield="PageTemplateID"
> headertext="PageTemplateID" />
>                <asp:boundfield datafield="PageName" headertext="PageName"
> />
>         </columns>
>    </asp:GridView>
>
>      <asp:FormView ID="FormView1" runat="server"
> DataSourceID="MyDetailSource" DataKeyNames="PageID">
>        <ItemTemplate>
>       <table>
>            <tr>
>              <td>
>                <p>PageID</p>
>              </td>
>              <td>
>                <%#Eval("PageID")%>
>              </td>
>            </tr>
>            <tr>
>             <tr>
>              <td>
>                <p>PageTypeID</p>
>              </td>
>              <td>
>                <%#Eval("PageTypeID")%>
>              </td>
>            </tr>
>            <tr>
>             <tr>
>              <td>
>                <p>PageTemplateID</p>
>              </td>
>              <td>
>                <%#Eval("PageTemplateID")%>
>              </td>
>            </tr>
>            <tr>
>              <td>
>                <p>PageName</p>
>              </td>
>              <td>
>                <%#Eval("PageName")%>
>              </td>
>            </tr>
>            <tr>
>              <td colspan = "2">
>                <asp:Button ID="Edit" Text="Edit" CommandName="Edit"
> runat="server" />
>                <asp:Button ID="New" Text="New..." CommandName="New"
> runat="server" />
>                <asp:Button ID="Delete" Text="Delete..."
> CommandName="Delete" runat="server" />
>             </td>
>            </tr>
>         </table>
>        </ItemTemplate>
>       <EditItemTemplate>
>       <table>
>            <tr>
>              <td>
>                <p>PageID</p>
>              </td>
>              <td>
>                <%#Eval("PageID")%>
>                </td>
>            </tr>
>            <tr>
>             <tr>
>              <td>
>                <p>PageTypeID</p>
>              </td>
>              <td>
>                <asp:TextBox runat=server ID="PageTypeID" Text='<%#
> Bind("PageTypeID") %>' />
>              </td>
>            </tr>
>            <tr>
>             <tr>
>              <td>
>                <p>PageTemplateID</p>
>              </td>
>              <td>
>                <asp:TextBox runat=server ID="PageTemplateID" Text='<%#
> Bind("PageTemplateID") %>' />
>              </td>
>            </tr>
>            <tr>
>              <td>
>                <p>PageName</p>
>              </td>
>              <td>
>                <asp:TextBox Width=500 runat=server ID="PageName" Text='<%#
> Bind("pagename") %>' />
>              </td>
>            </tr>
>            <tr>
>            <td colspan = "2">
>                <asp:Button ID="UpdateButton" Text="Update"
> CommandName="Update" runat="server" />
>                <asp:Button ID="CancelButton" Text="Cancel"
> CommandName="Cancel" runat="server" />
>            </td>
>            </tr>
>         </table>
>        </EditItemTemplate>
>       <InsertItemTemplate>
>       <table>
>            <tr>
>              <td>
>                <p>PageID</p>
>              </td>
>              <td>
>                <asp:TextBox runat=server ID="PageID" Text='<%#
> Bind("PageID") %>' />
>                </td>
>            </tr>
>            <tr>
>             <tr>
>              <td>
>                <p>PageTypeID</p>
>              </td>
>              <td>
>                <asp:TextBox runat=server ID="PageTypeID" Text='<%#
> Bind("PageTypeID") %>' />
>              </td>
>            </tr>
>            <tr>
>             <tr>
>              <td>
>                <p>PageTemplateID</p>
>              </td>
>              <td>
>                <asp:TextBox runat=server ID="PageTemplateID" Text='<%#
> Bind("PageTemplateID") %>' />
>              </td>
>            </tr>
>            <tr>
>              <td>
>                <p>PageName</p>
>              </td>
>              <td>
>                <asp:TextBox Width=500 runat=server ID="PageName" Text='<%#
> Bind("pagename") %>' />
>              </td>
>            </tr>
>            <tr>
>            <td colspan = "2">
>                <asp:Button ID="InsertButton" Text="Insert"
> CommandName="Insert" runat="server" />
>                <asp:Button ID="CancelButton" Text="Cancel"
> CommandName="Cancel" runat="server" />
>            </td>
>            </tr>
>         </table>
>        </InsertItemTemplate>
>        <EmptyDataTemplate>
>           <asp:Button ID="New" Text="New..." CommandName="New"
> runat="server" />
>        </EmptyDataTemplate>
>      </asp:FormView>
>  </form>
> </body>
> </html>
>
Author
27 Jul 2006 9:05 PM
gary7584
Perfect, thank you!!

Show quoteHide quote
"Alessandro Zifiglio" wrote:

> hi, have you tried calling grid.DataBind() after the update, this should
> force it to refresh.
>
>
> Regards,
> Alessandro Zifiglio
> http://www.AsyncUI.net
>
> "gary7584" <gary7***@discussions.microsoft.com> ha scritto nel messaggio
> news:C55D9044-6D50-4CA1-B39E-C357E20A9236@microsoft.com...
> > Hello,
> >
> > I have set up a master-detail relationship with a GridView and FormView
> > that
> > is working well, with the ability to select a record in the GridView and
> > then
> > update or delete that record in the FormView, or insert a new record.  The
> > problem I'm having is after I make a modification to my table in the
> > FormView, I can't get my GridView to display the changes that have been
> > made.
> > It seems like a simple binding or refresh command would take care of this,
> > but I've come up empty so far.
> >
> > Here is my code.  Thanks in advance for your help.
> >
> > Gary
> >
> > <html>
> > <head id="Head1" runat="server" />
> > <body>
> >  <form id="Form1" runat="server">
> >
> >    <asp:SqlDataSource runat="server" ID="MySource"
> >      ConnectionString="SERVER=ResearchDB1;DATABASE=sqlbpa1"
> >      DataSourceMode="DataSet"
> >      SelectCommand="SELECT pageid, pagetypeid, pagetemplateid, pagename
> > FROM page"
> >      UpdateCommand="UPDATE page SET pagetypeid=@pagetypeid,
> > pagetemplateid=@pagetemplateid, pagename=@pagename WHERE pageid=@pageid"
> >      InsertCommand="INSERT INTO page VALUES (@pageid, @pagetypeid,
> > @pagetemplateid, @pagename)"
> >      DeleteCommand="DELETE FROM page WHERE pageid=@pageid">
> >    </asp:SqlDataSource>
> >
> >    <asp:SqlDataSource runat="server" ID="MyDetailSource"
> >      ConnectionString="SERVER=ResearchDB1;DATABASE=sqlbpa1"
> >      DataSourceMode="DataSet"
> >      SelectCommand="SELECT pageid, pagetypeid, pagetemplateid, pagename
> > FROM page"
> >      UpdateCommand="UPDATE page SET pagetypeid=@pagetypeid,
> > pagetemplateid=@pagetemplateid, pagename=@pagename WHERE pageid=@pageid"
> >      InsertCommand="INSERT INTO page VALUES (@pageid, @pagetypeid,
> > @pagetemplateid, @pagename)"
> >      DeleteCommand="DELETE FROM page WHERE pageid=@pageid"
> >      FilterExpression="pageid='{0}'">
> >      <filterparameters>
> >        <asp:ControlParameter Name="PageID" ControlID="grid"
> > PropertyName="SelectedValue" />
> >      </filterparameters>
> >   </asp:SqlDataSource>
> >
> >    <asp:GridView runat="server" ID="grid"
> >         DataSourceId="MySource"
> >         pagesize="4"
> >         allowpaging="true"
> >         autogenerateselectbutton="true"
> >         AutoGenerateColumns="false"
> >         DataKeyNames="PageID">
> >         <columns>
> >                <asp:boundfield datafield="PageID" headertext="PageID" />
> >                <asp:boundfield datafield="PageTypeID"
> > headertext="PageTypeID" />
> >                <asp:boundfield datafield="PageTemplateID"
> > headertext="PageTemplateID" />
> >                <asp:boundfield datafield="PageName" headertext="PageName"
> > />
> >         </columns>
> >    </asp:GridView>
> >
> >      <asp:FormView ID="FormView1" runat="server"
> > DataSourceID="MyDetailSource" DataKeyNames="PageID">
> >        <ItemTemplate>
> >       <table>
> >            <tr>
> >              <td>
> >                <p>PageID</p>
> >              </td>
> >              <td>
> >                <%#Eval("PageID")%>
> >              </td>
> >            </tr>
> >            <tr>
> >             <tr>
> >              <td>
> >                <p>PageTypeID</p>
> >              </td>
> >              <td>
> >                <%#Eval("PageTypeID")%>
> >              </td>
> >            </tr>
> >            <tr>
> >             <tr>
> >              <td>
> >                <p>PageTemplateID</p>
> >              </td>
> >              <td>
> >                <%#Eval("PageTemplateID")%>
> >              </td>
> >            </tr>
> >            <tr>
> >              <td>
> >                <p>PageName</p>
> >              </td>
> >              <td>
> >                <%#Eval("PageName")%>
> >              </td>
> >            </tr>
> >            <tr>
> >              <td colspan = "2">
> >                <asp:Button ID="Edit" Text="Edit" CommandName="Edit"
> > runat="server" />
> >                <asp:Button ID="New" Text="New..." CommandName="New"
> > runat="server" />
> >                <asp:Button ID="Delete" Text="Delete..."
> > CommandName="Delete" runat="server" />
> >             </td>
> >            </tr>
> >         </table>
> >        </ItemTemplate>
> >       <EditItemTemplate>
> >       <table>
> >            <tr>
> >              <td>
> >                <p>PageID</p>
> >              </td>
> >              <td>
> >                <%#Eval("PageID")%>
> >                </td>
> >            </tr>
> >            <tr>
> >             <tr>
> >              <td>
> >                <p>PageTypeID</p>
> >              </td>
> >              <td>
> >                <asp:TextBox runat=server ID="PageTypeID" Text='<%#
> > Bind("PageTypeID") %>' />
> >              </td>
> >            </tr>
> >            <tr>
> >             <tr>
> >              <td>
> >                <p>PageTemplateID</p>
> >              </td>
> >              <td>
> >                <asp:TextBox runat=server ID="PageTemplateID" Text='<%#
> > Bind("PageTemplateID") %>' />
> >              </td>
> >            </tr>
> >            <tr>
> >              <td>
> >                <p>PageName</p>
> >              </td>
> >              <td>
> >                <asp:TextBox Width=500 runat=server ID="PageName" Text='<%#
> > Bind("pagename") %>' />
> >              </td>
> >            </tr>
> >            <tr>
> >            <td colspan = "2">
> >                <asp:Button ID="UpdateButton" Text="Update"
> > CommandName="Update" runat="server" />
> >                <asp:Button ID="CancelButton" Text="Cancel"
> > CommandName="Cancel" runat="server" />
> >            </td>
> >            </tr>
> >         </table>
> >        </EditItemTemplate>
> >       <InsertItemTemplate>
> >       <table>
> >            <tr>
> >              <td>
> >                <p>PageID</p>
> >              </td>
> >              <td>
> >                <asp:TextBox runat=server ID="PageID" Text='<%#
> > Bind("PageID") %>' />
> >                </td>
> >            </tr>
> >            <tr>
> >             <tr>
> >              <td>
> >                <p>PageTypeID</p>
> >              </td>
> >              <td>
> >                <asp:TextBox runat=server ID="PageTypeID" Text='<%#
> > Bind("PageTypeID") %>' />
> >              </td>
> >            </tr>
> >            <tr>
> >             <tr>
> >              <td>
> >                <p>PageTemplateID</p>
> >              </td>
> >              <td>
> >                <asp:TextBox runat=server ID="PageTemplateID" Text='<%#
> > Bind("PageTemplateID") %>' />
> >              </td>
> >            </tr>
> >            <tr>
> >              <td>
> >                <p>PageName</p>
> >              </td>
> >              <td>
> >                <asp:TextBox Width=500 runat=server ID="PageName" Text='<%#
> > Bind("pagename") %>' />
> >              </td>
> >            </tr>
> >            <tr>
> >            <td colspan = "2">
> >                <asp:Button ID="InsertButton" Text="Insert"
> > CommandName="Insert" runat="server" />
> >                <asp:Button ID="CancelButton" Text="Cancel"
> > CommandName="Cancel" runat="server" />
> >            </td>
> >            </tr>
> >         </table>
> >        </InsertItemTemplate>
> >        <EmptyDataTemplate>
> >           <asp:Button ID="New" Text="New..." CommandName="New"
> > runat="server" />
> >        </EmptyDataTemplate>
> >      </asp:FormView>
> >  </form>
> > </body>
> > </html>
> >
>
>
>
Author
28 Jul 2006 7:42 AM
Alessandro Zifiglio
you are welcome, Gary.

have a good day,
Alessandro Zifiglio
http://www.AsyncUI.net

Show quoteHide quote
"gary7584" <gary7***@discussions.microsoft.com> ha scritto nel messaggio
news:4D8B11E5-C0CB-421C-A778-4F804136F052@microsoft.com...
> Perfect, thank you!!
>
> "Alessandro Zifiglio" wrote:
>
>> hi, have you tried calling grid.DataBind() after the update, this should
>> force it to refresh.
>>
>>
>> Regards,
>> Alessandro Zifiglio
>> http://www.AsyncUI.net
>>
>> "gary7584" <gary7***@discussions.microsoft.com> ha scritto nel messaggio
>> news:C55D9044-6D50-4CA1-B39E-C357E20A9236@microsoft.com...
>> > Hello,
>> >
>> > I have set up a master-detail relationship with a GridView and FormView
>> > that
>> > is working well, with the ability to select a record in the GridView
>> > and
>> > then
>> > update or delete that record in the FormView, or insert a new record.
>> > The
>> > problem I'm having is after I make a modification to my table in the
>> > FormView, I can't get my GridView to display the changes that have been
>> > made.
>> > It seems like a simple binding or refresh command would take care of
>> > this,
>> > but I've come up empty so far.
>> >
>> > Here is my code.  Thanks in advance for your help.
>> >
>> > Gary
>> >
>> > <html>
>> > <head id="Head1" runat="server" />
>> > <body>
>> >  <form id="Form1" runat="server">
>> >
>> >    <asp:SqlDataSource runat="server" ID="MySource"
>> >      ConnectionString="SERVER=ResearchDB1;DATABASE=sqlbpa1"
>> >      DataSourceMode="DataSet"
>> >      SelectCommand="SELECT pageid, pagetypeid, pagetemplateid, pagename
>> > FROM page"
>> >      UpdateCommand="UPDATE page SET pagetypeid=@pagetypeid,
>> > pagetemplateid=@pagetemplateid, pagename=@pagename WHERE
>> > pageid=@pageid"
>> >      InsertCommand="INSERT INTO page VALUES (@pageid, @pagetypeid,
>> > @pagetemplateid, @pagename)"
>> >      DeleteCommand="DELETE FROM page WHERE pageid=@pageid">
>> >    </asp:SqlDataSource>
>> >
>> >    <asp:SqlDataSource runat="server" ID="MyDetailSource"
>> >      ConnectionString="SERVER=ResearchDB1;DATABASE=sqlbpa1"
>> >      DataSourceMode="DataSet"
>> >      SelectCommand="SELECT pageid, pagetypeid, pagetemplateid, pagename
>> > FROM page"
>> >      UpdateCommand="UPDATE page SET pagetypeid=@pagetypeid,
>> > pagetemplateid=@pagetemplateid, pagename=@pagename WHERE
>> > pageid=@pageid"
>> >      InsertCommand="INSERT INTO page VALUES (@pageid, @pagetypeid,
>> > @pagetemplateid, @pagename)"
>> >      DeleteCommand="DELETE FROM page WHERE pageid=@pageid"
>> >      FilterExpression="pageid='{0}'">
>> >      <filterparameters>
>> >        <asp:ControlParameter Name="PageID" ControlID="grid"
>> > PropertyName="SelectedValue" />
>> >      </filterparameters>
>> >   </asp:SqlDataSource>
>> >
>> >    <asp:GridView runat="server" ID="grid"
>> >         DataSourceId="MySource"
>> >         pagesize="4"
>> >         allowpaging="true"
>> >         autogenerateselectbutton="true"
>> >         AutoGenerateColumns="false"
>> >         DataKeyNames="PageID">
>> >         <columns>
>> >                <asp:boundfield datafield="PageID" headertext="PageID"
>> > />
>> >                <asp:boundfield datafield="PageTypeID"
>> > headertext="PageTypeID" />
>> >                <asp:boundfield datafield="PageTemplateID"
>> > headertext="PageTemplateID" />
>> >                <asp:boundfield datafield="PageName"
>> > headertext="PageName"
>> > />
>> >         </columns>
>> >    </asp:GridView>
>> >
>> >      <asp:FormView ID="FormView1" runat="server"
>> > DataSourceID="MyDetailSource" DataKeyNames="PageID">
>> >        <ItemTemplate>
>> >       <table>
>> >            <tr>
>> >              <td>
>> >                <p>PageID</p>
>> >              </td>
>> >              <td>
>> >                <%#Eval("PageID")%>
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >             <tr>
>> >              <td>
>> >                <p>PageTypeID</p>
>> >              </td>
>> >              <td>
>> >                <%#Eval("PageTypeID")%>
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >             <tr>
>> >              <td>
>> >                <p>PageTemplateID</p>
>> >              </td>
>> >              <td>
>> >                <%#Eval("PageTemplateID")%>
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >              <td>
>> >                <p>PageName</p>
>> >              </td>
>> >              <td>
>> >                <%#Eval("PageName")%>
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >              <td colspan = "2">
>> >                <asp:Button ID="Edit" Text="Edit" CommandName="Edit"
>> > runat="server" />
>> >                <asp:Button ID="New" Text="New..." CommandName="New"
>> > runat="server" />
>> >                <asp:Button ID="Delete" Text="Delete..."
>> > CommandName="Delete" runat="server" />
>> >             </td>
>> >            </tr>
>> >         </table>
>> >        </ItemTemplate>
>> >       <EditItemTemplate>
>> >       <table>
>> >            <tr>
>> >              <td>
>> >                <p>PageID</p>
>> >              </td>
>> >              <td>
>> >                <%#Eval("PageID")%>
>> >                </td>
>> >            </tr>
>> >            <tr>
>> >             <tr>
>> >              <td>
>> >                <p>PageTypeID</p>
>> >              </td>
>> >              <td>
>> >                <asp:TextBox runat=server ID="PageTypeID" Text='<%#
>> > Bind("PageTypeID") %>' />
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >             <tr>
>> >              <td>
>> >                <p>PageTemplateID</p>
>> >              </td>
>> >              <td>
>> >                <asp:TextBox runat=server ID="PageTemplateID" Text='<%#
>> > Bind("PageTemplateID") %>' />
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >              <td>
>> >                <p>PageName</p>
>> >              </td>
>> >              <td>
>> >                <asp:TextBox Width=500 runat=server ID="PageName"
>> > Text='<%#
>> > Bind("pagename") %>' />
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >            <td colspan = "2">
>> >                <asp:Button ID="UpdateButton" Text="Update"
>> > CommandName="Update" runat="server" />
>> >                <asp:Button ID="CancelButton" Text="Cancel"
>> > CommandName="Cancel" runat="server" />
>> >            </td>
>> >            </tr>
>> >         </table>
>> >        </EditItemTemplate>
>> >       <InsertItemTemplate>
>> >       <table>
>> >            <tr>
>> >              <td>
>> >                <p>PageID</p>
>> >              </td>
>> >              <td>
>> >                <asp:TextBox runat=server ID="PageID" Text='<%#
>> > Bind("PageID") %>' />
>> >                </td>
>> >            </tr>
>> >            <tr>
>> >             <tr>
>> >              <td>
>> >                <p>PageTypeID</p>
>> >              </td>
>> >              <td>
>> >                <asp:TextBox runat=server ID="PageTypeID" Text='<%#
>> > Bind("PageTypeID") %>' />
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >             <tr>
>> >              <td>
>> >                <p>PageTemplateID</p>
>> >              </td>
>> >              <td>
>> >                <asp:TextBox runat=server ID="PageTemplateID" Text='<%#
>> > Bind("PageTemplateID") %>' />
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >              <td>
>> >                <p>PageName</p>
>> >              </td>
>> >              <td>
>> >                <asp:TextBox Width=500 runat=server ID="PageName"
>> > Text='<%#
>> > Bind("pagename") %>' />
>> >              </td>
>> >            </tr>
>> >            <tr>
>> >            <td colspan = "2">
>> >                <asp:Button ID="InsertButton" Text="Insert"
>> > CommandName="Insert" runat="server" />
>> >                <asp:Button ID="CancelButton" Text="Cancel"
>> > CommandName="Cancel" runat="server" />
>> >            </td>
>> >            </tr>
>> >         </table>
>> >        </InsertItemTemplate>
>> >        <EmptyDataTemplate>
>> >           <asp:Button ID="New" Text="New..." CommandName="New"
>> > runat="server" />
>> >        </EmptyDataTemplate>
>> >      </asp:FormView>
>> >  </form>
>> > </body>
>> > </html>
>> >
>>
>>
>>