Contents of blistc3.aspx:
<%@ Page Language="C#" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.SqlClient" %> <script runat="server"> void Page_Load(object sender, EventArgs e) { // TODO: Update the ConnectionString and CommandText values for your application string out_text; string strConnect = "server=AUCKLAND;uid=gl001;pwd=11111;database=gl001"; string CommandText = "select * from glmaster"; int row_count; SqlConnection myConnection = new SqlConnection(strConnect); SqlCommand myCommand = new SqlCommand(CommandText, myConnection); myConnection.Open(); DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection); DataGrid1.DataBind(); out_text = "<p>Row Count="; out_text= out_text + DataGrid1.Items.Count.ToString(); DateTime t = DateTime.Now; out_text += "<P>Normal Termination "+t; outResult.InnerHtml = out_text; } </script> <html> <head> </head> <body style="FONT-FAMILY: arial"> <center><table border="1"> <tr> <td><img src="captsm.gif"></td> <td valign="middle" align="center" bgcolor="#aaaaaa"><font face="COMIC SANS MS"><font size="4"> <b>Simple List (Report) Using a Data Grid<br>in c#<hr>for <i>glmaster</i> </td> </tr></table> <form runat="server"> <asp:datagrid id="DataGrid1" runat="server" EnableViewState="False" ForeColor="Black" BackColor="White" CellPadding="3" CellSpacing="1"> <HeaderStyle font-bold="True" forecolor="Black" backcolor="LightSkyBlue"></HeaderStyle> <ItemStyle bordercolor="Blue" backcolor="Azure"></ItemStyle> </asp:datagrid> </form> <div id="outResult" runat="server"></div> </body> </html>
***** end of file *** printed: 48 lines on: 11/23/2009 5:56:49 AM
