using System;using System.Data;using System.Configuration;using System.Collections;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 DataViewSelectRow : System.Web.UI.Page...{ protected void Page_Load(object sender, EventArgs e) ...{ if (!IsPostBack) ...{ lblStr.Text = "select * from Products"; DataSet ds = BindSqlServer(lblStr.Text); // GridView1.DataSource = ds; GridView1.DataBind(); } } private DataSet BindSqlServer(string str) ...{ SqlConnection Conn = new SqlConnection("server=.;uid =sa ; pwd=;database = northwind"); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(str, Conn); da.Fill(ds); return ds; } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) ...{ GridView1.PageIndex = e.NewPageIndex; DataSet ds = BindSqlServer("select * from Products"); GridView1.DataSource = ds; GridView1.DataBind(); } protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e) ...{ //注册行单击事件 e.Row.Attributes.Add("onclick", "javascirpt:__doPostBack('GridView1','Select$" + e.Row.RowIndex + "')"); } protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) ...{ Response.Write(GridView1.SelectedValue); //显示单示列的ID //得到ID后将其付给一个变量 lblStr.Text = "select * from products where Productid =" + GridView1.SelectedValue; DataSet ds = new DataSet(); ds = BindSqlServer(lblStr.Text); this.TextBox1.Text = ds.Tables[0].Rows[0]["QuantityPerUnit"].ToString(); }}