vb.net - vb net load multiple datagrid at n one form and automatic progress bar -

i have 2 datagrid , 2 button in 1 form..

if click go!, left datagrid filled data..

and if click mining!, surely right datagrid filled..

but problem when click mining button, right datagrid filled, but left datagrid's data automatically unloaded, resulting right datagrid loaded data..

here's screenshot

so need 2 datagrid display data @ same time..

is possible that?

and 1 more question there simple way automatically display progress bar when click mining button, because when clicked it, run executequery took long time completed, it's 10 60 seconds..

so show program not hang, it's still working on progress completed..

only simple circle progress bar do, mean there's no need display estimated time complete.. said before, it's show program working on progress not hang

and way i'm using vb.net , mysql.. before

updated code

if .....  getcmd= "insert node(...) select ..." cmd = new mysqlcommand(getcmd, conn.connect) cmd.executenonquery() cmd.connection.close()  elseif ...     getcmd= "insert node(...) select ..."     cmd = new mysqlcommand(getcmd, conn.connect)     cmd.executenonquery()     cmd.connection.close()  else     getcmd= "insert node(...) select ..."     cmd = new mysqlcommand(getcmd, conn.connect)     cmd.executenonquery()     cmd.connection.close()  end if 

if left grid getting cleared, check code, or post here because not normal, must clearing grid @ somepoint. search code [gridname].datasource = nothing or if using bindingsource, [bindingsourcecontrolname].clear. without more information on how fill grid, cannot give better answer.

as progress bar, need asyncronous call or multi-threading able show progress while making single call executequery. way can still run code while call running. there third-party grids have option built in not standard ms grids.