vb.net 2003 problem with ado.net

[User 4485473]

currently am developing a inventory control system for my friend using visual studio 2003 and am using ms access as the back end. I don't want to use any wizard so am doing everything by coding. but i don't know how to update a access data base using oledb commands. I tried many ways but its giving me errors . Is there any way to do this without using wizards , will I be able to update the table using oledb commands . Please help me I will Be waiting for your reply.:confused:

cool buddy

[Anoop Brijmohun]

hi, could you send the update code you are using so i can check it out... thanks

[Purushottam2]

hi, update table name (field name ='"+ textbox1.text+"',where field name =condition); bye bey

purushottam

[Anoop Brijmohun]

hi The Code below is in vb.net, this is what i use and it works fine.. ******************************* UPDATE [TableName] SET QtyOnHand=" & me.txtQty.text.trim & " WHERE [Condition]" ******************************** Hope This Helps.... Anoop