how to run progress-bar through insert query ?
- by Gold
hi
i have this insert query:
try
{
Cmd.CommandText = @"INSERT INTO BarcodTbl SELECT * FROM [Text;DATABASE=" + PathI + @"\].[Tmp.txt];";
Cmd.ExecuteNonQuery();
Cmd.Dispose();
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
and i have two question:
how to run progress-bar from the begging to the end of the insert ?
if there any error i got the error exception and the action is stop -
the query stop and the BarcodTbl is empty. how i can see the error and
that the query will continue to fill the table ?
thank's in advance