dataset.ApplyChanges() not taking effect.

[=?Utf-8?B?Z3JlYXRiYXJyaWVyODY=?=]

Here is my code.

Does anyone know why when i reopen the table to view the data, none of the
rows have been written?

DownloadFileDataSet.DownloadFileRow MainTableRow =
(DownloadFileDataSet.DownloadFileRow)downloadFileD ataSet.DownloadFile.NewRow();
MainTableRow.Date = DateTime.Now;
MainTableRow.RowID = gDownloadFileTableGUID;
MainTableRow.FileName = sFileName;
MainTableRow.URL = sSource;
MainTableRow.FileSize = iFileLength.ToString();
downloadFileDataSet.DownloadFile.AddDownloadFileRo w(MainTableRow);

//Save the dataset to the database
downloadFileDataSet.AcceptChanges();

[Ignacio Machin ( .NET/ C# MVP )]

* * * * * * //Save the dataset to the database
* * * * * * downloadFileDataSet.AcceptChanges();

IIRC AcceptChanges do not save the changes to the DB, only to the
dataset in memory

[=?Utf-8?B?Z3JlYXRiYXJyaWVyODY=?=]

How do i save the changes to the DB?

"Ignacio Machin ( .NET/ C# MVP )" wrote:

>

//Save the dataset to the database
downloadFileDataSet.AcceptChanges();

IIRC AcceptChanges do not save the changes to the DB, only to the
dataset in memory

[Ken Foskey]

On Mon, 21 Jul 2008 13:28:16 -0700, greatbarrier86 wrote:

How do i save the changes to the DB?

I had exactly the same problem ended up with:

internal void UpdateDatabase()
{
EndEditOnAllBindingSources();

tableAdapterManager.UpdateAll(scoreDataset);

}
private void EndEditOnAllBindingSources()
{
var BindingSourcesQuery =
from Component bindingSources in
this.components.Components
where bindingSources is BindingSource
select bindingSources;

foreach (BindingSource bindingSource in BindingSourcesQuery)
{
bindingSource.EndEdit();
}
}