asp.net操作GridView添删改查的两种方法 及 光棒效果
这部份小内容很想写下来了,因为是基础中的基础,但是近来用的比较少,又温习了一篇,发现有点陌生了,所以,还是写一下吧。
方法一:使用Gridview本身自带的事件处理,代码如下(注意:每次操作完都得重新绑定,且删除列要转为模板列):
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ShowCategories(); ShowProducts(); } } private void ShowProducts() { DataTable dt = NorthWind.DBHelp.GetTable("SELECT Product.产品ID, Product.产品名称, Supply.公司名称, Supply.城市, Category.类别名称, Category.图片, Product.单位数量, Product.单价, Product.库存量, Product.中止 FROM Category INNER JOIN Product ON Category.类别ID = Product.类别ID INNER JOIN Supply ON Product.供应商ID = Supply.供应商ID where Product.类别ID="+int.Parse(this.DropDownList1.SelectedValue)); this.GridView1.DataSource = dt; this.GridView1.DataKeyNames = new string[]{"产品ID"};//设置数据操作的主键列 this.GridView1.DataBind(); } private void ShowCategories() { DataTable dt = NorthWind.DBHelp.GetTable("select * from Category"); this.DropDownList1.DataSource = dt; this.DropDownList1.DataTextField = "类别名称"; this.DropDownList1.DataValueField = "类别ID"; this.DropDownList1.DataBind(); } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { ShowProducts(); } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { //将当前要编辑的行的索引告诉GridView this.GridView1.EditIndex = e.NewEditIndex; ShowProducts(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //更新数据库 decimal price = decimal.Parse(((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].FindControl("TextBox1")).Text); int productid = int.Parse(this.GridView1.DataKeys[e.RowIndex].Value.ToString());//获取当前行的主键 //更新到数据库 NorthWind.DBHelp.ExecuteNoQuery("update Product set 单价="+price+" where 产品ID="+productid); //重新绑定 this.GridView1.EditIndex = -1; ShowProducts(); } protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { this.GridView1.EditIndex = -1; ShowProducts(); } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { //删除数据 int productid = int.Parse(this.GridView1.DataKeys[e.RowIndex].Value.ToString());//获取当前行的主键 //更新到数据库 NorthWind.DBHelp.ExecuteNoQuery("delete from Product where 产品ID=" + productid); //重新绑定 this.GridView1.EditIndex = -1; ShowProducts(); } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { //当我们对数据源中的每一行进行数据绑定时触发的事件 if (e.Row.RowType == DataControlRowType.DataRow)//判断绑定时候该行的状态时数据行还是其他类型的模板 { //添加客户端确认 LinkButton lnkDelete = (LinkButton)e.Row.Cells[10].FindControl("lnkDelete"); lnkDelete.Attributes.Add("onclick", "return confirm('你确认删除吗?')"); //光棒效果 e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#ff66cc';"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c"); } } protected void chkSelectAll_CheckedChanged(object sender, EventArgs e) { //获取全选的复选框 CheckBox chkSelectAll = (CheckBox)sender; //获取每一行的复选框 for (int i = 0; i < this.GridView1.Rows.Count; i++) { CheckBox chkSelect = (CheckBox)this.GridView1.Rows[i].Cells[11].FindControl("chkSelect"); //修改状态 chkSelect.Checked = chkSelectAll.Checked; } } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { //告诉GridView当前显示的数据是第几页的数据 this.GridView1.PageIndex= e.NewPageIndex; ShowProducts(); }