Hi
I have a listview that I have populated with different values. What i would like is to read through these values and update them in my database. eg my listviiew looks like this
Size wh total wing total ml kilo
x-large 3000 15002 7800
large 1285 11021 5800
med 800 120 1500
ok so here it goes basically what i need to do is get the size of the product for each row in there and update its qty available field in the products table
where the productid is equal to the size.
I have figured out ways to do this like loop through and put all three values with their corresponding ids into one string and pass the string to a function which breaks up the values and puts the corresponding qty and product code in the update statement but im guessing that there must be an easier way then this im fairly new to .NET and can see that its much more powerful then VB6.
Anybody have any suggestions??
I have a listview that I have populated with different values. What i would like is to read through these values and update them in my database. eg my listviiew looks like this
Size wh total wing total ml kilo
x-large 3000 15002 7800
large 1285 11021 5800
med 800 120 1500
ok so here it goes basically what i need to do is get the size of the product for each row in there and update its qty available field in the products table
where the productid is equal to the size.
I have figured out ways to do this like loop through and put all three values with their corresponding ids into one string and pass the string to a function which breaks up the values and puts the corresponding qty and product code in the update statement but im guessing that there must be an easier way then this im fairly new to .NET and can see that its much more powerful then VB6.
Anybody have any suggestions??