ODBC parameters

[hayaf]

Hi,
I am using visual studio vb .net and sql server database

I need help on show to set the ODBC parameters names and types of a stored procure at run time in visual basic .net

The below code is a sample code

Dim command As OdbcCommand = New OdbcCommand ("{ CALL StoredProcedureName(?) }", Connection)
 
Dim Parameter as OdbcParameter
 
command.CommandType = CommandType.StoredProcedure
 
Parameter = command.Parameters.Add("@Parameter Name", OdbcType.VarChar, 10)
 
Parameter.Value = “test”
 
 
 
command.ExecuteNonQuery ()
 

I can set the parameter value at run time as the user enters the value but I need the code to be more dynamic in the following sense:

Can I set the parameter name at run time i.e. from a variable?

Parameter = command.Parameters.Add(ParamName, OdbcType.VarChar, 10)

Can I set the parameter Type (OdbcType) at run time i.e. from a variable?

Parameter = command.Parameters.Add("@Parameter Name", ParamType, 10)

[Frinavale]

Hi,
I am using visual studio vb .net and sql server database

I need help on show to set the ODBC parameters names and types of a stored procure at run time in visual basic .net
...
Can I set the parameter name at run time i.e. from a variable?

Parameter = command.Parameters.Add(ParamName, OdbcType.VarChar, 10)

I've never used ODBC before but...
Have you tried using something like:

command.Parameters.Add("@MyName", OdbcType.VarChar, 30)
command.Parameters("@MyName").Value = names
 

-Frinny