gridView的使用

using System;

using System.Collections.Generic;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Configuration;

namespace WebSite.CourseManager

{

    public partial class CourseList : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            //判斷回調

            if (!IsPostBack)

            {

                ViewState["Item"] = "CourseID";

                ViewState["Sort"] = "ASC";

                GridBind();

            }

        }

        //獲得連接配接

        private SqlConnection GetConnection()

            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionStr"].ToString());

            conn.Open();

            return conn;

        //綁定資料源

        private void GridBind()

            DataView dv = new DataView();

            dv = Course.DefaultView;

            dv.Sort = ViewState["Item"].ToString() + " " + ViewState["Sort"];

            GridView1.DataKeyNames = new string[] { "CourseID" };

            GridView1.DataSource = dv;

            GridView1.DataBind();

        //表屬性

        private DataTable Course

            get

                if (ViewState["Course"] == null)

                {

                    SqlConnection conn = GetConnection();

                    SqlCommand cmd = conn.CreateCommand();

                    cmd.CommandText = "select * from Course";

                    DataSet ds = new DataSet();

                    DataTable dt = new DataTable();

                    SqlDataAdapter sda = new SqlDataAdapter(cmd);

                    sda.Fill(ds, "Course");

                    dt = ds.Tables["Course"];                   

                    ViewState["Course"] = dt;

                    conn.Close();

                    return dt;

                }

                else

                    return (DataTable)ViewState["Course"];

            set

                ViewState["Course"] = (DataTable)value;

        //排序

        protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)

            if (e.Sort..ToString().Trim() == ViewState["Item"].ToString().Trim())

                if (e.SortDirection.ToString().Trim() == "ASC")

                    ViewState["Sort"] = "DESC";

                    ViewState["Sort"] = "ASC";

            else

                ViewState["Item"] = e.Sort.;

            GridBind();

        //分頁

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

            GridView1.PageIndex = e.NewPageIndex;

        //光捧

        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

            if (e.Row.RowType == DataControlRowType.DataRow)

                e.Row.Attributes.Add(" "c=this.style.backgroundColor;this.style.backgroundColor='green'");

                e.Row.Attributes.Add(" "this.style.backgroundColor=c");

                if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)

                    Image img = (Image)e.Row.Cells[2].Controls[0];

                    img.Attributes.Add(" "if(confirm('你确實要删除!" + e.Row.Cells[1].Text.ToString() + "') == false) return false");

                    //e.Row.Cells[2].Attributes.Add(" ".:return confirm(' 你确實要删除!" + e.Row.Cells[1].Text.ToString() + "')");

        //删除事件

        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

           string id= GridView1.Rows[e.RowIndex].Cells[0].Text.ToString();

           SqlConnection conn = GetConnection();

           SqlCommand cmd = conn.CreateCommand();

           cmd.CommandText = "delete from Course where CourseID='" + id+"'";

           cmd.ExecuteNonQuery();

           ViewState["Course"] = null;

           GridBind();

           conn.Close();

        //編輯事件

        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

            string name = GridView1.Rows[e.NewEditIndex].Cells[0].Text.ToString();

            string content = GridView1.Rows[e.NewEditIndex].Cells[1].Text.ToString();

            Response.Redirect("CourseUpdate.aspx?name="+name+"&content="+content);

        //選擇事件

        protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)

            string name = GridView1.Rows[e.NewSelectedIndex].Cells[0].Text.ToString();

            Response.Redirect("/CourseInClassManager/CourseInClass.aspx?name="+name);

        //轉向課程增加頁面

        protected void btnAdd_Click(object sender, EventArgs e)

            Response.Redirect("CourseAdd.aspx");

    }

}