Updating database

[johnuk4]

Hi have a pretty basic knowledge of programming so just wanted to know if anyone could give me a little assistance. Basically I i have created a query which shows results from a database into a datagrid. One of the columns is called resolved flag (basically used if the user wants to mark this record as resolved) This is in the form of a check box. What i want to do is when the user selects this check box and clicks an update button, the database is updated with this new altered dataset.

I have been playing around trying to get this to work but with no success. Could someone possible point me in the right direction.

Thanks very much

Johnuk4

 

[fpineda101]

Should go something like this...

UpdateButton_click()
dim isResolved as boolean
Select case true
case checkBox.value
isResolved = true
case else
isResolved = false
end select

<Set your parameters here for the stored procedure>
<execute your stored procedure>

end sub

 

[johnuk4]

Hey,

Thanks for the reply, basically i have more then one record in the dataset so not really sure how to use your method with that. Sorry im a beginner at programming so please bare with me. A lot of articles seem to suggest using the dataadapter to update. Would you knwo anything about this?

Thanks

John

 

[fpineda101]

Read this article thoroughly...

http://msdn.microsoft.com/library/?url=/library/en-us/dnadvnet/html/vbnet09102002.asp

Be sure to download the sample code too