(C#) ASP.NET DataList 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 DataList ***//
		myDataList.DataSource = dt;
		myDataList.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 category";
		
		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 category ";
		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 category";

		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("CategoryID");
        dt.Columns.Add("CategoryName");
        dt.Columns.Add("Picture");
		
		//*** Rows ***//
		dr = dt.NewRow();
        dr["CategoryID"] = "1";
        dr["CategoryName"] = "Category 1";
        dr["Picture"] = "images/toy1.gif";
        dt.Rows.Add(dr);

		//*** Rows ***//
		dr = dt.NewRow();
        dr["CategoryID"] = "2";
        dr["CategoryName"] = "Category 2";
        dr["Picture"] = "images/toy2.gif";
        dt.Rows.Add(dr);

		//*** Rows ***//
		dr = dt.NewRow();
        dr["CategoryID"] = "3";
        dr["CategoryName"] = "Category 3";
        dr["Picture"] = "images/toy3.gif";
        dt.Rows.Add(dr);
		
		//*** Rows ***//
		dr = dt.NewRow();
        dr["CategoryID"] = "4";
        dr["CategoryName"] = "Category 4";
        dr["Picture"] = "images/toy4.gif";
        dt.Rows.Add(dr);

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


</script>
<html>
<head>
<title>ThaiCreate.Com ASP.NET - DataList</title>
</head>
<body>
	<form id="form1" runat="server">
	<asp:DataList id="myDataList" RepeatColumns="2" runat="server">
		<HeaderTemplate>
			<b>My Category</b>
		</HeaderTemplate>
		<ItemTemplate>
			<div style="width:100px" align="center">
			<img src="<%# DataBinder.Eval(Container.DataItem, "Picture") %>">
			<br />			
			<%# DataBinder.Eval(Container.DataItem, "CategoryName") %>
			</div>
		</ItemTemplate>
		<SeparatorTemplate>
		<hr />
		</SeparatorTemplate>
	</asp:DataList>
	</form>
</body>
</html>