Updating database with datagrid in
This makes it possible to embed script within HTML tags in the text.
If the values for the control come from user input, be sure to validate the values to reduce security vulnerabilities.
When this class is intiated a new Data Set FX is created and adapter which fills the _Time Periods table in the code sinpet below.
What I do not understand is when the button's click event is fired is how to update my database?
Introduction A Data Grid View control can be used to display data from a database.
A table can be displayed from a database in a Data Grid View, using the Data Adapter class and data logic.
Open Visual Studio 2010 and create a Windows Forms Application.
Step 1Create a Windows Forms Application Project, and place a Data Grid View on the form. As: Points of Interest You can insert a row and click the update button; a row in the database will be inserted. There will be a submit button so all the changes will happen at the same time. Any help would be great thanks, Mark Hi Gauthampj, Thanks for the reply. The Object Data Provider as I understand creates an instance of my class Data Provider Time Periods. I want to know how to update the database after the user has finished entering values into the datagrid.From your question, I can see that might be new to working with ADO.NET so I would suggest you do some reading on working with data in .
NET (Data Tables, Data Sets, Data Grids, Data Adapters, Data Binding, ...