how to add progress bar during insert records?

Question

how to add progress bar during insert records?

cn.open();
string str;
str ="Insert into tables values ()";
sqlcommand cmd =new sqlcommand(str,cn);
int i =cmd.executenonquery()
if (i>0)
{
// i want progress bar here 
response.write ("record save");
}