SELECT
	exchange_office.id_exchange_office,
	exchange_office.certificate,
	exchange_office.certificate_date,
	cities.city,
	exchange_office.address,
	exchange_office.phone,
	exchange_office.turnover,
	exchange_office.exch_off_type,
	CONVERT(nvarchar(MAX), status.status)
FROM
	exchange_office
LEFT OUTER JOIN cities ON (exchange_office.id_city=cities.id_city)
LEFT OUTER JOIN status ON (exchange_office.status=status.id_status)

                SqlDataReader myReader = null;
                SqlCommand myCommand = new SqlCommand(" SELECT " +
                                                            "exchange_office.id_exchange_office, " +
                                                            "exchange_office.certificate, " +
                                                            "exchange_office.certificate_date, " +
                                                            "cities.city, " +
                                                            "exchange_office.address, " +
                                                            "exchange_office.phone, " +
                                                            "exchange_office.turnover, " +
                                                            "exchange_office.exch_off_type, " +
                                                            "CONVERT(nvarchar(MAX), status.status) AS status " +
                                                        "FROM " +
                                                            "exchange_office " +
                                                        "LEFT OUTER JOIN cities ON (exchange_office.id_city=cities.id_city) " +
                                                        "LEFT OUTER JOIN status ON (exchange_office.status=status.id_status)", sqlConn);
                myReader = myCommand.ExecuteReader();
                if (myReader.HasRows)
                {
                    
                    dataGridView1.Columns.Add("numb", "№");
                    dataGridView1.Columns.Add("certificate", "Рақами сертификат");
                    dataGridView1.Columns.Add("certificate_date", "Рӯзи додани сертификат");
                    dataGridView1.Columns.Add("city", "Шаҳр");
                    dataGridView1.Columns.Add("address", "Суроға");
                    dataGridView1.Columns.Add("phone", "Телефон");
                    dataGridView1.Columns.Add("turnover", "Гардиш");
                    dataGridView1.Columns.Add("exch_off_type", "Намуди нуқта");
                    dataGridView1.Columns.Add("status", "Ҳолат");

                    int i = 1;

                    while (myReader.Read())
                    {
                        dataGridView1.Rows.Add(i, myReader[1], myReader[2], myReader[3], myReader[4], myReader[5], myReader[6], myReader[7], myReader[8]);
                        i = i + 1;
                    }
                    sqlConn.Close();