ASP.NET

		<br />
<br />
		<asp:datagrid id="dgMembers" runat="server" BorderWidth="0px" GridLines="None" BorderStyle="None"<br />
			CellPadding="0" Width="100%" AllowPaging="True" PageSize="15" PagerStyle-Visible="False" AutoGenerateColumns="False"><br />
			<Columns><br />
				<asp:TemplateColumn HeaderText="Name"><br />
					<HeaderStyle Width="70%" CssClass="Grid_HeaderStyle"></HeaderStyle><br />
					<ItemStyle CssClass="Grid_ItemStyle"></ItemStyle><br />
					<ItemTemplate><br />
						<asp:Label id="lblFirstName" Text='<%# DataBinder.Eval(Container.DataItem, "FirstName") %>' runat="server" /><br />
					</ItemTemplate><br />
				</asp:TemplateColumn><br />
				<asp:TemplateColumn HeaderText="Age"><br />
					<HeaderStyle Width="15%" CssClass="Grid_HeaderStyle"></HeaderStyle><br />
					<ItemStyle CssClass="Grid_ItemStyle"></ItemStyle><br />
					<ItemTemplate><br />
						<asp:Label id="lblAge" Text='<%# DataBinder.Eval(Container.DataItem, "Age") %>' runat="server" /><br />
					</ItemTemplate><br />
				</asp:TemplateColumn><br />
			</Columns><br />
			<PagerStyle Visible="False"></PagerStyle><br />
		</asp:datagrid><br />
<br />

<br />
<br />
    Dim dgMembers As DataGrid<br />
    Dim lblFirstName As Label<br />
    Dim lblAge As Label<br />
<br />
    Public Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
<br />
        ' Put user code here to initialize the data source <br />
        ' filling the dataset<br />
        Dim dsMembers As DataSet = New DataSet<br />
        dsMembers = Member.GetAllMembers()<br />
<br />
        'Response.Write(Member.GetAllMembers().ToString)<br />
        dgMembers.DataSource = dsMembers<br />
        dgMembers.DataBind()<br />
<br />
<br />
    End Sub<br />

<br />
        Public Shared Function GetAllMembers() As DataSet<br />
            Return MemberDA.GetAllMembers()<br />
        End Function<br />

<br />
<br />
 Public Shared Function GetAllMembers() As DataSet<br />
<br />
            Dim dsMemberResults As New DataSet<br />
<br />
            ' Create instance of SqlConnection and SqlDataAdapter object<br />
            Dim objConn As SqlConnection = New SqlConnection(Globals.GetConnectionString)<br />
            Dim objCmd As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Members", objConn)<br />
<br />
            Try<br />
<br />
                'Open the connection to the database<br />
                objConn.Open()<br />
<br />
                ' Create and fill a DataSet.<br />
                objCmd.Fill(dsMemberResults)<br />
<br />
            Catch ex As Exception<br />
                Dim strExceptionMsg As String = "Error Executing GetAllMembers(): " + ex.Message + "\r\n"<br />
                Throw New Exception(strExceptionMsg, ex)<br />
            Finally<br />
                'close the connection once retrieving the information is done<br />
                objConn.Close()<br />
            End Try<br />
<br />
            Return dsMemberResults<br />
<br />
        End Function<br />
<br />

private void Page_Load(object sender, System.EventArgs e)
{
	string tableName = "Categories";
	DataSet ds = categoriesDB.LoadCategories(tableName);

	DataList_Categories.DataSource = ds.Tables[tableName];
	DataList_Categories.DataBind();
}