Пример #1
0
        private void DeleteToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");

            database.deleteData("customerID=" + Id, "MusteriBilgileriTablosu");
            dataRefresh();
        }
Пример #2
0
        public DataTable deleteData(string productType, string productId)
        {
            VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");

            if (productType == "1")
            {
                database.deleteData("productId=" + productId, "kitapBilgileriTablosu");
            }
            else if (productType == "2")
            {
                database.deleteData("productId=" + productId, "CdBilgileriTablosu");
            }
            else if (productType == "3")
            {
                database.deleteData("productId=" + productId, "MagazineBilgileriTablosu");
            }
            else
            {
                System.Windows.Forms.MessageBox.Show("invalid product type");
            }
            database.deleteData("productId=" + productId, "UrunlerTablosu");
            return(database.veriCek("SELECT * FROM UrunlerTablosu"));
        }