近期公司要做新网站,经理让我用.net3.5 C#3.0 做.
研究了一下linq 本人不善言辞,把今天写的代码发出来.
希望和大家一起学习,一起进步.
using
System;
using
System.Configuration;
using
System.Data;
using
System.Linq;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Xml.Linq;
using
System.Text;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
public
partial
class
_Default : System.Web.UI.Page
![](https://i-blog.csdnimg.cn/blog_migrate/a41954a27d6ad96fa2c2cf816e677448.gif)
...
{
public string strCn = ConfigurationManager.ConnectionStrings["textConnectionString"].ConnectionString;
public TestDataContext Dc;
int RecordCount = 0;
int PageCount = 1;
protected void Page_Load(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
Dc = new TestDataContext(strCn);
RecordCount = Dc.student.Count();//得到记录数
PageCount = (int)Math.Ceiling((decimal)RecordCount / 2); //以2条记录为一页,计算总页码
if (!IsPostBack)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
ViewState["page"] = 1;
Bind();
}
}
private void Bind()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
var SkipIndex = (int.Parse(ViewState["page"].ToString()) - 1) * 2; //计算起始索引,以供后面的Skip扩展方法之用
var result = (from temp in Dc.student select temp).Skip(SkipIndex).Take(2);
GridView1.DataSource = result;
GridView1.DataBind();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
GridView1.EditIndex = e.NewEditIndex;
Bind();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
GridView1.EditIndex = -1;
Bind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
int id = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
var temp = Dc.student.Single(t => t.id == id);
Dc.student.DeleteOnSubmit(temp);
Dc.SubmitChanges();
Bind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
int id = int.Parse(GridView1.DataKeys[e.RowIndex].Values.ToString());
string name = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txtname"))).Text;
var temp = Dc.student.Single(t => t.id == id);
temp.name = name;
Dc.SubmitChanges();
GridView1.EditIndex = -1;
Bind();
}
protected void btnsave_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
string name = txtSubName.Text;
student s = new student();
s.name = name;
Dc.student.InsertOnSubmit(s);
Dc.SubmitChanges();
Bind();
txtSubName.Text = "";
}
protected void lbt1_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
LinkButton lb = (LinkButton)sender;
switch (lb.Text)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
case "首页":
ViewState["page"] = 1;
Bind();
break;
case "上一页":
if (int.Parse(ViewState["page"].ToString()) > 1)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{ ViewState["page"] = int.Parse(ViewState["page"].ToString()) - 1; }
else
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{ ViewState["page"] = 1; }
Bind();
break;
case "下一页":
if (int.Parse(ViewState["page"].ToString()) < PageCount )
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{ ViewState["page"] = int.Parse(ViewState["page"].ToString()) + 1; }
else
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{ ViewState["page"] = PageCount ; }
Bind();
break;
case "尾页":
ViewState["page"] = PageCount;
Bind();
break;
default:
break;
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
}
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)