Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)归海一刀published in(发表于) 2014/1/30 1:09:34 动态添加gridview行_[Asp.Net教程]
c#代码:using System;using System.Data;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;using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { BindGrid(); } }
private DataTable ReadGridView() { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add(new DataColumn("ProductID", typeof(string))); dt.Columns.Add(new DataColumn("ProductName", typeof(string))); dt.Columns.Add(new DataColumn("CategoryID", typeof(string))); for (int i = 0; i < this.GridView1.Rows.Count; i++) { dr = dt.NewRow(); dr[0] = this.GridView1.Rows[i].Cells[0].Text.Trim(); dr[1] = this.GridView1.Rows[i].Cells[1].Text.Trim(); dr[2] = this.GridView1.Rows[i].Cells[2].Text.Trim(); dt.Rows.Add(dr); } return dt; } protected void Button1_Click(object sender, EventArgs e) { DataTable dt = ReadGridView(); //this.GridView1.DataSource = dt; //this.GridView1.DataBind(); DataRow row = dt.NewRow(); row.ItemArray = new object[] { "oec2003","oec2003","oec2003" }; dt.Rows.InsertAt(row, 0); dt.AcceptChanges(); this.GridView1.DataSource = dt; this.GridView1.DataBind(); }
private void BindGrid() { string str = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ToString(); using (SqlConnection con = new SqlConnection(str)) { SqlCommand cmd = new SqlCommand("SELECT top 1 [ProductID], [ProductName], [CategoryID] FROM [Products]", con); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); this.GridView1.DataSource = ds.Tables[0].DefaultView; this.GridView1.DataBind(); sda.Dispose(); ds.Dispose(); }
}}
html代码<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
数据库连接字串
下载:AddRow.rar
来源:http://www.cnblogs.com/oec2003
赞