コード例 #1
0
        public void KategorileriGetir(ComboBox liste)
        {
            SqlConnection conn = new SqlConnection(gnl.connStr);
            SqlCommand comm = new SqlCommand("Select * from Kategoriler where silindi = 0", conn);

            if (conn.State == ConnectionState.Closed)
                conn.Open();

            SqlDataReader dr;

            try
            {
                dr = comm.ExecuteReader();
                while (dr.Read())
                {
                    cKategori k = new cKategori();
                    k._kategoriNo = Convert.ToInt32(dr["KategoriNo"]);
                    k._kategoriAd = (dr["KategoriAd"]).ToString();
                    liste.Items.Add(k);
                    //liste.Items.Add(dr["KategoriAd"].ToString());
                }
                dr.Close();
            }
            catch (SqlException ex)
            {
                string hata = ex.Message;
            }
            finally
            {
                conn.Close();
            }
        }
コード例 #2
0
        private void frmUrunler_Load(object sender, EventArgs e)
        {
            this.Top = 0;
            this.Left = 0;
            cKategori k = new cKategori();
            k.KategorileriGetir(cbKategoriler);

            cUrun u = new cUrun();

            DataBagla();

            u.UrunleriGetir(lvUrunler);
            u.KacinciUrun(0);
            Konum();
        }