Esempio n. 1
0
        public void xoabv(baiviet bv)
        {
            SqlConnection con = db.Getconnect();

            con.Open();
            SqlCommand cmd = new SqlCommand("Xoabaiviet", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@newsid", System.Data.SqlDbType.Int).Value = bv.Newsid;

            cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
        }
Esempio n. 2
0
        public void suabaiviet(baiviet bv)
        {
            SqlConnection con = db.Getconnect();

            con.Open();
            SqlCommand cmd = new SqlCommand("Suabaiviet", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@newsid", System.Data.SqlDbType.Int).Value          = bv.Newsid;
            cmd.Parameters.Add("@cateID", System.Data.SqlDbType.Int).Value          = bv.Cateid;
            cmd.Parameters.Add("@title", System.Data.SqlDbType.NText).Value         = bv.Title;
            cmd.Parameters.Add("@username", System.Data.SqlDbType.NText).Value      = bv.username;
            cmd.Parameters.Add("@description", System.Data.SqlDbType.NText).Value   = bv.description;
            cmd.Parameters.Add("@content", System.Data.SqlDbType.NText).Value       = bv.content;
            cmd.Parameters.Add("@author", System.Data.SqlDbType.NText).Value        = bv.author;
            cmd.Parameters.Add("@picture", System.Data.SqlDbType.NText).Value       = bv.picture;
            cmd.Parameters.Add("@createdate", System.Data.SqlDbType.DateTime).Value = bv.createdate;
            cmd.Parameters.Add("@link", System.Data.SqlDbType.NText).Value          = bv.link;
            cmd.Parameters.Add("@active", System.Data.SqlDbType.Int).Value          = bv.active;

            cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
        }