Home All Groups Group Topic Archive Search About
Author
4 Apr 2006 9:13 AM
bill tie
I'm exploring Microsoft sample code.  This is a master/detail scenario with
two SqlDataSources.  The master table shows Northwind.Customers data.  In the
detail table, I can massage a row of data selected from the master table.

In the SqlDataSource code that handles the "detail" part, I see a mile-long
<UpdateParameters> list:

<UpdateParameters>
  <asp:Parameter Name="CompanyName" Type="String" />
  <asp:Parameter Name="ContactName" Type="String" />
  ...
</UpdateParameters>

If I delete the list, the program works just as well.

- Why is that?
- What is the purpose of the list?

Thank you.

Author
4 Apr 2006 11:37 AM
Otis Mukinfus
On Tue, 4 Apr 2006 02:13:16 -0700, bill tie <bill***@discussions.microsoft.com>
wrote:

Show quote
>
>I'm exploring Microsoft sample code.  This is a master/detail scenario with
>two SqlDataSources.  The master table shows Northwind.Customers data.  In the
>detail table, I can massage a row of data selected from the master table.
>
>In the SqlDataSource code that handles the "detail" part, I see a mile-long
><UpdateParameters> list:
>
><UpdateParameters>
>  <asp:Parameter Name="CompanyName" Type="String" />
>  <asp:Parameter Name="ContactName" Type="String" />
>  ...
></UpdateParameters>
>
>If I delete the list, the program works just as well.
>
>- Why is that?
>- What is the purpose of the list?
>
>Thank you.
>
>
>

INSERT INTO destination(col1, col2)
       SELECT col1, col2
       FROM source

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
Author
4 Apr 2006 11:37 AM
Otis Mukinfus
On Tue, 4 Apr 2006 02:13:16 -0700, bill tie <bill***@discussions.microsoft.com>
wrote:

Show quote
>
>I'm exploring Microsoft sample code.  This is a master/detail scenario with
>two SqlDataSources.  The master table shows Northwind.Customers data.  In the
>detail table, I can massage a row of data selected from the master table.
>
>In the SqlDataSource code that handles the "detail" part, I see a mile-long
><UpdateParameters> list:
>
><UpdateParameters>
>  <asp:Parameter Name="CompanyName" Type="String" />
>  <asp:Parameter Name="ContactName" Type="String" />
>  ...
></UpdateParameters>
>
>If I delete the list, the program works just as well.
>
>- Why is that?
>- What is the purpose of the list?
>
>Thank you.
>
>
>
OOPS! wrong post...

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

AddThis Social Bookmark Button