void fill()
{
arvindEntities db = new arvindEntities();
GridView1.DataSource = db.results;
GridView1.DataBind();
}
public void chck()
{
arvindEntities db = new arvindEntities();
var q = from m in db.results
//where m.id == 2
select m;
foreach (var a in q)
{
if ("year" == DropDownList1.SelectedItem.Text && a.results == "year")
{
// Response.Write("<script>alert('y')</script>");
foreach (var b in q)
{
if (b.results == "month" || b.results == "week")
{
Response.Write("<script>alert('yooooooooo')</script>");
}
}
}
if ("month" == DropDownList1.SelectedItem.Text && a.results == "month")
{
foreach (var b in q)
{
if (b.results == "week")
{
Response.Write("<script>alert('m')</script>");
}
}
}
if ("week" == DropDownList1.SelectedItem.Text && a.results == "week")
{
}
}
}
public void delte()
{
try
{
arvindEntities db = new arvindEntities();
List<result> em = db.ExecuteStoreQuery<result>("delete from results").ToList();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Response.Write("<script>alert('Record has Delete')</script>");
fill();
}
public void chck() {
arvindEntities db = new arvindEntities();
var q = from m in db.results
where m.id==1
select m;
foreach (var a in q)
{
//GridView1.DataSource = q;
// GridView1.DataBind();
}
}
void insert()
{
try
{
arvindEntities db = new arvindEntities();
int a;
a = int.Parse(TextBox1.Text);
result em = new result();
em.id = a;
em.results = DropDownList1.SelectedItem.Text;
em.Mark = TextBox2.Text;
em.Attendance = TextBox3.Text;
db.AddToresults(em);
db.SaveChanges();
Response.Write("<script>alert('Record has save')</script>");
fill();
}
catch (Exception e) {
// Response.Write("<script>alert('same primary key insert''" + e.Message + "')</script>");
Console.WriteLine("same primary key insert", e.Message);
}
}
public Default4()
{
db = new arvindEntities();
}