Stored procedure and an asp.net page

[nick]

Hi!

I created a stored procedure via the command line client. Checked it by executing a call and everything works fine. It's a simple select command without parameters.

When trying to use the procedure in an asp.net page (c#), it displays a "error in sql syntax" error message. When I replace the stored procedure with the actual sql statement, it works fine (so I guess no sql syntax error).

My asp.net code:
dbComm.Connection = dbConn;
dbComm.CommandType = CommandType.StoredProcedure;
dbAdapter.SelectCommand = dbComm;
dbComm.CommandText = "proc_paged_albums_main();
dbAdapter.Fill(dSet, "tbl_main");

Anybody got any ideas? Didn't find examples or help on msdn or google and ran out of inspiration.

Thanks!