DataGrid应用

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindToDataGrid();
        }

    }
    private void BindToDataGrid()
    {
        SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=;database=northwind");
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from employees",con);
        DataSet ds = new DataSet();
        sda.Fill(ds,"emp");
        DataGrid1.DataKeyField = "employeeid";
        DataGrid1.DataSource=ds.Tables["emp"];
        DataGrid1.DataBind();
    }
    protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            e.Item.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#6699ff'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
            ((LinkButton)(e.Item.Cells[6].Controls[0])).Attributes.Add("onclick","return confirm('确认删除？')");
        }
        //BindToDataGrid();
    }
    protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        DataGrid1.CurrentPageIndex = e.NewPageIndex;
        BindToDataGrid();
    }
    protected void DataGrid1_SortCommand(object source, DataGridSortCommandEventArgs e)
    {
        if (ViewState["order"] == null)
        {
            ViewState["order"] = "ASC";
        }
        else
        {
            if (ViewState["order"].ToString() == "ASC")
            {
                ViewState["order"] = "DESC";
            }
            else { ViewState["order"] = "ASC"; }
        }
        SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=;database=northwind");
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from employees", con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "emp");
        ds.Tables["emp"].DefaultView.Sort = e.SortExpression + " " + ViewState["order"].ToString();
        DataGrid1.DataSource = ds.Tables["emp"].DefaultView;
        DataGrid1.DataBind();

    }
    protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        string empid = DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
        Response.Write("<script>alert('"+empid+"')</script>");

        //执行删除命令
    }
    protected void DataGrid1_ItemCommand(object source, DataGridCommandEventArgs e)
    {

    }
    protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e)
    {
        DataGrid1.EditItemIndex= e.Item.ItemIndex;
        BindToDataGrid();
    }
    protected void DataGrid1_CancelCommand(object source, DataGridCommandEventArgs e)
    {
        DataGrid1.EditItemIndex = -1;
        BindToDataGrid();
    }
    protected void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e)
    {
        string id = DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
        string lastname = ((TextBox)(e.Item.Cells[2]).Controls[0]).Text;
        Response.Write("<script>alert('" + lastname + "')</script>");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        foreach (DataGridItem dl in DataGrid1.Items)
        {
            CheckBox chk = (CheckBox)dl.FindControl("CheckBox1");
            if (chk.Checked)
            {
                Response.Write("<script>alert('" + dl.Cells[1].Text+ "')</script>");
            }
        }
    }