Cacher is the code snippet organizer for pro developers

            string connectionString = Settings.Default.DynamicsConnectionString;
            using (connectionString)
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.Connection = connection;
                cmd.Parameters.Add("@division",SqlDbType.NVarChar).Value = DDLDivision.SelectedValue;
                cmd.Parameters.Add("@line", SqlDbType.Int).Value = DDLLine.SelectedValue;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "sp_GetTankNumber";

                SqlDataReader reader = null;

                try
                {
                    connection.Open();
                    reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        DDLTank.Items.Add(reader["TankNumber"].ToString());

                    }

                }
                catch (SqlException)
                {


                }
                catch (Exception ex)
                {

                }
                finally
                {
                    connection.Close();
                    cmd.Dispose();
                    connection.Dispose();
                }
            }
        }