public partial class _Default : System.Web.UI.Page { private SqlConnection Conn; GridView Grid; override protected void OnInit(EventArgs e) { Conn = new SqlConnection( ConfigurationManager.ConnectionStrings["MyDBConnectionString"].ConnectionString ); Conn.Open(); Grid = new GridView(); Grid.AutoGenerateColumns = false; CommandField Command = new CommandField(); Command.ShowEditButton = true; Grid.Columns.Add(Command); BoundField Boundf = new BoundField(); Boundf.DataField = "FamilyName"; Grid.Columns.Add(Boundf); SqlDataSource DataSource = new SqlDataSource( ConfigurationManager.ConnectionStrings["MyDBConnectionString"].ConnectionString, "SEL ECT FamilyName FR OM Samples"); Grid.DataSource = DataSource; Grid.DataBind(); this.Form.Controls.Add(this.Grid); } protected void Page_Load(object sender, EventArgs e) { this.DataBind(); }
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Interface<title> <head> <body> <fo rm id="Form" runat="server"> <div> <asp:GridView ID="MyGridView" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" CellPadding="3" DataSourceID="SqlDataSourceMyDB"> <Columns> <asp:BoundField DataField="NumberInFamily" HeaderText="NumberInFamily" SortExpression="NumberInFamily" /> <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" /> <asp:CommandField ShowEditButton="True" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSourceMyDB" runat="server" ConnectionString="<%$ ConnectionStrings:MyDBConnectionString %>" SelectCommand="SELECT FamilyName Id FR OM Samples"> </asp:SqlDataSource> </div> <form> <body> <html>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)