SqlCommand UpdateCmd = new SqlCommand("MyStoredProcedure", conn);
UpdateCmd.CommandType = CommandType.StoredProcedure;
while((templine = tr.ReadLine()) != null)
{
conn.Open();
UpdateCmd.Parameters.AddWithValue("@IDNumber", templine);
UpdateCmd.ExecuteNonQuery();
//this is the point at which I need to Wait for the Nonquery to finish.. How?
conn.Close();
}