Database only updates if choose a diffrent row

[brocky]

Database only updates if choose a diffrent row,

I have a datagrid wich is bound to a dataset.
If change now something in the grid an call
the dataadapter to update the database with the dataset
it only updates it if i selected a other row in the datagrid.
It also works ok if i select a diffrent control in my from and than call the update function.

Any ideas how i can do this programmatical?
I tried using i.e. listbox1.Select(), before i call the update
Well that works optical but somehow its diffrent because ths databse
still does not update only if i slect the other control or row by hand.

thanks in advance

here a Code snippet of my datagrid class and jow i call the update


void OnMenuSaveClick(object obj, EventArgs ea)
{
listBox1.Select();
listBox1.AddLog("Es wurde auf Speichern gedrückt");
dataGrid1.SaveCurrentGrid();
}




using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;

namespace ATGParaTool
{
/// <summary>
/// Zusammendfassende Beschreibung für SQLDataGrid.
/// </summary>
public class SQLDataGrid:DataGrid
{
DataSet dataSet = null;
OleDbConnection connection;
OleDbDataAdapter dataAdapter;
OleDbCommandBuilder custCB;

string strTabel;

public SQLDataGrid()
{
}
public void RefreshSQL(string strCaption, string strConnectString, string strSQLString)
{
connection = new OleDbConnection(strConnectString);
dataAdapter = new OleDbDataAdapter(strSQLString, connection);
custCB = new OleDbCommandBuilder(dataAdapter);


dataSet = new DataSet();
DataGridTableStyle dgts = new DataGridTableStyle();
strTabel = strCaption;

dataSet.Clear();
dataAdapter.Fill(dataSet, strCaption);
CaptionText = strCaption;
DataSource = dataSet.Tables[strCaption].DefaultView;

dgts.MappingName = strCaption;
dgts.BackColor = Color.Beige;
dgts.AlternatingBackColor = Color.AliceBlue;


TableStyles.Clear();
TableStyles.Add(dgts);


#region Die Weite der Spalten anpassen
for(int col=0; col < dataSet.Tables[strCaption].Columns.Count; col++)
{
float width = 0;
int numRows = dataSet.Tables[strCaption].Rows.Count;

Graphics g = Graphics.FromHwnd(this.Handle);
StringFormat sf = new StringFormat(StringFormat.GenericTypographic);
SizeF size;

for(int i = 0; i < numRows; ++ i)
{
size = g.MeasureString(this[i, col].ToString(), this.Font, 500, sf);
if(size.Width > width)
width = size.Width + 15;
}

g.Dispose();

this.TableStyles[strCaption].GridColumnStyles[col].Width = (int) width;
}
#endregion

CurrencyManager cm = (CurrencyManager)this.BindingContext[DataSource, DataMember];
((DataView)cm.List).AllowNew = false;
}

public void SaveCurrentGrid()
{

if(dataSet != null)
{
if(dataSet.Tables[strTabel].Rows.Count > 0)
{
dataAdapter.Update(dataSet, strTabel);
}
}
}
}
}