Gridview实现添加更新及鼠标移动事件

最新推荐文章于 2015-11-06 14:39:23 发布

buguzl1

最新推荐文章于 2015-11-06 14:39:23 发布

阅读量576

点赞数

文章标签： string textbox object asp dataset server

本文链接：https://blog.csdn.net/buguzl1/article/details/4239644

版权

using System.Data.SqlClient;

public partial class gridview添加删除更新 : System.Web.UI.Page
{
//string c;
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString);

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            databind();
        }
    }
   private void databind()
    {
        cn.Open();
        string str= "select u_id,u_name,u_sex,u_age from users";
        SqlDataAdapter sda = new SqlDataAdapter(str, cn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "users");
        GridView1.DataSource = ds.Tables ["users"].DefaultView ;
        GridView1.DataBind();
        cn.Close();
    }

   protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
   {
       this.GridView1.PageIndex = e.NewPageIndex;
       databind();

   }
   protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
   {
       string id = this.GridView1.DataKeys[e.RowIndex][0].ToString();
       string name = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text .ToString ();
       string sex = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text .ToString();
       string age = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text .ToString();
       update(id,name, sex, age);
           this .GridView1 .EditIndex =-1;
       databind ();

   }
   public void update(string u_id, string u_name, string u_sex, string u_age)
   {
       cn.Open();
       SqlCommand cmd = new SqlCommand("update users set u_name='" + u_name + "',u_sex='" + u_sex + "',u_age='" + u_age + "' where u_id='"+u_id +"'",cn );
       cmd.ExecuteNonQuery();
       cn.Close();
   }
   protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
   {
       this.GridView1.EditIndex = -1;
       databind();
   }
   protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
   {

   }
   protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
   {
       this.GridView1.EditIndex = e.NewEditIndex;
       databind();
   }
   protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
   {
       if (e.Row.RowType == DataControlRowType.DataRow)
       {
           e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00ffee';");
           e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");
       }
   }
}