SQL SERVER 2000 PRINT function not working

Hullo All Good Guys, []
I am coming to you all for help. I am using VBNET2008 codes to activate the SQL SERVER PRINT function in the Stored Procedure
but having problem with the CURSOR in the Stored Procedure.
I am using VBNET2008, SQL SERVER 2000 and NORTHWIND database to test the PRINT .
Here are the VBNET2008 coding.
Private Sub btnSQLSERVERPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSQLSERVERPrint.Click
clsConnSrv = New ClassConnectionService
connstr = clsConnSrv.PropAdoConnection
sqlconn = New SqlConnection(connstr)
sqlconn.Open()
sqlcmd = New SqlCommand
sqlcmd.Connection = sqlconn
'Call Stored Procedure PRINT
With sqlcmd
.CommandText = "SProcPrintAllSales"
.CommandType = CommandType.StoredProcedure
End With

sqlcmd.ExecuteNonQuery()
sqlconn.Close()
End Sub
---------------------------------------
Here are the coding from STORED PROCEDURE
Code:
Create Procedure SProcPrintAllSales
AS

DECLARE AllSales Cursor
Open AllSales

/*** the following variables hold fields ***/
declare @cCompany nchar(40)
declare @prevCompany nchar(40)
declare @cOrderId int
declare @prevOrderId int
declare @cProduct nvarchar(40)
declare @cUnitPrice money
declare @cQuantity smallint
declare @cDiscount int
declare @cExtPrice money
/*** the following 2 variables hold the running totals ***/

declare @CustomerTotal money
declare @OrderTotal money
Fetch next from AllSales into
@cCompany, @cOrderID, @cProduct,
@cUnitPrice, @cQuantity, @cDiscount, @cExtPrice
Set @prevCompany = @cCompany
set @prevOrderId = @cOrderID
Print "COMPANY " + @cCompany
Print " Order " + Convert(char(5), @cOrderId)
Set @CustomerTotal = 0
Set @OrderTotal = 0
While @@Fetch_Status = 0
Begin
if @prevCompany <> @cCompany
Begin
set @customerTotal = @CustomerTotal + @OrderTotal
Print " ********** TOTAL FOR ORDER " +
CONVERT(char(5), @prevOrderID) + " ************* " +
Convert(char(8), @OrderTotal )

Print " TOTAL FOR " + @prevCompany + " " +
Convert(char(10), @CustomerTotal )
Set @CustomerTotal = 0
Print " "
Print "COMPANY " + @cCompany
Print " ORDER " + Convert(char(5), @cOrderId)
set @OrderTotal = 0
End
else
Begin
if @prevOrderID <> @cOrderId
Begin
Print " ****TOTAL FOR ORDER " +
CONVERT(CHAR(8), @prevOrderId ) + " *** " +
Convert(char(8), @OrderTotal )
Print " ORDER " + convert(char(5), @cOrderID)
Set @customerTotal = @CustomerTotal + @OrderTotal
Set @OrderTotal = 0
End
Print " " +
CONVERT(CHAR(30), @cProduct ) + " " +
Convert(char(4), @cQuantity) + " X " +
Convert(char(6), @cUnitPrice) + " @ " +
Convert(char(2), @cDiscount) + " % " +
Convert(char(12), @cExtPrice)
Set @OrderTotal = @OrderTotal + @cExtPrice
End
Set @prevOrderId = @cOrderId
Set @prevCompany = @cCompany
Fetch Next from AllSales INTO
@cCompany, @cOrderID, @cProduct,
@cUnitPrice, @cQuantity, @cDiscount, @cExtPrice
End
Print " TOTAL for " + @prevCompany + " " + convert(char(10), @customerTotal)
CLOSE ALLSALES
GO
--------------------------------------------------------
Please help me. Once I got it working based on your information, I will posted the coding here to share it with Newbies like me having similiar problems.
Thank you very much
Cheers,
Lennie

PRINT is a command that you can use while developing/debugging.
PRINT displays stuff on the Messages tab of the query window of the SQL Server program.
PRINT does not return anything on the Results tab (which is what a client application would receive as the resultset of the call to SQL Server).
In production code you should remove all PRINT commands - they can confuse your client application.

Thanks to you guys,
But the question of CURSOR problem is still waiting for help.

You seem to have skipped the most important part of the cursor definition, which normally comes between the DECLARE and OPEN lines, here:
DECLARE AllSales Cursor
Open AllSales
Next up, you still need to work on what you want to use instead of PRINT ...

Hi Adriaan,
Regarding the Quotation below what did I miss between DECLARE and OPEN ?
You seem to have skipped the most important part of the cursor definition, which normally comes between the DECLARE and OPEN lines, here:
DECLARE AllSales Cursor
Open AllSales

FOR ---your select query goes here----

Hi Adriaan,
Do you mean this :-
DECLARE AllSales Cursor
Select
Open AllSales

It´s about time you start reading Books Online on the subject. We can´t do your work for you, and if you´re not familiar with the basic syntax then why are you even touching that script?

Hi Adriaan,
You are not doing my work for me. If you are offering assistance at least provide a short sample coding to support your suggestion : SELECT

Hi FrankKalis,
Thank you very much for your suggestion. You are just awesome providing me with sample coding. I have tried it and it's working now. Thank you very much.

Hi there,
For testing purposed I am using the NorthWind Database table, ORDERSDETAILS and ORDERS table

Complete your vb.net procedure and use sqldatareader (or datatable) ,and loop over its rows and print your result to the printing device using .net printing capability.
No need for the stored pocedure and the cursor , especially its role is printing only.