protected void Page_Load(object sender, EventArgs e)
{
string pid = Request.QueryString["pageid"];
Database db = new Database();
if (Page.IsPostBack)
{
Page.Validate();
if (Page.IsValid)
{
pages pg = new pages();
pg.Setpagetitle(page_title.Text.ToString());
pg.Setpagebody(page_body.Text.ToString());
pg.Setpageauthor(page_author.Text.ToString());
db.updatepage(pid, pg);
Response.Redirect("Default.aspx");
}
}
List <Dictionary <String, String> > rs = db.searchpage(pid);
foreach (Dictionary <String, String> row in rs)
{
page_title.Text = row["pagetitle"];
page_body.Text = row["pagebody"];
page_author.Text = row["pageauthor"];
}
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
Page.Validate();
if (Page.IsValid)
{
Database db = new Database();
pages pg = new pages();
pg.Setpagetitle(page_title.Text.ToString());
pg.Setpagebody(page_body.Text.ToString());
pg.Setpageauthor(page_author.Text.ToString());
db.addpage(pg);
Response.Redirect("Default.aspx");
}
}
}
