Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Progress Bar on Moving Table Data

Posted on 2009-07-06
2
Medium Priority
?
640 Views
Last Modified: 2012-05-07
I try to include a progress bar while moving data from one server table to another table in another server. So i had the following code testing out,


wondering if / will the progress bar being execute based on the completion of data transfer where i put within the code bolded?  ??

string query  = ...;
string conn = ...;
string conn2 = ...;
static int recordcount = 0;
SqlDataReader reader;
 
this.pbar1 = new System.Winforms.ProgressBar();
pbar1.Visible = true;
pbar1.Maximum = recordcount;
pbar1.Minimum = 1;
pbar1.Value = 1;
pbar1.Step = 1;
 
using (reader = new SqlCommand(query, conn).ExecuteReader())
{
          if (reader.HasRows)
          {
                 recordcount = reader.Count;    
 
                 while (reader.Read())
                 {
                        string id = reader.GetString(reader.GetOrdinal("SalesID"));
                        ..
 
                        using (SqlConnection con = new SqlConnection(conn2))
                        {
                                 con.Open();
                                 try
                                 {
                                        using (SqlCommand command = new SqlCommand("INSERT INTO saletable VALUES(@saleid, @saletotal , @saledatetime)", con))
                                        {
                                                  command.Parameters.Add(new SqlParameter("saleid", id));
                                                  ...
                                        command.ExecuteNonQuery();
                                        pbar1.performStep();
                                        }
                                  }
                                  catch
                                  {
                                  }
 
                         }
                        
}

Open in new window

0
Comment
Question by:doramail05
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
ShazbotOK earned 1000 total points
ID: 24787407
To accuratly set the progress bar you need to 1st set the max value on the progress bar... so when you perform the reader.Count set that to the progress bar so it knows what is considered 100%
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question