예제 #1
0
파일: DersBL.cs 프로젝트: hlmyngn/deneme2
        public static bool DersEkle(Ders ders)
        {
            bool eklendi = false;
            MySqlConnection connection = null;
            try
            {
                string connectionString = "SERVER=localhost;DATABASE=OgrenciYonetimSistemi; UID=root;PASSWORD=hy050491;";

                connection = new MySqlConnection(connectionString);

                connection.Open();

                string query = "INSERT INTO ders (Adi) VALUES('" + ders.DersAdi + "')";

                //create command and assign the query and connection from the constructor
                MySqlCommand cmd = new MySqlCommand(query, connection);

                int sonucDeger = cmd.ExecuteNonQuery();
                if (sonucDeger > 0)
                    eklendi = true;

            }
            catch (Exception ex)
            {
                eklendi = false;
            }
            finally
            {
                connection.Close();
            }
            return eklendi;
        }
예제 #2
0
파일: DersEkle.cs 프로젝트: hlmyngn/deneme2
        public void Ders_Ekle()
        {
            Ders ders= new Ders();

            ders.DersAdi = txtDersAdi.Text.Trim();

            DersBL.DersEkle(ders);

            DersGetir();
        }
예제 #3
0
파일: DersBL.cs 프로젝트: hlmyngn/deneme2
        public static List<Ders> DersGetir()
        {
            List<Ders> dersler = new List<Ders>();
            MySqlConnection connection = null;
            try
            {
                string connectionString = "SERVER=localhost;DATABASE=OgrenciYonetimSistemi; UID=root;PASSWORD=hy050491;";
                connection = new MySqlConnection(connectionString);

                connection.Open();
                string query = "SELECT * FROM Ders";

                MySqlCommand cmd = new MySqlCommand(query, connection);
                MySqlDataReader reader = cmd.ExecuteReader();
               // DataTable table = new DataTable();
               // table.Load(reader);

               //for (int i = 0; i < table.Rows.Count; i++)
               // {
               //     string adi = table.Rows[i]["Adi"].ToString();
               // }

                while (reader.Read())
                {
                    Ders ders = new Ders();
                    ders.Id = (int)reader["Id"];
                    ders.DersAdi = reader["Adi"].ToString();
                    dersler.Add(ders);
                }

            }
            catch (Exception ex)
            {

            }
            finally
            {
                connection.Close();
            }
            return dersler;
        }