gridview的使用代码,Asp.Net代码库,德仔网

代码语言
代码分类
【Asp.Net】 gridview的使用
作者:Dezai.CN / 发布于2011/8/4/ 697
<div>
<p align="left">using System;
<p align="left">using System.Data;
<p align="left">using System.Configuration;
<p align="left">using System.Web;
<p align="left">using System.Web.Security;
<p align="left">using System.Web.UI;
<p align="left">using System.Web.UI.WebControls;
<p align="left">using System.Web.UI.WebControls.WebParts;
<p align="left">using System.Web.UI.HtmlControls;
<p align="left">using System.Data.SqlClient;
<p align="left">
<p align="left">public partial class _Default : System.Web.UI.Page
<p align="left">{
<p align="left">DB db = new DB();
<p align="left">protected void Page_Load(object sender, EventArgs e)
<p align="left">{
<p align="left">if (!IsPostBack)
<p align="left">{
<p align="left">dataBind();
<p align="left">}
<p align="left">}
<p align="left">protected void dataBind()
<p align="left">{
<p align="left">
<p align="left">this.GridView1.DataSource = db.getDs("select * from Tb_Person");
<p align="left">
<p align="left">this.GridView1.DataBind();
<p align="left">}
<p align="left">protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
<p align="left">{
<p align="left">
<p align="left">}
<p align="left">protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
<p align="left">{
<p align="left">this.GridView1.EditIndex = e.NewEditIndex;
<p align="left">dataBind();
<p align="left">}
<p align="left">protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
<p align="left">{
<p align="left">string Id = this.GridView1.DataKeys[e.RowIndex][0].ToString();
<p align="left">string Name = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString();
<p align="left">string Age = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString();
<p align="left">string Sex = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString();
<p align="left">string Address = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString();
<p align="left">string favorite = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text.ToString();
<p align="left">db.exeSql("update Tb_Person set Name='" + Name + "',Age='" + Age + "',Sex='" + Sex + "',Address='" + Address + "',favorite='"+favorite+"' where Id='"+Id+"'");
<p align="left">this.GridView1.EditIndex = -1;
<p align="left">dataBind();
<p align="left">
<p align="left">
<p align="left">}
<p align="left">protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
<p align="left">{
<p align="left">this.GridView1.EditIndex = -1;
<p align="left">dataBind();
<p align="left">}
<p align="left">protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
<p align="left">{
<p align="left">string Id = this.GridView1.DataKeys[e.RowIndex][0].ToString();
<p align="left">db.exeSql("delete Tb_Person where Id='"+Id+"'");
<p align="left">dataBind();
<p align="left">}
<p align="left">protected void btnAdd_Click(object sender, EventArgs e)
<p align="left">{
<p align="left">this.Panel1.Visible = true;
<p align="left">}
<p align="left">protected void btnOk_Click(object sender, EventArgs e)
<p align="left">{
<p align="left">string Name=this.txtName.Text.Trim().ToString();
<p align="left">int Age=Convert.ToInt32 (this.txtAge.Text.Trim());
<p align="left">string Sex=this.txtSex.Text.Trim().ToString();
<p align="left">string Address=this.txtAddress.Text.Trim().ToString();
<p align="left">string favorite=this.txtFav.Text.Trim().ToString();
<p align="left">db.exeSql("insert into Tb_Person(Name,Age,Sex,Address,favorite) values('" + Name + "','" + Age + "','" + Sex + "','" + Address + "','" + favorite + "')");
<p align="left">dataBind();
<p align="left">this.Panel1.Visible = false;
<p align="left">
<p align="left">}
<p align="left">}
<p align="left">

</div>
试试其它关键字
　gridview　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)