SubSonic - stored procedure with no parameters

by Mark 19. February 2009 12:41

There seems to be an issue with using stored procedures in SubSonic that do not have any parameters.  As a work around to that bug (or feature)...  try this:

SubSonic.StoredProcedure sp = SPs.UspNoParamProc();
//Stored Procedure command Is Null... ensure command is created
string dummy = sp.Command.CommandSql;

rptList.DataSource = sp.GetReader();
rptList.DataBind();

Comments (3) -

8/5/2009 2:06:49 PM #

Arthur

thanks!

Arthur Brazil |

10/27/2009 3:32:16 AM #

cash loans

I like what I see. keep it going

cash loans United States |

11/24/2009 3:45:52 PM #

Fernando Osorio

Thanks, this is anoying... And I have to downgrade from 2.2 because the SubStage doesn't run in my computer and other several issues.

Cheers,

Fernando Osorio United States |

About Mark...

Not much to see here ;-)  Just a normal guy, who goes to work, takes care of his family, goes to church and tithes, and - just like Rush Limbaugh - hopes that Barry fails at his attempt to "fundamentally transform" this country.  Oh, and I do cling to my God and gun.

Month List