using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page 
{
    SqlConnection oConn;
    SqlCommand cmd;
    SqlDataAdapter sda;
    DataSet ds;
    DataTable dt;
    String SQL;

    protected void Page_Load(object sender, EventArgs e)
    {
        oConn = new SqlConnection("server=sotdev4.tech.purdue.edu;uid=xxx;pwd=yyy;database=zzz");
        SQL = "SELECT FileName FROM Image";

        cmd = new SqlCommand(SQL, oConn);

        sda = new SqlDataAdapter();
        sda.SelectCommand = cmd;

        ds = new DataSet("Image");
        sda.Fill(ds);

        dt = new DataTable();
        dt = ds.Tables[0];

        int i = 0;

        if (dt.Rows.Count == 0)
        {
            Response.Write("No Data!");
        }
        else
        {
            for (i = 0; i < dt.Rows.Count; i++)
            {
                Response.Write(dt.Rows[i][0].ToString()+"<br />");
            }
        }
    }
}