سلام شما میتونید از کدی شبیه به این کد استفاده کنید:
private int Rowscount;
readonly DataTable dt = new DataTable();
private void button1_Click(object sender, EventArgs e)
{
var cnn = new SqlConnection(@"Data Source=.\sqlexpress;initial catalog=shop;integrated security=true;");
var cmd = new SqlCommand("select * from TblProducts", cnn);
var cmdForCount = new SqlCommand("select count(*) from TblProducts", cnn);
cnn.Open();
Rowscount = Convert.ToInt32(cmdForCount.ExecuteScalar());
progressBar1.Maximum = Rowscount;
var ad = new SqlDataAdapter(cmd);
dt.RowChanged += dt_RowChanged;
ad.Fill(dt);
cnn.Close();
dataGridView1.DataSource = dt;
}
private void dt_RowChanged(object sender, DataRowChangeEventArgs e)
{
if (e.Action == DataRowAction.Add)
{
progressBar1.Value += 1;
}
rowCouter = dt.Rows.Count;
}