Only the last value in the sql is retrieved!!Kindl

[HunterL]

Hi,<BR><BR>This is part of my program.I am using a stored procedure.My comments is inbetween.<BR><BR> Dim strConnect As String = "Provider=SQLOLEDB;data source=localhost;initial catalog=Ideal;UID=sa;pwd=;"<BR> Dim objConnect As New OleDbConnection(strConnect)<BR> Dim strCommandText As String = "MyProcName"<BR> Dim objCommand As New OleDbCommand(strCommandText, objConnect)<BR> <BR><BR> objCommand.CommandType = CommandType.StoredProcedure<BR><BR> Dim objParam As OleDbParameter<BR> objParam = objCommand.Parameters.Add("FName", OleDbType.VarChar, 12)<BR> objParam.Direction = ParameterDirection.Input<BR> objParam.Value = http://aspmessageboard.com/archive/index.php/"MyName"<BR><BR> objParam = objCommand.Parameters.Add("User_PDate", OleDbType.DBDate)<BR> objParam.Direction = ParameterDirection.Output<BR><BR> objConnect.Open()<BR> objCommand.ExecuteNonQuery()<BR> <BR>Note: The below line must retrive a set of values.How would I use For...each..next statement to retrieve all the values from a table?<BR>The below line retrieves only the last value in the table.<BR><BR> Dim strUserDate As String = objCommand.Parameters("User_PDate").Value.ToString()<BR> response.write struserdate.<BR> <BR>thx in advance.