Retrieve parameter names from stored procedures

Author	Message
Jeff Pagley	Jeff Pagley posted 17 Years Ago Topic Details Share Topic
Group: StrataFrame Users Posts: 223, Visits: 893	I have some old code where I used the System.Data.SqlClient.SqlConnection object that is dropped onto a form for data access. I use the connection object to retrieve parameter names of stored procedures. I would like to convert it to use Strataframe. Here is an example of what the code looks like now: cmd = New SqlClient.SqlCommand("StoredProcedureName", Me.SQLConnection99) cmd.CommandType = CommandType.StoredProcedure cmd.CommandTimeout = 60 'get the parameters for the stored procedure SqlCommandBuilder.DeriveParameters(cmd) For Each prm As SqlParameter In cmd.Parameters If prm.ParameterName <> "RETURN_VALUE" Then prm.Value = datarow(prm.ParameterName) End If Next prm How can I use Strataframe's connection layer to eliminate the SQL connection object (SQLConnection99) I am using now to retrieve the parameter names? I am sure it's simple, but I'm not seeing it. As always, thanks for your expert help!
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Jeff Pagley - 17 Years Ago

All you have to do is retrieve the connection string through your...

Trent L. Taylor - 17 Years Ago

Hi Trent, I guess I need little more help. I have used the...

Jeff Pagley - 17 Years Ago

Hi Trent, Sorry about the earlier post. Once I posted my response, it...

Jeff Pagley - 17 Years Ago

Yup...you got it. Sorry if I was not more clear. I was answering...

Trent L. Taylor - 17 Years Ago

You can also use it like this: Dim conn As SqlConnection =...

StrataFrame Team - 17 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login