Post reply

HELP ME!

  • June 26, 2007 at 6:33 am

    #179455

    hi
    i am writing a simple database program and i am having a little problem, i was wondering if you could help me. i wrote a stored procudure with 13 parameters that executes very well in Query Analyzer, but when i try to execute it from my C# application it throw an exception that say stored procedure has too many parameters( NO.8144), do you have any idea why can i execute it in Query Analyzer and not from my application? is there any way i can solve this?
    thanks alot
    Sareh Doroodian

  • June 27, 2007 at 1:28 am

    #715443

    Could you post the C# code where you call the proc?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 27, 2007 at 2:41 am

    #715458

    thanks alot for your attention, I solved it.

    Sareh Doroodian

  • June 27, 2007 at 8:32 am

    #715557

    You could use this handy little sproc to write the C# for you - minimise errors!

    http://www.codeproject.com/cs/database/CSCodeBuilder.asp

     

  • June 28, 2007 at 10:41 am

    #715923

    wow,the link was very nice and handy! thanks alot.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply