How do I display a WebService list into a HTML table?

Question

I've written a code to get departments from database and put it into a list, List<CLDepartements>; which contains getters and setters. How can I display this in a HTML table? I don't want to use DataSet or GridView and I'm not using the Razor view engine.

[WebMethod]
public CLDepartements[] getAllDepartements()
{
    string chConn = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
    List<CLDepartements> depList = new List<CLDepartements>();

    using (SqlConnection conn = new SqlConnection(chConn))
    {
        string sql = @"SELECT * FROM Departement";
        conn.Open();

        using(SqlCommand cmd = new SqlCommand(sql, conn))
        {
            SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            if (rd != null)
            {
                while (rd.Read())
                {
                    var dp = new CLDepartements
                    {
                        DepID = rd.GetInt32(0),
                        DepLibelle = rd.GetString(1),
                        DepDescription = rd.GetString(2)
                    };

                    depList.Add(dp);
                }    
            }
        }

        return depList.ToArray();
    }
}

score 0 · Answer 1 · answered Mar 06 '12 at 16:23

0

Whatever code is consuming the web service just needs to iterate through the returned list and output it as rows in an HTML table.

answered Mar 06 '12 at 16:23

CFL_Jeff

2,589
3
31
49

Thanks CFL_Jeff. Do you have a little sample or website? – Nader Laroussi Mar 06 '12 at 16:24
Try http://social.msdn.microsoft.com/Forums/ar/biztalkgeneral/thread/6f0cadc1-7ff3-4504-99d1-a3a752ccffcc – CFL_Jeff Mar 06 '12 at 16:32
or http://stackoverflow.com/questions/920362/how-to-iterate-through-a-list-of-strings-returned-from-a-web-service-using-jquer – CFL_Jeff Mar 06 '12 at 16:33

How do I display a WebService list into a HTML table?

1 Answers1