CafeProject.GarsonEkrani.dataGridView1_CellClick C# (CSharp) Метод

        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            String refKodu = Convert.ToString(dataGridView1.CurrentRow.Cells["refKodu"].Value);
            if (refKodu != "")
            {
                SqlCommand cmd = new SqlCommand("SP_SiparisBilgileri", db.dbConnect());
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@refKodu", SqlDbType.Int).Value = refKodu;
                cmd.ExecuteNonQuery();
                SqlDataReader rdd = cmd.ExecuteReader();
                if (rdd.Read())
                {
                    textBox1.Text = rdd["adi"].ToString();
                    label6.Visible = true;
                    label6.Text = rdd["toplamTutar"].ToString();
                }
                db.dbClose();
                SqlCommand cm = new SqlCommand("SP_OdemeTur", db.dbConnect());
                cm.CommandType = CommandType.StoredProcedure;
                cm.Parameters.Add("@refKodu", SqlDbType.Int).Value = refKodu;
                cm.ExecuteNonQuery();
                SqlDataReader rd = cm.ExecuteReader();

                if (rd.Read())
                {
                    String odeme = rd["odemeTur"].ToString();
                    if (odeme.Equals(""))
                    {
                        label2.Visible = true;
                        label2.Text = "KREDÝ KARTI";

                    }
                    else
                    {
                        label2.Visible = true;
                        label2.Text = "NAKÝT";
                    }

                    db.dbClose();
                }

            }
        }