using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Data.Sql; /// <summary> /// 手动实现GridView的数据插入、更新、排序、删除功能 /// 此作业烦恼我多日,终于完成,功能完全,异常处理也完善了,仅未作SQL注入处理 /// 开发环境 VS2008 ,数据库名:manualDB,表名:student,更换环境,请注意修改表定义和数据库连接串 /// </summary> public partial class _Default : System.Web.UI.Page { /// <summary> /// 页面预载入,初始化排序和数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ViewState["SortOrder"] = "StudentId";//通过视图保存状态 ViewState["OrderDire"] = "ASC"; bind(); } } /// <summary> /// 数据绑定方法,通过视图进行数据的排序 /// </summary> protected void bind() { DataSet ds = new DataSet(); string commandText = "select * from student"; SqlConnection conn = getConn(); SqlDataAdapter sqlad = new SqlDataAdapter(commandText, conn); try { sqlad.Fill(ds, "student"); DataView view = ds.Tables["student"