Tuesday, September 14, 2010

Implementing ProgressBar on Insertion using C#.Net (Windows)

SqlConnection con = new SqlConnection("data source='';initial catalog='';user id='';password=''");
SqlCommand cmd = new SqlCommand();
SqlDataAdapter adap = new SqlDataAdapter();

ProgressBar1.Visible = true;
ProgressBar1.Maximum = dsReadXML.Tables[0].Rows.Count;
ProgressBar1.Value = 0;

for (int i = 0; i < dsReadXML.Tables[0].Rows.Count; i++)
{
ProgressBar1.Value = ProgressBar1.Value + 1;
Application.DoEvents();
cmd.Connection = con;
cmd.CommandText = "insert into table values('dotnetkanna');";
cmd.ExecuteNonQuery();
}

No comments:

 
Feedback Form