please tell me the coding how to add progress bar before retrieving the data.

This can be achieved by using the toolbox control statusStrip.
Add a staus strip control to your form then add a progress bar to the items collection of status strip using items collection editor.

You can fulfill your requirement by using the properties of progress bar like maximum, minimum, etc.

Eg.,

ToolStripProgressBar1.Minimum = 1

ToolStripProgressBar1.Maximum = datagridview1.Rows.Count + 1

............................................
Hope this will help you:)

 

This can be achieved by using the toolbox control statusStrip.
Add a staus strip control to your form then add a progress bar to the items collection of status strip using items collection editor.

You can fulfill your requirement by using the properties of progress bar like maximum, minimum, etc.

Eg.,

ToolStripProgressBar1.Minimum = 1

ToolStripProgressBar1.Maximum = datagridview1.Rows.Count + 1

............................................
Hope this will help you:)