dataset.ApplyCh anges() 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?

DownloadFileDat aSet.DownloadFi leRow MainTableRow =
(DownloadFileDa taSet.DownloadF ileRow)download FileDataSet.Dow nloadFile.NewRo w();
MainTableRow.Da te = DateTime.Now;
MainTableRow.Ro wID = gDownloadFileTa bleGUID;
MainTableRow.Fi leName = sFileName;
MainTableRow.UR L = sSource;
MainTableRow.Fi leSize = iFileLength.ToS tring();
downloadFileDat aSet.DownloadFi le.AddDownloadF ileRow(MainTabl eRow);

//Save the dataset to the database
downloadFileDat aSet.AcceptChan ges();

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

* * * * * * //Save the dataset to the database
* * * * * * downloadFileDat aSet.AcceptChan ges();

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
downloadFileDat aSet.AcceptChan ges();

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( )
{
EndEditOnAllBin dingSources();

tableAdapterMan ager.UpdateAll( scoreDataset);

}
private void EndEditOnAllBin dingSources()
{
var BindingSourcesQ uery =
from Component bindingSources in
this.components .Components
where bindingSources is BindingSource
select bindingSources;

foreach (BindingSource bindingSource in BindingSourcesQ uery)
{
bindingSource.E ndEdit();
}
}