예제 #1
0
        private void btnCariListeAc_Click(object sender, EventArgs e)
        {
            CariListesi cariList = new CariListesi(1);

            cariList.ShowDialog();
            try
            {
                secilenCari = cariList.passingCari;

                if (secilenCari != null)
                {
                    txtCariKod.Text = secilenCari.Item2;


                    sqlCmd = new SqlCommand("SELECT ADSOYAD, TICARI_UNVAN,  CONCAT(IL, ' / ', ILCE) AS IL_ILCE FROM CARI WHERE CARI_INCKEY=@cari_inckey", Program.connection);
                    sqlCmd.Parameters.AddWithValue("@cari_inckey", secilenCari.Item1);
                    SqlDataReader sqlReader = sqlCmd.ExecuteReader();

                    if (sqlReader.HasRows)
                    {
                        sqlReader.Read();
                        txtCariIsim.Text    = sqlReader["ADSOYAD"].ToString().ToUpper();
                        txtTicariUnvan.Text = sqlReader["TICARI_UNVAN"].ToString().ToUpper();
                        txtIlIlce.Text      = sqlReader["IL_ILCE"].ToString().ToUpper();
                        sqlReader.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                Notification.messageBoxError(ex.Message);
            }
        }
예제 #2
0
        private void btnCariListeAc_Click(object sender, EventArgs e)
        {
            CariListesi cariList = new CariListesi(1);

            cariList.ShowDialog();
            secilenCari     = cariList.passingCari;
            txtCariKod.Text = secilenCari.Item2;
        }
예제 #3
0
        private void cariListeleToolStripMenuItem_Click(object sender, EventArgs e)
        {
            CariListesi cariListe = new CariListesi(0);

            cariListe.Show();
        }