TRy This
string strConn = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString.ToString();
SqlConnection con = new SqlConnection(strConn);
ArrayList ar = new ArrayList();
SqlCommand cmd = new SqlCommand("select * from Test", con);
/SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
dt.Clear();
con.Open();
da.Fill(dt);
con.Close();
//Below code i bind first column values in arraylist
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
ar.Add(dt.Rows[i][1].ToString());
}
///Write in page
/foreach (object eachelt in ar)
{
//Display Content Which u want to display
}