Re: Autogenerate Stored Procedure parameters...

Brett,

Have you worked with the Server Explorer? You can establish a
connection to your database, and then drag the stored procedure from the
explorer (under the Data Connections) to a DataSet designer and it should
create wrappers for making calls to the stored procedure.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx

"Brett Wickard" <nospam@xxxxxxxxxx> wrote in message
news:Oqu1zLE2GHA.4976@xxxxxxxxxxxxxxxxxxxxxxx
Anyone know of a good way to autogenerate stored procedure parameters to
put into c# code? I don't need to do it on the fly, just while coding.
I've got some SPs with a lot of parameters, so it would save some time to
be able to make the code for the SqlParameter object automatically.



.

Relevant Pages

  • RE: Server Explorer: Only for SQLSrv/MSDE??
    ... Add a new connection by right-clicking on 'Data Connections' item in Server Explorer. ... Now you could add a new connection to your database and once that is down, you could browse thru the tables etc. and drag-n-drop. ...
    (microsoft.public.dotnet.general)
  • How to modify connection in Server Explorer?
    ... I have add a database connection to SQL ... Server 200 under Data Connections of Server Explorer. ... But how can I modify ...
    (microsoft.public.vsnet.ide)
  • How to modify connecton in server explorer
    ... I have add a database connection under ... Data Connections of Server Explorer. ... But how can I modify the connection ...
    (microsoft.public.vsnet.general)
  • RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Vari
    ... Instead of using an OUTPUT parameter in the sp, set the Execute SQL Task (on ... With stored procedures, the other connection ... listed in the stored procedure, which makes the connection a little more ... I've created a Master Package that will be used as a template for developing ...
    (microsoft.public.sqlserver.dts)
  • RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Variable
    ... With stored procedures, the other connection ... listed in the stored procedure, which makes the connection a little more ... I've created a Master Package that will be used as a template for developing ... At the end of the process, the created audit record will be ...
    (microsoft.public.sqlserver.dts)