gridview.aspx.cs

互联网程序设计的课程

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.Sql;
using System.Data.SqlClient;
using DBClass;
using System.Xml;
using System.Text;
using System.Drawing;
using System.IO;
using System.Web.SessionState;   

public partial class backup_GridView : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection("server=ck;uid=sa;pwd=sa;database=91");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ViewState["SortOrder"] = "ZhouQH";
            ViewState["OrderDire"] = "ASC";
            Bindgrid();
            bs();
        }

    }
    private void bs()

    {
        for (int i = 0; i <= gvtest.Rows.Count - 1; i++)
        {
            int ts = Convert.ToInt32(gvtest.Rows[i].Cells[3].Text);

            if (ts <= 10)
            {
                gvtest.Rows[i].Cells[3].BackColor = System.Drawing.Color.Red;

            }
        }
    
    }

    public void Bindgrid()
    {
        string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
        string strcmd = "select * from ZhouQinfo order by " + sort;
        SqlDataAdapter a = new SqlDataAdapter(strcmd, conn);
        conn.Open();
        DataSet ds = new DataSet();
        a.Fill(ds, "ZhouQinfo");

        gvtest.DataSource = ds.Tables["ZhouQinfo"];
        gvtest.DataBind();
        conn.Close ();
        
       }
       protected void gvtest_PageIndexChanging(object source, System.Web.UI.WebControls.GridViewPageEventArgs e)
       {
           gvtest.PageIndex = e.NewPageIndex;
           Bindgrid();
           bs();
       }

    protected void cbxAll_CheckedChanged(object sender, EventArgs e)
    {
        foreach (GridViewRow gr in gvtest.Rows)
        {
            CheckBox cbx = (CheckBox)gr.FindControl("cbxCheck");
            if (cbx.Checked == false)
            {
                cbx.Checked = true;
            }
            else
            {
                cbx.Checked = false;
            }
        }
    }

    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        string sPage = e.SortExpression;
        if (ViewState["SortOrder"].ToString() == sPage)
        {
            if (ViewState["OrderDire"].ToString() == "Desc")
                ViewState["OrderDire"] = "ASC";
            else
                ViewState["OrderDire"] = "Desc";
        }
        else
        {
            ViewState["SortOrder"] = e.SortExpression;
        }

      Bindgrid();
      bs();

    }


       protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
       {
          gvtest.EditIndex = e.NewEditIndex;
           Bindgrid();

       }

       protected void myGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
       {
          
          
       string sqlstr = "update ZhouQinfo set ZhouQ='"
           + ((TextBox)(gvtest.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "',SheZYY='"
             + ((TextBox)(gvtest.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "'" + "where ZhouQH='" + gvtest.DataKeys[e.RowIndex].Value.ToString() + "'";
       SqlCommand sqlcom = new SqlCommand(sqlstr, conn);
         conn.Open();
           try 
           {
              sqlcom.ExecuteNonQuery();
            }   
       catch (Exception err)
          {
              Response.Write("<script>alert('更新记录失败')</script>");
          }
 
       finally
         {
         conn.Close();
         }
   
           gvtest.EditIndex = -1;
           Bindgrid();
           bs();
       }



       protected void myGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
       {
           gvtest.EditIndex = -1;
           Bindgrid();
           bs();
       }
    protected void GridView1_deleting(object sender,GridViewDeleteEventArgs e)
    {
        string sqlstr = "delete from ZhouQinfo where ZhouQH='" + gvtest.DataKeys[e.RowIndex].Value.ToString() + "'";

        SqlCommand sqlcom = new SqlCommand(sqlstr, conn);
       conn.Open();
        sqlcom.ExecuteNonQuery();
        conn.Close();
        Bindgrid(); 
        bs();

    }

    protected void rowcomand(object sender, GridViewRowEventArgs e)
    {
       int i;
   //执行循环，保证每条数据都可以更新
       for (i = 0; i < gvtest.Rows.Count; i++)
       {
         //首先判断是否是数据行
         if (e.Row.RowType == DataControlRowType.DataRow)
         {
             //当鼠标停留时更改背景色
             e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
            //当鼠标移开时还原背景色
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
       }
    }
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)
        {
            ((LinkButton)e.Row.Cells[7].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除："+ e.Row.Cells[2].Text + "吗?')");
        }
    }

    }



    
}