(C#) ASP.NET Repeater Control - DataSet,DataTable,TableRows

<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<%@ Page Language="C#" Debug="true" %>
<script runat="server">

    void Page_Load(object sender,EventArgs e)
	{
		DataTable dt;

		//*** DataSet To DataTable ***//
		dt = CreateDsToDt();
		
		//*** DataTable ***//
		//dt = CreateDataTable();

		//*** DataSet ***//
		//DataSet ds;
		//ds = CreateDataSet();
		//dt = ds.Tables[0]; //*** Convert DataSet to DataTable ***//

		//*** TableRows ***//
		//dt = DataTableRows();

		//*** BindData to Repeater ***//
		myRepeater.DataSource = dt;
		myRepeater.DataBind();
    }

	
	//*** DataTable ***//
	protected DataTable CreateDataTable()
	{
        System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection();
		System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
		DataTable dt = new DataTable();
       
       
		String strConnString;
		strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + 
		Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
		objConn = new System.Data.OleDb.OleDbConnection(strConnString);
		objConn.Open();

		String strSQL;
		strSQL = "SELECT * FROM customer";
		
		dtAdapter = new System.Data.OleDb.OleDbDataAdapter(strSQL, objConn);
		dtAdapter.Fill(dt);

		dtAdapter = null;

		objConn.Close();
		objConn = null;

		return dt; //*** Return DataTable ***//

	}

	//*** DataSet ***//
	protected DataSet CreateDataSet()
	{
        System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection();
		System.Data.OleDb.OleDbCommand objCmd = new System.Data.OleDb.OleDbCommand(); 
        System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
       
		DataSet ds= new DataSet();
		String strConnString,strSQL;

		strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + 
		Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
		
		strSQL = "SELECT * FROM customer ";
		objConn.ConnectionString = strConnString;

		objCmd.Connection = objConn;
		objCmd.CommandText = strSQL;
		objCmd.CommandType = CommandType.Text;

		dtAdapter.SelectCommand = objCmd;

		dtAdapter.Fill(ds);

		dtAdapter = null;
		objConn.Close();
		objConn = null;

		return ds;   //*** Return DataSet ***//
		
	}

	//*** DataSet to DataTable ***//
	protected DataTable CreateDsToDt()
	{
        System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection();
		System.Data.OleDb.OleDbCommand objCmd = new System.Data.OleDb.OleDbCommand();
        System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
       
		DataSet ds = new DataSet();
		DataTable dt;
		String strConnString,strSQL;


		strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + 
		Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
		strSQL = "SELECT * FROM customer";

		objConn.ConnectionString = strConnString;

		objCmd.Connection = objConn;
		objCmd.CommandText = strSQL;
		objCmd.CommandType = CommandType.Text;

		dtAdapter.SelectCommand = objCmd;

		dtAdapter.Fill(ds);
		dt = ds.Tables[0];

		dtAdapter = null;
		objConn.Close();
		objConn = null;

		return dt;   //*** Return DataTable ***//
		
	}


	
	//*** TableRows (DataTable) ***//
	protected DataTable DataTableRows()
	{
        DataTable dt = new DataTable();
        DataRow dr;
		
		//*** Column ***//
        dt.Columns.Add("CustomerID");
        dt.Columns.Add("Name");
        dt.Columns.Add("Email");
        dt.Columns.Add("CountryCode");
        dt.Columns.Add("Budget");
        dt.Columns.Add("Used");
		
		//*** Rows ***//
		dr = dt.NewRow();
        dr["CustomerID"] = "C001";
        dr["Name"] = "Win Weerachai";
        dr["Email"] = "[email protected]";
        dr["CountryCode"] = "TH";
        dr["Budget"] = "1000000";
        dr["Used"] = "600000";
        dt.Rows.Add(dr);

		//*** Rows ***//
		dr = dt.NewRow();
        dr["CustomerID"] = "C002";
        dr["Name"] = "John Smith";
        dr["Email"] = "[email protected]";
        dr["CountryCode"] = "EN";
        dr["Budget"] = "2000000";
        dr["Used"] = "800000";
        dt.Rows.Add(dr);

		//*** Rows ***//
		dr = dt.NewRow();
        dr["CustomerID"] = "C003";
        dr["Name"] = "Jame Born";
        dr["Email"] = "[email protected]";
        dr["CountryCode"] = "US";
        dr["Budget"] = "3000000";
        dr["Used"] = "600000";
        dt.Rows.Add(dr);
		
		//*** Rows ***//
		dr = dt.NewRow();
        dr["CustomerID"] = "C004";
        dr["Name"] = "Chalee Angel";
        dr["Email"] = "[email protected]";
        dr["CountryCode"] = "US";
        dr["Budget"] = "4000000";
        dr["Used"] = "100000";
        dt.Rows.Add(dr);

		return dt; //*** Return DataTable ***//
	}

</script>
<html>
<head>
<title>ThaiCreate.Com ASP.NET - Repeater</title>
</head>
<body>
	<form id="form1" runat="server">
    <asp:Repeater id="myRepeater" runat="server">
	<HeaderTemplate>
		<table border="1">
			<tr>
				<th>CustomerID</th>
				<th>Name</th>
				<th>Email</th>
				<th>CountryCode</th>
				<th>Budget</th>
				<th>Used</th>
			</tr>
	</HeaderTemplate>
	<ItemTemplate>
		<tr>
			<td align="center"><%# DataBinder.Eval(Container.DataItem, "CustomerID") %></td>
			<td><%# DataBinder.Eval(Container.DataItem, "Name") %></td>
			<td><%# DataBinder.Eval(Container.DataItem, "Email") %></td>
			<td align="center"><%# DataBinder.Eval(Container.DataItem, "CountryCode") %></td>
			<td align="right"><%# DataBinder.Eval(Container.DataItem, "Budget") %></td>
			<td align="right"><%# DataBinder.Eval(Container.DataItem, "Used") %></td>
		</tr>			
	</ItemTemplate>
	<FooterTemplate>
			<!--
			<tr>
				<th>CustomerID</th>
				<th>Name</th>
				<th>Email</th>
				<th>CountryCode</th>
				<th>Budget</th>
				<th>Used</th>
			</tr>
			-->
		</table>
	</FooterTemplate>
	</asp:Repeater>
	</form>
</body>
</html>