private void BindGrid()
{
using (OnlineAdmissionNews entities = new OnlineAdmissionNews())
{
GridView1.DataSource = from NEWS in entities.NEWS.ToList()
select NEWS;
GridView1.DataBind();
}
}
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
int SR_NO = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
using (OnlineAdmissionNews entities = new OnlineAdmissionNews())
{
NEWS news = (from c in entities.NEWS
where c.SR_NO == SR_NO
select c).FirstOrDefault();
if (news != null)
{
entities.NEWS.Remove(news);
entities.SaveChanges();
}
}
this.BindGrid();
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int SR_NO = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
string DATA = (row.FindControl("txtDATA") as TextBox).Text;
using (OnlineAdmissionNews entities = new OnlineAdmissionNews())
{
NEWS news = (from c in entities.NEWS
where c.SR_NO == SR_NO
select c).FirstOrDefault();
news.DATA = DATA;
entities.SaveChanges();
}
GridView1.EditIndex = -1;
this.BindGrid();
}
protected void Insert(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Convert.ToString(txtNewDATA.Text)))
{
using (OnlineAdmissionNews entities = new OnlineAdmissionNews())
{
NEWS news = (from c in entities.NEWS
where c.DATA == txtNewDATA.Text
select c).FirstOrDefault();
if (news == null)
{
NEWS Insert = new NEWS
{
DATA = txtNewDATA.Text
};
entities.NEWS.Add(Insert);
entities.SaveChanges();
}
txtNewDATA.Text = string.Empty;
}
this.BindGrid();
}
}
