public void updatepage(string id, pages pg) { MySqlConnection Connect = new MySqlConnection(ConnectionString); Connect.Open(); string query = "update pages SET pagetitle = '{0}', pagebody = '{1}',pageauthor = '{2}' where pageid = {3};"; query = string.Format(query, pg.Getpagetitle(), pg.Getpagebody(), pg.Getpageauthor(), id); //MySqlConnection Connect = new MySqlConnection(ConnectionString); MySqlCommand cmd = new MySqlCommand(query, Connect); cmd.ExecuteNonQuery(); }
public void addpage(pages pg) { MySqlConnection Connect = new MySqlConnection(ConnectionString); Connect.Open(); string query = "insert into pages(pagetitle,pagebody,pagedate,pageauthor,pagestatus) values('{0}','{1}',now(),'{2}','Published')"; query = string.Format(query, pg.Getpagetitle(), pg.Getpagebody(), pg.Getpageauthor()); MySqlCommand cmd = new MySqlCommand(); cmd = new MySqlCommand(query, Connect); cmd.ExecuteNonQuery(); }