C# Datatable won't update Database

[femgeek]

Hi, I need serious help with a C# winform, I have a dataset with several tables, and I have structured a 3-tier code architecture. My problem is that updates to the database dont work, even though its coded as follows:

public bool AddVideo(int codenumber, string title)
{ 
            //create new VideoRow
            Video.VideosDataTable videosTable = new Video.VideosDataTable();
            Adapter.Fill(videosTable);
            Video.VideosRow videoRow = videosTable.NewVideosRow();
 
            videoRow.CodeNumber = codenumber;
            videoRow.Title = title;
 
            //add the new video
            videosTable.AddVideosRow(videoRow);
            int rowsAffected = Adapter.Update(videosTable);            //return True if row inserted, False if not
            return rowsAffected == 1;
}

Weird thing it shows the data fine on the datagrid each time I press the "addButton", but does not save any changes in the database... once I close the debugger and restart no data has been saved. Anyone know how to fix this?

form.cs looks like this:

private void addButton_Click(object sender, EventArgs e)
        {
            VideosBLL videoLogic = new VideosBLL();
            try
            {
                videoLogic.AddVideo(Int32.Parse(codeBox.Text), titleBox.Text);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message,"Error"
                ,MessageBoxButtons.OK,MessageBoxIcon.Error);
            }
            dataGridView1.DataSource = videoLogic.GetVideos();
        }

[Shashi Sadasivan]

Have you checked the Updatecommand being generated?

you might want to regenerate the update command if you are using xsd files