I need to create a VB Windows form that contains an updatable datagridview. The tables I have look like this:
Primary_Key: Report_ID (GUID)
Columns: Report_Type (FK), Report_Name, Report_Description, Run_Flag(bit)
Basically, on the datagridview, I want the user to be able to update the record, but I want to show the Report_Type as a drop down, and the Run_Flag as a checkbox. On top of the datagridview, there is a save button, that when clicked, will save all the changes to the database in batch.
How do I do this? I am using Visual Basic 2005 and SQL Server 2005.