MapForums

 
string status;
SqlConnection connection = new SqlConnection("Data Source=localhost;Initial Catalog=TEST;Integrated Security=SSPI; Asynchronous Processing=true");
 
string myQuery = "select postcode, contactid,lastname from customers";
SqlCommand command = new SqlCommand(myQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
int counter = 0;
int[] ids = new int[100];
hashUmsatz.Clear();
hashPlz.Clear();
this.StatusLabel.Visible = true;
try
{
while (reader.Read() && counter < 100)
{
try
{
status = "Processing Postcodes: " + reader.GetString(0) + ", " + reader.GetInt32(1) + ", " + reader.GetString(2);
this.StatusLabel.Text = status;
this.StatusLabel.Refresh();
hashPlz.Add(reader.GetInt32(1), reader.GetString(0));
hashUmsatz.Add(reader.GetInt32(1), reader.GetString(2));
ids[counter] = reader.GetInt32(1);
 
}
catch (Exception)
{
Console.WriteLine("Datensatz fehlerhaft");
}
counter++;
}
}
finally
{
reader.Close();
connection.Close();
 
}