By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,500 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

updating multiple tables

P: n/a
Hi all... this is one part of ASP.net that i just dont understand...
and GOD knows, i am trying.
I have 2 tables, the first one called country [countryID, countryName]
and the second called product[productID, countryID, productName]

I create a datagrid and have to custom write the sql Select command

Up to this point it all works fine... the hitch is that i also want to
be able to update the damned thing... here is the declaration of my
datasource... what do I need to do? please I am a newbie here... so
dont get to technical use easy words and if you have to swear at me,
dont use stars, I am likley going to think that is some sort of
variable and will try use it in some code...

<asp:AccessDataSource ID="countryList" runat="server"
DataFile="~/App_Data/products.mdb"
SelectCommand="SELECT country.*, product.* FROM country, product
WHERE country.countryID = product.countryID;"
ConflictDetection="CompareAllValues"
OldValuesParameterFormatString="original_{0}"
UpdateCommand="UPDATE Product SET [cost]=? WHERE [countryID]=? AND
[productID]=?">
<UpdateParameters>
<asp:Parameter Name="cost" Type="int32" />
<asp:Parameter Name="countryID" Type="int32" />
<asp:Parameter Name="productID" Type="int32" />
</UpdateParameters>
</asp:AccessDataSource>

How does asp.net KNOW what values to put into the update parameters ?
and what do you guys think I am missing here ?

Evan

Mar 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Evandela,

I can't really answer your question exactly, but I can point you to a
tutorial that I think may help your understanding:

http://msdn2.microsoft.com/en-us/library/ms178294.aspx

The link above is to a tutorial on adding a dropdownlist to the edit area of
a gridview control (all without coding) so that the items to choose from in
the gridview (linked via PrimaryKey) in the main table are selectable in the
dropdown and the primary key gets updated in the original table.

It should be a good start for you to understand what's going on. (I hope.)

Regards,

--
S. Justin Gengo
Web Developer / Programmer

Free code library:
http://www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
<ev******@bigpond.net.au> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...
Hi all... this is one part of ASP.net that i just dont understand...
and GOD knows, i am trying.
I have 2 tables, the first one called country [countryID, countryName]
and the second called product[productID, countryID, productName]

I create a datagrid and have to custom write the sql Select command

Up to this point it all works fine... the hitch is that i also want to
be able to update the damned thing... here is the declaration of my
datasource... what do I need to do? please I am a newbie here... so
dont get to technical use easy words and if you have to swear at me,
dont use stars, I am likley going to think that is some sort of
variable and will try use it in some code...

<asp:AccessDataSource ID="countryList" runat="server"
DataFile="~/App_Data/products.mdb"
SelectCommand="SELECT country.*, product.* FROM country, product
WHERE country.countryID = product.countryID;"
ConflictDetection="CompareAllValues"
OldValuesParameterFormatString="original_{0}"
UpdateCommand="UPDATE Product SET [cost]=? WHERE [countryID]=? AND
[productID]=?">
<UpdateParameters>
<asp:Parameter Name="cost" Type="int32" />
<asp:Parameter Name="countryID" Type="int32" />
<asp:Parameter Name="productID" Type="int32" />
</UpdateParameters>
</asp:AccessDataSource>

How does asp.net KNOW what values to put into the update parameters ?
and what do you guys think I am missing here ?

Evan

Mar 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.