returning more than first element from sql server

From: cm_at_gowcity (cm_at_gowcity.fsnet.co.uk)
Date: 02/12/04 

Date: 12 Feb 2004 12:36:55 -0800

IM AM NEW TO WEB SERVICE AND C# AND HAVE A QUESTION / PROBLEM

MY SIMPLE WEB METHOD

[WebMethod]
public string logtime(string ClientUserName)
{
        try
        {
        SqlConnection sqlConn = new SqlConnection(
                "data source=localhost;" +
                "initial catalog=isa;integrated security=true");
                SqlCommand sqlCmd = new SqlCommand();
                sqlCmd.CommandText = "SELECT logTime FROM WebProxyLog " +
                "WHERE ClientUserName = '" + ClientUserName + "'";
                sqlCmd.Connection = sqlConn;
                sqlConn.Open();
                string logtime = (string)sqlCmd.ExecuteScalar();
                sqlConn.Close();
                return logtime;
        }
        catch(Exception e)
        {
        throw new Exception("Error calculating cost: " + e.Message);
        }
}

NOW THIS RETURNS THE FIRST ELEMENT FROM THE SET RETURNED FROM THE
QUERY (ITHINK) BECAUSE I AM USING EXECUTESCALAR?

HOW COULD I MODIFY THIS TO RETURN ALL INSTANCES SO MY CLIENT
APPLICATION CAN ITERATE THROUGH EACH?

HOPE SOMEBODY HAS TIME FOR A NEWBIE

THANKS IN ADVANCE

COLIN

Relevant Pages
Loading