How can i read in my C# client application values returned from sqlpipe send(string)/send(reader method from CLR stored procedure.....following is example of a stored procedure.I want to read datetime string in my C# client
Thanks
[Microsoft.SqlServer.Server.SqlProcedure]
public static void PrintToday()
{
// Put your code here
SqlPipe p;
p = SqlContext.Pipe;
p.Send(System.DateTime.Today.ToString());
}
Hi!
Execute your PrintToday with SqlCommand.ExecuteReader, then read the string from SqlDataReader returned.
|||Exactly how are you supposed to do this? No matter what i do, the reader is always empty.
No comments:
Post a Comment