Updating The Database From The Dataset

I am having the oddest problem. I can update the data in the dataset, but when I use the update command, or try to do a update manually it will not save the values back to the database.



public void insrtnewtime()

{

int begintime = 00;

int endtime = 23;

int countr;

int _minz;

do

{

begintime = begintime + 1;

string string_begintime_representation = begintime.ToString("00");



//now I have a valid string representations

int _year = 2007;

int _month = 1;

int _day = 1;

int _hour = int.Parse(string_begintime_representation);

_minz = 00;

//need to account for 60 minutes



do

{

//now I need to get a real nice representation to be shown for the visual display

DateTime temptime = new DateTime(_year, _month, _day, _hour, _minz, 0);

//Now I need to strip out just the time, and send it to my stored proc

string stringnewtime_rep_visual = temptime.ToString("t");

string stringnewtime_rep_visual24 = temptime.ToString("HH:mm");



this.tbl_strt_tmesTableAdapter.insrt_strt_times(stringnewtime_rep_visual24, stringnewtime_rep_visual);



_minz += 5;

}

while (_minz < 60);

countr = begintime;

} while (countr < endtime);

this.tbl_strt_tmesTableAdapter.Fill(this.lesson_plannerDataSet.tbl_strt_tmes);

try

{

tbl_strt_tmesTableAdapter.Update(lesson_plannerDataSet.tbl_strt_tmes);//this should save the values

}

catch (Exception e)

{

MessageBox.Show(e.Message);

}









}





the table adapter update, should send the values to the database, but for some reason, it is not. i can see the existing values from the database, along with my new values that i added in my loop, but those values are not being sent to the database when I invoke the update command on the data adapter.

Any help will be greatly appreciated. I am making this program for my wife who is a school teacher.