GridView全选,反选,取消编辑,删除,JavaScript控制

JS部分:

//  全选
  function CheckAll()
   ...{
   var GridView1 = document.getElementById("<%=GridView1.ClientID %>");
   for(i = 1;i < GridView1.rows.length; i++)
    ...{
     GridView1.rows[i].cells[0].getElementsByTagName("INPUT")[0].checked = true;
     GridView1.rows[i].className= "TDC";
    }
   }
//  取消选择
  function CancelAll()
  ...{
   var GridView1 = document.getElementById("<%=GridView1.ClientID %>");
   for(i = 1;i < GridView1.rows.length; i++)
    ...{
     GridView1.rows[i].cells[0].getElementsByTagName("INPUT")[0].checked = false;
     GridView1.rows[i].className= "TDCNONE";
    }
  }
//  反选
  function FanCheckAll()
  ...{
   var GridView1 = document.getElementById("<%=GridView1.ClientID %>");
   for(i = 1;i < GridView1.rows.length; i++)
    ...{
     if(GridView1.rows[i].cells[0].getElementsByTagName("INPUT")[0].checked == true)
     ...{
     GridView1.rows[i].cells[0].getElementsByTagName("INPUT")[0].checked = false;
     GridView1.rows[i].className= "TDCNONE";
     }
     else
     ...{
     GridView1.rows[i].cells[0].getElementsByTagName("INPUT")[0].checked = true;
     GridView1.rows[i].className= "TDC";
     }
    }
  }
//  选种行变换
  function Tcheck(obj)
  ...{
    var objin=obj.parentElement.parentElement;

    if(objin.className== "TDC")
    objin.className= "TDCNONE"
    else
    objin.className= "TDC"
  }

 

C#部分:

 

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class _Default : System.Web.UI.Page 
...{
    protected void Page_Load(object sender, EventArgs e)
    ...{
        if (!IsPostBack)
        ...{
            BindView();
        }
    }

    private void BindView()
    ...{
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);
        DataSet ds = new DataSet();
        conn.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select ProductID,ProductName,UnitPrice=convert(decimal(10,2),UnitPrice),UnitsOnOrder from Products", conn);
        sda.Fill(ds);
        conn.Close();
        GridView1.DataSource = ds;
        GridView1.DataBind();

        foreach (GridViewRow gr in GridView1.Rows)
        ...{
            CheckBox cb = (CheckBox)gr.FindControl("CheckBox1");
            cb.Attributes["onclick"] = "Tcheck(this)";
        }
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    ...{
        GridView1.EditIndex = e.NewEditIndex;
        BindView();

    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    ...{
        GridView1.EditIndex = -1;
        BindView();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    ...{
        int prdID = int.Parse(GridView1.DataKeys[e.RowIndex]["ProductID"].ToString());
        string prdName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text.ToString();
        float prdprice = float.Parse(((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text);
        int prdNumber = int.Parse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3")).Text.ToString());

        string prdSql = "UPDATE Products SET ProductName= '" + prdName + "',UnitPrice=" + prdprice + ",UnitsOnOrder=" + prdNumber + " WHERE ProductID=" + prdID;

        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);
        conn.Open();
        SqlCommand com = new SqlCommand(prdSql, conn);
        com.ExecuteNonQuery();
        conn.Close();
        GridView1.EditIndex = -1;
        BindView();
    }
    protected void Button1_Click(object sender, EventArgs e)
    ...{
        foreach (GridViewRow gr in GridView1.Rows)
        ...{
            CheckBox cb = (CheckBox)gr.FindControl("CheckBox1");
            cb.Checked = true;
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    ...{
        foreach (GridViewRow gr in GridView1.Rows)
        ...{
            CheckBox cb = (CheckBox)gr.FindControl("CheckBox1");
            if (cb.Checked == true)
            ...{

                int prdID = int.Parse(gr.Cells[1].Text);
                string prdSql = "DELETE FROM Products WHERE ProductID=" + prdID;
                Response.Write(prdSql);
                SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);
                conn.Open();
                SqlCommand com = new SqlCommand(prdSql, conn);
                com.ExecuteNonQuery();
                conn.Close();
                GridView1.EditIndex = -1;
                BindView();
            }
        }
    }
}