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:AccessData Source ID="countryList " runat="server"
DataFile="~/App_Data/products.mdb"
SelectCommand=" SELECT country.*, product.* FROM country, product
WHERE country.country ID = product.country ID;"
ConflictDetecti on="CompareAllV alues"
OldValuesParame terFormatString ="original_{ 0}"
UpdateCommand=" UPDATE Product SET [cost]=? WHERE [countryID]=? AND
[productID]=?">
<UpdateParamete rs>
<asp:Paramete r Name="cost" Type="int32" />
<asp:Paramete r Name="countryID " Type="int32" />
<asp:Paramete r Name="productID " Type="int32" />
</UpdateParameter s>
</asp:AccessDataS ource>
How does asp.net KNOW what values to put into the update parameters ?
and what do you guys think I am missing here ?
Evan