I'm not familiar with the control, but to communicate with SQL Server:
- define a
SqlCOnnection[
^]
- use proper connection string, refer to
http://www.connectionstrings.com/[
^]
- define a
SqlCommand[
^] to fetch or update/insert the data
- use for example a
SqlDataAdapter to fill a datatable[
^]
- show the fetched event list from the database
- and when you want to save, again: open connection, define a command, define and set the parameters and their values, call command's ExecuteNonQUery
- also use
SqlParameter[
^] in your queries
And when the database operations are done properly (as they should be done) wrap the command executions inside a
SqlTransaction[
^]