<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head>
<title>SQL Demos: Using SELECT ... AS</title>
<link rel="stylesheet" href="/shared/netdemos.css">
<script language="C#" runat="server" src="~/shared/fetchData_sql.cs" />
<script language="C#" runat="server">
protected void Page_Load ( Object Src, EventArgs E ) {
if ( !IsPostBack ) {
string query = "SELECT au_id AS AuthorID, au_lname AS LastName, au_fname AS FirstName, Address, City, State, Zip FROM Authors";
myGrid.DataSource = fetchData ( query );
myGrid.DataBind ( );
}
}
</script>
</head>
<body>
<div class="header"><h2>SQL Demos: Using <b>SELECT ... AS</b></h2></div>
<!-- #include virtual="~/shared/viewsrc_top.inc" -->
<hr size=1 width=92%>
<center>
<form runat="server">
<p id="msg" style="color:#600" enableviewstate=false runat="server" />
<asp:datagrid id="myGrid" runat="server"
width=70% cellpadding=3 font-size="10pt"
datakeyfield="AuthorID">
<headerstyle backcolor="lightsteelblue"
font-size="10pt" font-bold height=25 />
</asp:datagrid>
</form>
</center>
<hr size=1 width=92%>
<!-- #include virtual="~/shared/viewsrc.inc" -->
</body>
</html>