| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Hello,
|
| I am creating a form for users to enter information about a lab and the
| members of the lab.  I have one form (FormView) that they use to enter
| information about that lab.  The keyvalue is "LabLocation_ID".  With an
| existing lab, they then need to add the members for that lab.  So, what I
am
| trying to do is the following.  With the FormView of the Lab open, the
user
| will click a button to open a FormView (InsertMode) and add a new user. 
My
| question is, how do I copy the "LabLocation_ID" from the "Lab" FormView to
| the "Member" FormView?
|
| table structure (tblLabLocation_Member)
| LabLocation_ID (varchar 200)
| Member_ID (varchar 200)
|
| --
| Thanks in advance,
|
| sck10
|
|
|

"Steven Cheng[MSFT]" <stch***@online.microsoft.com> wrote in message
news:QZXZ6T4BGHA.1236@TK2MSFTNGXA02.phx.gbl...
> Hi Sck10,
>
> Welcome to ASPNET newsgroup.
> As for the displaying master/details structure datas through the ASP.NET
> 2.0 databound controls, I think you can consider the following means;
>
> use the FormView to bound to the Lab table(through a SqlDataSource), and
> set the FormView's DataKeyNames to the Lab table's primary Key,   and
> then,
> declare another DataSource which select data from Member table through the
> Lab_Member relation table....
> we can declare  a select parameter (for where clause ) in the
> SqlDataSource's SelectCommand , and set the select parameter as
> ControlParameter which pointed to the Lab FormView's SelectedValue
> property....   After that, we can bound the second datasource to a certain
> GridView or another Formview /DetailsView......   Thus, the relation
> between the master/details datas is established....
> Below is a sample Page which use a FormView and a GridView to display
> Master/Detail data from the Northwind database's  Orders and OrderDetails
> tables.....
>
> ==================================
> <form id="form1" runat="server">
>    <div>
>        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
> ConnectionString="<%$ ConnectionStrings:LocalNorthWind %>"
>            DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @OrderID"
> InsertCommand="INSERT INTO [Orders] ([CustomerID], [EmployeeID],
> [OrderDate]) VALUES (@CustomerID, @EmployeeID, @OrderDate)"
>            SelectCommand="SELECT [OrderID], [CustomerID], [EmployeeID],
> [OrderDate] FROM [Orders]"
>            UpdateCommand="UPDATE [Orders] SET [CustomerID] = @CustomerID,
> [EmployeeID] = @EmployeeID, [OrderDate] = @OrderDate WHERE [OrderID] =
> @OrderID">
>            <DeleteParameters>
>                <asp:Parameter Name="OrderID" Type="Int32" />
>            </DeleteParameters>
>            <UpdateParameters>
>                <asp:Parameter Name="CustomerID" Type="String" />
>                <asp:Parameter Name="EmployeeID" Type="Int32" />
>                <asp:Parameter Name="OrderDate" Type="DateTime" />
>                <asp:Parameter Name="OrderID" Type="Int32" />
>            </UpdateParameters>
>            <InsertParameters>
>                <asp:Parameter Name="CustomerID" Type="String" />
>                <asp:Parameter Name="EmployeeID" Type="Int32" />
>                <asp:Parameter Name="OrderDate" Type="DateTime" />
>            </InsertParameters>
>        </asp:SqlDataSource>
>
>    </div>
>        <asp:FormView ID="FormView1" runat="server" AllowPaging="True"
> DataKeyNames="OrderID"
>            DataSourceID="SqlDataSource1">
>            <EditItemTemplate>
>                OrderID:
>                <asp:Label ID="OrderIDLabel1" runat="server" Text='<%#
> Eval("OrderID") %>'></asp:Label><br />
>                CustomerID:
>                <asp:TextBox ID="CustomerIDTextBox" runat="server"
> Text='<%# Bind("CustomerID") %>'>
>                </asp:TextBox><br />
>                EmployeeID:
>                <asp:TextBox ID="EmployeeIDTextBox" runat="server"
> Text='<%# Bind("EmployeeID") %>'>
>                </asp:TextBox><br />
>                OrderDate:
>                <asp:TextBox ID="OrderDateTextBox" runat="server" Text='<%#
> Bind("OrderDate") %>'>
>                </asp:TextBox><br />
>                <asp:LinkButton ID="UpdateButton" runat="server"
> CausesValidation="True" CommandName="Update"
>                    Text="Update">
>                </asp:LinkButton>
>                <asp:LinkButton ID="UpdateCancelButton" runat="server"
> CausesValidation="False" CommandName="Cancel"
>                    Text="Cancel">
>                </asp:LinkButton>
>            </EditItemTemplate>
>            <InsertItemTemplate>
>                CustomerID:
>                <asp:TextBox ID="CustomerIDTextBox" runat="server"
> Text='<%# Bind("CustomerID") %>'>
>                </asp:TextBox><br />
>                EmployeeID:
>                <asp:TextBox ID="EmployeeIDTextBox" runat="server"
> Text='<%# Bind("EmployeeID") %>'>
>                </asp:TextBox><br />
>                OrderDate:
>                <asp:TextBox ID="OrderDateTextBox" runat="server" Text='<%#
> Bind("OrderDate") %>'>
>                </asp:TextBox><br />
>                <asp:LinkButton ID="InsertButton" runat="server"
> CausesValidation="True" CommandName="Insert"
>                    Text="Insert">
>                </asp:LinkButton>
>                <asp:LinkButton ID="InsertCancelButton" runat="server"
> CausesValidation="False" CommandName="Cancel"
>                    Text="Cancel">
>                </asp:LinkButton>
>            </InsertItemTemplate>
>            <ItemTemplate>
>                OrderID:
>                <asp:Label ID="OrderIDLabel" runat="server" Text='<%#
> Eval("OrderID") %>'></asp:Label><br />
>                CustomerID:
>                <asp:Label ID="CustomerIDLabel" runat="server" Text='<%#
> Bind("CustomerID") %>'>
>                </asp:Label><br />
>                EmployeeID:
>                <asp:Label ID="EmployeeIDLabel" runat="server" Text='<%#
> Bind("EmployeeID") %>'>
>                </asp:Label><br />
>                OrderDate:
>                <asp:Label ID="OrderDateLabel" runat="server" Text='<%#
> Bind("OrderDate") %>'></asp:Label><br />
>                <asp:LinkButton ID="EditButton" runat="server"
> CausesValidation="False" CommandName="Edit"
>                    Text="Edit">
>                </asp:LinkButton>
>                <asp:LinkButton ID="DeleteButton" runat="server"
> CausesValidation="False" CommandName="Delete"
>                    Text="Delete">
>                </asp:LinkButton>
>                <asp:LinkButton ID="NewButton" runat="server"
> CausesValidation="False" CommandName="New"
>                    Text="New">
>                </asp:LinkButton>
>            </ItemTemplate>
>        </asp:FormView>
>        <asp:SqlDataSource ID="SqlDataSource2" runat="server"
> ConnectionString="<%$ ConnectionStrings:LocalNorthWind %>"
>            DeleteCommand="DELETE FROM [Order Details] WHERE [OrderID] =
> @OrderID AND [ProductID] = @ProductID"
>            InsertCommand="INSERT INTO [Order Details] ([OrderID],
> [ProductID], [Discount], [Quantity], [UnitPrice]) VALUES (@OrderID,
> @ProductID, @Discount, @Quantity, @UnitPrice)"
>            SelectCommand="SELECT [OrderID], [ProductID], [Discount],
> [Quantity], [UnitPrice] FROM [Order Details] WHERE ([OrderID] = @OrderID)"
>            UpdateCommand="UPDATE [Order Details] SET [Discount] =
> @Discount, [Quantity] = @Quantity, [UnitPrice] = @UnitPrice WHERE
> [OrderID]
> = @OrderID AND [ProductID] = @ProductID">
>            <DeleteParameters>
>                <asp:Parameter Name="OrderID" Type="Int32" />
>                <asp:Parameter Name="ProductID" Type="Int32" />
>            </DeleteParameters>
>            <UpdateParameters>
>                <asp:Parameter Name="Discount" Type="Single" />
>                <asp:Parameter Name="Quantity" Type="Int16" />
>                <asp:Parameter Name="UnitPrice" Type="Decimal" />
>                <asp:Parameter Name="OrderID" Type="Int32" />
>                <asp:Parameter Name="ProductID" Type="Int32" />
>            </UpdateParameters>
>            <SelectParameters>
>                <asp:ControlParameter ControlID="FormView1" Name="OrderID"
> PropertyName="SelectedValue"
>                    Type="Int32" />
>            </SelectParameters>
>            <InsertParameters>
>                <asp:Parameter Name="OrderID" Type="Int32" />
>                <asp:Parameter Name="ProductID" Type="Int32" />
>                <asp:Parameter Name="Discount" Type="Single" />
>                <asp:Parameter Name="Quantity" Type="Int16" />
>                <asp:Parameter Name="UnitPrice" Type="Decimal" />
>            </InsertParameters>
>        </asp:SqlDataSource>
>        <asp:GridView ID="GridView1" runat="server"
> AutoGenerateColumns="False" DataKeyNames="OrderID,ProductID"
>            DataSourceID="SqlDataSource2">
>            <Columns>
>                <asp:CommandField ShowEditButton="True"
> ShowSelectButton="True" />
>                <asp:BoundField DataField="OrderID" HeaderText="OrderID"
> ReadOnly="True" SortExpression="OrderID" />
>                <asp:BoundField DataField="ProductID"
> HeaderText="ProductID" ReadOnly="True" SortExpression="ProductID" />
>                <asp:BoundField DataField="Discount" HeaderText="Discount"
> SortExpression="Discount" />
>                <asp:BoundField DataField="Quantity" HeaderText="Quantity"
> SortExpression="Quantity" />
>                <asp:BoundField DataField="UnitPrice"
> HeaderText="UnitPrice" SortExpression="UnitPrice" />
>            </Columns>
>        </asp:GridView>
>    </form>
> ========================
>
> Hope helps. Thanks,
>
> Steven Cheng
> Microsoft Online Support
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --------------------
> | From: "sck10" <sck10@online.nospam>
> | Subject: Populating FormView (asp.net 2.0 using vb.net)
> | Date: Thu, 22 Dec 2005 17:57:59 -0600
> | Lines: 21
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
> | Message-ID: <eS7TKO1BGHA.2***@TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.dotnet.framework.aspnet
> | NNTP-Posting-Host: 189.202.185.135.in-addr.arpa 135.185.202.189
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.dotnet.framework.aspnet:366683
> | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
> |
> | Hello,
> |
> | I am creating a form for users to enter information about a lab and the
> | members of the lab.  I have one form (FormView) that they use to enter
> | information about that lab.  The keyvalue is "LabLocation_ID".  With an
> | existing lab, they then need to add the members for that lab.  So, what
> I
> am
> | trying to do is the following.  With the FormView of the Lab open, the
> user
> | will click a button to open a FormView (InsertMode) and add a new user.
> My
> | question is, how do I copy the "LabLocation_ID" from the "Lab" FormView
> to
> | the "Member" FormView?
> |
> | table structure (tblLabLocation_Member)
> | LabLocation_ID (varchar 200)
> | Member_ID (varchar 200)
> |
> | --
> | Thanks in advance,
> |
> | sck10
> |
> |
> |
>

| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Hi Steven,
|
| I'd like to do something like this, but my problem is the fact that I
have a
| list of the members and have to add some of them to a new lab. I've done
| something similar in vs 2003 with the strongly typed Dataset. This
solution
| helps me to save all changes only after final submit. Is there a better
way
| to do so in vs 2005.
|
| Thanks,
|
| Vlad Sadilov
|
| "Steven Cheng[MSFT]" <stch***@online.microsoft.com> wrote in message
| news:QZXZ6T4BGHA.1236@TK2MSFTNGXA02.phx.gbl...
| > Hi Sck10,
| >
| > Welcome to ASPNET newsgroup.
| > As for the displaying master/details structure datas through the ASP.NET
| > 2.0 databound controls, I think you can consider the following means;
| >
| > use the FormView to bound to the Lab table(through a SqlDataSource), and
| > set the FormView's DataKeyNames to the Lab table's primary Key,   and
| > then,
| > declare another DataSource which select data from Member table through
the
| > Lab_Member relation table....
| > we can declare  a select parameter (for where clause ) in the
| > SqlDataSource's SelectCommand , and set the select parameter as
| > ControlParameter which pointed to the Lab FormView's SelectedValue
| > property....   After that, we can bound the second datasource to a
certain
| > GridView or another Formview /DetailsView......   Thus, the relation
| > between the master/details datas is established....
| > Below is a sample Page which use a FormView and a GridView to display
| > Master/Detail data from the Northwind database's  Orders and
OrderDetails
| > tables.....
| >
| > ==================================
| > <form id="form1" runat="server">
| >    <div>
| >        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
| > ConnectionString="<%$ ConnectionStrings:LocalNorthWind %>"
| >            DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] =
@OrderID"
| > InsertCommand="INSERT INTO [Orders] ([CustomerID], [EmployeeID],
| > [OrderDate]) VALUES (@CustomerID, @EmployeeID, @OrderDate)"
| >            SelectCommand="SELECT [OrderID], [CustomerID], [EmployeeID],
| > [OrderDate] FROM [Orders]"
| >            UpdateCommand="UPDATE [Orders] SET [CustomerID] =
@CustomerID,
| > [EmployeeID] = @EmployeeID, [OrderDate] = @OrderDate WHERE [OrderID] =
| > @OrderID">
| >            <DeleteParameters>
| >                <asp:Parameter Name="OrderID" Type="Int32" />
| >            </DeleteParameters>
| >            <UpdateParameters>
| >                <asp:Parameter Name="CustomerID" Type="String" />
| >                <asp:Parameter Name="EmployeeID" Type="Int32" />
| >                <asp:Parameter Name="OrderDate" Type="DateTime" />
| >                <asp:Parameter Name="OrderID" Type="Int32" />
| >            </UpdateParameters>
| >            <InsertParameters>
| >                <asp:Parameter Name="CustomerID" Type="String" />
| >                <asp:Parameter Name="EmployeeID" Type="Int32" />
| >                <asp:Parameter Name="OrderDate" Type="DateTime" />
| >            </InsertParameters>
| >        </asp:SqlDataSource>
| >
| >    </div>
| >        <asp:FormView ID="FormView1" runat="server" AllowPaging="True"
| > DataKeyNames="OrderID"
| >            DataSourceID="SqlDataSource1">
| >            <EditItemTemplate>
| >                OrderID:
| >                <asp:Label ID="OrderIDLabel1" runat="server" Text='<%#
| > Eval("OrderID") %>'></asp:Label><br />
| >                CustomerID:
| >                <asp:TextBox ID="CustomerIDTextBox" runat="server"
| > Text='<%# Bind("CustomerID") %>'>
| >                </asp:TextBox><br />
| >                EmployeeID:
| >                <asp:TextBox ID="EmployeeIDTextBox" runat="server"
| > Text='<%# Bind("EmployeeID") %>'>
| >                </asp:TextBox><br />
| >                OrderDate:
| >                <asp:TextBox ID="OrderDateTextBox" runat="server"
Text='<%#
| > Bind("OrderDate") %>'>
| >                </asp:TextBox><br />
| >                <asp:LinkButton ID="UpdateButton" runat="server"
| > CausesValidation="True" CommandName="Update"
| >                    Text="Update">
| >                </asp:LinkButton>
| >                <asp:LinkButton ID="UpdateCancelButton" runat="server"
| > CausesValidation="False" CommandName="Cancel"
| >                    Text="Cancel">
| >                </asp:LinkButton>
| >            </EditItemTemplate>
| >            <InsertItemTemplate>
| >                CustomerID:
| >                <asp:TextBox ID="CustomerIDTextBox" runat="server"
| > Text='<%# Bind("CustomerID") %>'>
| >                </asp:TextBox><br />
| >                EmployeeID:
| >                <asp:TextBox ID="EmployeeIDTextBox" runat="server"
| > Text='<%# Bind("EmployeeID") %>'>
| >                </asp:TextBox><br />
| >                OrderDate:
| >                <asp:TextBox ID="OrderDateTextBox" runat="server"
Text='<%#
| > Bind("OrderDate") %>'>
| >                </asp:TextBox><br />
| >                <asp:LinkButton ID="InsertButton" runat="server"
| > CausesValidation="True" CommandName="Insert"
| >                    Text="Insert">
| >                </asp:LinkButton>
| >                <asp:LinkButton ID="InsertCancelButton" runat="server"
| > CausesValidation="False" CommandName="Cancel"
| >                    Text="Cancel">
| >                </asp:LinkButton>
| >            </InsertItemTemplate>
| >            <ItemTemplate>
| >                OrderID:
| >                <asp:Label ID="OrderIDLabel" runat="server" Text='<%#
| > Eval("OrderID") %>'></asp:Label><br />
| >                CustomerID:
| >                <asp:Label ID="CustomerIDLabel" runat="server" Text='<%#
| > Bind("CustomerID") %>'>
| >                </asp:Label><br />
| >                EmployeeID:
| >                <asp:Label ID="EmployeeIDLabel" runat="server" Text='<%#
| > Bind("EmployeeID") %>'>
| >                </asp:Label><br />
| >                OrderDate:
| >                <asp:Label ID="OrderDateLabel" runat="server" Text='<%#
| > Bind("OrderDate") %>'></asp:Label><br />
| >                <asp:LinkButton ID="EditButton" runat="server"
| > CausesValidation="False" CommandName="Edit"
| >                    Text="Edit">
| >                </asp:LinkButton>
| >                <asp:LinkButton ID="DeleteButton" runat="server"
| > CausesValidation="False" CommandName="Delete"
| >                    Text="Delete">
| >                </asp:LinkButton>
| >                <asp:LinkButton ID="NewButton" runat="server"
| > CausesValidation="False" CommandName="New"
| >                    Text="New">
| >                </asp:LinkButton>
| >            </ItemTemplate>
| >        </asp:FormView>
| >        <asp:SqlDataSource ID="SqlDataSource2" runat="server"
| > ConnectionString="<%$ ConnectionStrings:LocalNorthWind %>"
| >            DeleteCommand="DELETE FROM [Order Details] WHERE [OrderID] =
| > @OrderID AND [ProductID] = @ProductID"
| >            InsertCommand="INSERT INTO [Order Details] ([OrderID],
| > [ProductID], [Discount], [Quantity], [UnitPrice]) VALUES (@OrderID,
| > @ProductID, @Discount, @Quantity, @UnitPrice)"
| >            SelectCommand="SELECT [OrderID], [ProductID], [Discount],
| > [Quantity], [UnitPrice] FROM [Order Details] WHERE ([OrderID] =
@OrderID)"
| >            UpdateCommand="UPDATE [Order Details] SET [Discount] =
| > @Discount, [Quantity] = @Quantity, [UnitPrice] = @UnitPrice WHERE
| > [OrderID]
| > = @OrderID AND [ProductID] = @ProductID">
| >            <DeleteParameters>
| >                <asp:Parameter Name="OrderID" Type="Int32" />
| >                <asp:Parameter Name="ProductID" Type="Int32" />
| >            </DeleteParameters>
| >            <UpdateParameters>
| >                <asp:Parameter Name="Discount" Type="Single" />
| >                <asp:Parameter Name="Quantity" Type="Int16" />
| >                <asp:Parameter Name="UnitPrice" Type="Decimal" />
| >                <asp:Parameter Name="OrderID" Type="Int32" />
| >                <asp:Parameter Name="ProductID" Type="Int32" />
| >            </UpdateParameters>
| >            <SelectParameters>
| >                <asp:ControlParameter ControlID="FormView1"
Name="OrderID"
| > PropertyName="SelectedValue"
| >                    Type="Int32" />
| >            </SelectParameters>
| >            <InsertParameters>
| >                <asp:Parameter Name="OrderID" Type="Int32" />
| >                <asp:Parameter Name="ProductID" Type="Int32" />
| >                <asp:Parameter Name="Discount" Type="Single" />
| >                <asp:Parameter Name="Quantity" Type="Int16" />
| >                <asp:Parameter Name="UnitPrice" Type="Decimal" />
| >            </InsertParameters>
| >        </asp:SqlDataSource>
| >        <asp:GridView ID="GridView1" runat="server"
| > AutoGenerateColumns="False" DataKeyNames="OrderID,ProductID"
| >            DataSourceID="SqlDataSource2">
| >            <Columns>
| >                <asp:CommandField ShowEditButton="True"
| > ShowSelectButton="True" />
| >                <asp:BoundField DataField="OrderID" HeaderText="OrderID"
| > ReadOnly="True" SortExpression="OrderID" />
| >                <asp:BoundField DataField="ProductID"
| > HeaderText="ProductID" ReadOnly="True" SortExpression="ProductID" />
| >                <asp:BoundField DataField="Discount"
HeaderText="Discount"
| > SortExpression="Discount" />
| >                <asp:BoundField DataField="Quantity"
HeaderText="Quantity"
| > SortExpression="Quantity" />
| >                <asp:BoundField DataField="UnitPrice"
| > HeaderText="UnitPrice" SortExpression="UnitPrice" />
| >            </Columns>
| >        </asp:GridView>
| >    </form>
| > ========================
| >
| > Hope helps. Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| > --------------------
| > | From: "sck10" <sck10@online.nospam>
| > | Subject: Populating FormView (asp.net 2.0 using vb.net)
| > | Date: Thu, 22 Dec 2005 17:57:59 -0600
| > | Lines: 21
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
| > | Message-ID: <eS7TKO1BGHA.2***@TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.dotnet.framework.aspnet
| > | NNTP-Posting-Host: 189.202.185.135.in-addr.arpa 135.185.202.189
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
| > microsoft.public.dotnet.framework.aspnet:366683
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
| > |
| > | Hello,
| > |
| > | I am creating a form for users to enter information about a lab and
the
| > | members of the lab.  I have one form (FormView) that they use to enter
| > | information about that lab.  The keyvalue is "LabLocation_ID".  With
an
| > | existing lab, they then need to add the members for that lab.  So,
what
| > I
| > am
| > | trying to do is the following.  With the FormView of the Lab open, the
| > user
| > | will click a button to open a FormView (InsertMode) and add a new
user.
| > My
| > | question is, how do I copy the "LabLocation_ID" from the "Lab"
FormView
| > to
| > | the "Member" FormView?
| > |
| > | table structure (tblLabLocation_Member)
| > | LabLocation_ID (varchar 200)
| > | Member_ID (varchar 200)
| > |
| > | --
| > | Thanks in advance,
| > |
| > | sck10
| > |
| > |
| > |
| >
|
|
|