datagrid-open.aspx.cs using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient; namespace study { /// <summary> /// datagrid_open 的摘要说明。 /// </summary> public class datagrid_open : System.Web.UI.Page { protected System.Web.UI.WebControls.DataGrid DataGrid1; protected System.Web.UI.HtmlControls.HtmlForm Form1; #region User Defined Code private void Page_Load(object sender, System.EventArgs e) { if ( ! this.IsPostBack ) this.BindData(); }
protected void BindData() { SqlCommand cmd = new SqlCommand( "SELECT TOP 10 ProductID, ProductName FROM Products", con("Server=dwserver; DataBase=Northwind; User Id=sa; Password=123456")); this.DataGrid1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection); this.DataGrid1.DataBind(); } protected SqlConnection con(System.String ConnectionString ) { SqlConnection c = new SqlConnection( ConnectionString ); c.Open(); return c; } #endregion
#region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } #endregion } }
datagrid_show.aspx.cs using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient; namespace study { /// <summary> /// datagrid_show 的摘要说明。 /// </summary> public class datagrid_show : System.Web.UI.Page { protected System.Web.UI.WebControls.DataGrid DataGrid1; #region User Defined Code private void Page_Load(object sender, System.EventArgs e) { if ( ! this.IsPostBack ) this.BindData(); }
protected void BindData() { SqlCommand cmd = new SqlCommand( "SELECT * FROM Products WHERE ProductID = @ProductID", con("Server=dwserver; DataBase=Northwind; User Id=sa; Password=123456")); cmd.Parameters.Add(new SqlParameter("@ProductID", SqlDbType.VarChar, 200)); cmd.Parameters["@ProductID"].Value = Request["ProductID"].ToString(); this.DataGrid1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection); this.DataGrid1.DataBind(); }
protected SqlConnection con(System.String ConnectionString ) { SqlConnection c = new SqlConnection( ConnectionString ); c.Open(); return c; } #endregion
#region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } #endregion } }