Problem with REFRESH DataGridView

[Christian]

Hi, i TRY to create a windows apllication that insert in a Access DB
name and surname; the Insert istruction Works but the the refresh of
DataGridView doesn't works...
the code is :
public Form1()
{
InitializeCompo nent();
}

#region Variabili
string connString = "Provider=Micro soft.Jet.OLEDB. 4.0;" +
"Data Source=C:\\db1. mdb";
string querySelect = "select * from TabNomi";
string queryDel = "delete * from TabNomi";
DataTable dt = new DataTable();
BindingSource bsource = new BindingSource() ;
#endregion

private void Form1_Load(obje ct sender, EventArgs e)
{
OleDbDataAdapte r Dada = new OleDbDataAdapte r(querySelect,
connString);
OleDbCommandBui lder Cbil = new OleDbCommandBui lder(Dada);
Dada.Fill(dt);

//BindingSource bsource = new BindingSource() ;
bsource.DataSou rce = dt;
dataGridView1.D ataSource = bsource;
}

private void button1_Click(o bject sender, EventArgs e)
{
string queryInsert = "insert INTO TabNomi
VALUES('luca',' pino')";
OleDbDataAdapte r da = new OleDbDataAdapte r(queryInsert,
connString);
OleDbCommandBui lder Cbil = new OleDbCommandBui lder(da);
da.Fill(dt);

//BindingSource s = new BindingSource() ;
bsource.DataSou rce = dt;
dataGridView1.D ataSource = bsource;
}
}

[Marc Gravell]

If it isn't auto-updating, you could call ResetBindings() on the
BindingSource; you could also change the binding (your current lines are
trivial updates - i.e. they don't change anything, so it won't refresh).

Marc

[Christian]

On 22 Apr, 11:14, Marc Gravell <marc.grav...@g mail.comwrote:

If it isn't auto-updating, you could call ResetBindings() on the
BindingSource; you could also change the binding (your current lines are
trivial updates - i.e. they don't change anything, so it won't refresh).

Marc

i put the istruction ResetBindings() but the datagridview don't
refresh...

private void button2_Click(o bject sender, EventArgs e)
{
string queryInsert = "insert INTO TabNomi
VALUES('marco', 'pino')";
OleDbDataAdapte r da = new OleDbDataAdapte r(queryInsert,
connString);
OleDbCommandBui lder Cbil = new OleDbCommandBui lder(da);
da.Fill(dt);

bsource.ResetBi ndings(false);

bsource.DataSou rce = dt;
dataGridView1.D ataSource = bsource;
}

[Marc Gravell]

In that case... are you sure that the DataTable has been updated by the
adapter? Try manually finding (loop or whatever) the record in the "dt"
DataTable; is it there?

Marc

[Christian]

On 22 Apr, 12:39, Marc Gravell <marc.grav...@g mail.comwrote:

In that case... are you sure that the DataTable has been updated by the
adapter? Try manually finding (loop or whatever) the record in the "dt"
DataTable; is it there?

Marc

isee that the DataTable doesn't Update.... but the insert in Access DB
works... :-(