예제 #1
0
        public void EditBaiHat(QLBaiHat strBH)
        {
            string        sql = "UPDATE BaiHat SET MaBH = N'" + strBH.MaBH + "',TenBH =N'" + strBH.TenBH + "',TacGia = N'" + strBH.TacGia + "'WHERE Id=" + strBH.ID;
            SqlConnection con = db.getConnection();
            SqlCommand    cmd = new SqlCommand(sql, con);

            con.Open();
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
        }
예제 #2
0
        public void Delete(QLBaiHat strBH)
        {
            string        sql = "DELETE FROM BaiHat WHERE Id =" + strBH.ID;
            SqlConnection con = db.getConnection();
            SqlCommand    cmd = new SqlCommand(sql, con);

            con.Open();
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
        }
예제 #3
0
        public void AddBaiHat(QLBaiHat strBH)
        {
            string sql = "INSERT INTO BaiHat(MaBH,TenBH,TacGia) VALUES(N'" + strBH.MaBH + "',N'" + strBH.TenBH + "',N'" + strBH.TacGia + "')";
            //Tao ket noi csdl
            SqlConnection con = db.getConnection();
            SqlCommand    cmd = new SqlCommand(sql, con);

            con.Open();
            cmd.ExecuteNonQuery(); //chay cau lenh truy van cmd
            cmd.Dispose();
            con.Close();
        }
예제 #4
0
        //phuowng thuc lay du lieu tu csdl
        public List <QLBaiHat> getBaiHat(string ID)
        {
            string sql;

            if (string.IsNullOrEmpty(ID))
            {
                sql = "SELECT * FROM BaiHat";
            }
            else
            {
                sql = "SELECT * FROM BaiHat WHERE ID = " + ID;
            }
            List <QLBaiHat> strList = new List <QLBaiHat>();
            SqlConnection   con     = db.getConnection();
            SqlDataAdapter  cmd     = new SqlDataAdapter(sql, con);

            DataTable dt = new DataTable();

            //Mo ket noi;

            con.Open();   // mo ket noi
            cmd.Fill(dt); // do toan bo du lieu truy van duoc vao DataTable

            //dong ket noi
            cmd.Dispose(); //ngat cau lenh do du lieu vao cmd.fill(dt);
            con.Close();

            QLBaiHat strBH;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                strBH        = new QLBaiHat();
                strBH.ID     = Convert.ToInt32(dt.Rows[i]["Id"].ToString());
                strBH.MaBH   = dt.Rows[i]["MaBH"].ToString();
                strBH.TenBH  = dt.Rows[i]["TenBH"].ToString();
                strBH.TacGia = dt.Rows[i]["TacGia"].ToString();

                strList.Add(strBH);
            }
            return(strList);
        }