protected void Button1_Click(object sender, EventArgs e) { if (TextBox_title.Text.Length == 0) { lbl_info.ForeColor = Color.Red; lbl_info.Text = "Please enter new title!"; return; } else if (TextBox_content.Text.Length == 0) { lbl_info.ForeColor = Color.Red; lbl_info.Text = "Please enter new content!"; return; } tbl_New nw = new tbl_New(); nw.Title = TextBox_title.Text; nw.NewContent = TextBox_content.Text; nw.Date = DateTime.Now; lbl_info.ForeColor = Color.Green; lbl_info.Text = "New added Successfully!"; db.tbl_News.InsertOnSubmit(nw); db.SubmitChanges(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["nid"] != null) { tbl_New ne = new tbl_New(); var item = from u in db.tbl_News where u.NewID == int.Parse(Request.QueryString["nid"]) select u; foreach (var z in item) { db.tbl_News.DeleteOnSubmit(z); } db.SubmitChanges(); } } }
partial void Deletetbl_New(tbl_New instance);
partial void Updatetbl_New(tbl_New instance);
partial void Inserttbl_New(tbl_New instance);