--0-664311114-979827345=:18051
Content-Type: text/plain; charset=us-ascii


  Where is your Direction property 
without this Sql Server assumes both input and output 

If you neglect to provide a value you'll receive an error!

 

dd <musicand@h...> wrote: 

Anyone out there using ADO.Net to access SQL Server? I've got a question:

Do you know what I'm missing here:
In COM+ I did:
With cmd
.ActiveConnection = m_ConnectionString
.CommandType = adCmdStoredProc
.CommandText = sStoredProc
.Parameters.Refresh
End With

That then allowed me to loop through the parameters needed and match up the
values I have from my ASP Request Object (from the form submitted).

So far as I can tell, ADO.Net doesn't have a way to get the parameters that
a stored proc has. I want to be able to load a proc name into the command
object (and of them would be fine - SQLCommand, SQLDataSetCommand...) and
then find out what parameters the stored proc needs filled and fill them
with the request object's fields from HttpContext.Current.Request.Form.

Am I completely missing something?

Jack





---------------------------------
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.