Hello,
I don't know if I got it right, but to return anything from a Stored procedure just make something like:
Select client_datecreated from clients
if you need a date put it as a field then in C# execute the command and use the sqldatareader class:
check msdnhere
The command can be a Stored as well as a query.
|||Do i need to set an output parameter in the SP? The syntax in the SP is confusing me.|||select convert(char(10),fieldname in table,101) as test_Date from tablename
the 101 is a code which gives the date in mm/dd/yyyy format.
You should check with 'books online" in your SQL server help section.that gives you a list of different format you may want your date to be in.
convert basicly is truncating your date to have 10 characters otherwise you will have the hours:minute:seconds too in your result.
|||
If you would like to get data as return parameter (not return Value which is always int) you have to define it as OUTPUT in stored procedure definition, and also you have to setup this parameter as output in your SQLcommand object parameters definition.
If you would like to return it as cell in result table you do not have to define parameter and you can just do select yourdatafied from yourtable at the end of your stored procedure.
But SQL Command with output parameter is more elegant solution and will work a little faster ( .net do not have to create table structure for returned data)
and you can use executeNonQuery instead of execute scalar or execute reader.
See VB or C# help for syntax how to do this if you will have problems post again, but help is very good in VS so you should be good.
