Viewing source for Recipe1307cs.aspx
<%@ Page Language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="c#" runat="server">
void Page_Load(){
SqlConnection PubsConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Trusted_Connection=yes");
SqlDataAdapter PubsAdapter = new SqlDataAdapter("select * from Publishers", PubsConnection);
DataSet PubsDataSet = new DataSet();
try{
PubsConnection.Open();
PubsAdapter.Fill(PubsDataSet, "Publishers");
PublisherDataGrid.DataSource = PubsDataSet;
PublisherDataGrid.DataMember = "Publishers";
PublisherDataGrid.DataBind();
}
catch(SqlException PubsException){
PubsExceptionLabel.Text = PubsException.Message;
}
finally{
PubsConnection.Close();
}
}
</script>
<html>
<head>
<title>DataBinding to a DataGrid</title>
</head>
<body>
<asp:DataGrid id="PublisherDataGrid" EnableViewState="false" runat="server" CellSpacing="1" GridLines="None" CellPadding="3" BackColor="White" ForeColor="Black" Font-Size="X-Small" Font-Names="Verdana" HeaderStyle-BackColor="Black" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="True" AlternatingItemStyle-BackColor="LightSteelBlue" ItemStyle-BackColor="#DEDFDE" />
<asp:Label id="PubsExceptionLabel" EnableViewState="false" runat="server" />
</body>
</html>