As Visual Foxpro programmer I am thinking to make the transition to .NET but I am having problems to result some basic issues of Database programming, I am just two weeks busy.

Can anyone please tell me how can I save data at the end of my application, I a trying this Function without success

private void SaveData()
{
this.Validate();
this.weatherRecordBindingSource.EndEdit();
this.weatherRecordTableAdapter.Update (this.database1DataSet.WeatherRecord);
Database1DataSet.WeatherRecordDataTable tablechanges =
database1DataSet.WeatherRecord.GetChanges(
DataRowState.Added | DataRowState.Modified)
as Database1DataSet.WeatherRecordDataTable;
if (tablechanges != null)
{
weatherRecordTableAdapter.Update(tablechanges);
}
database1DataSet.AcceptChanges();
}