If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

command parameters

hi there,

i recommend the following to this task of creating a command parameter:

Code:

cmd.Parameters.Add("@l_no", SqlDbType.Int, 4).Value = <l_no value>

which means you have to declare the data type of this parameter. sometimes, you also need the direction (input or output). in this example, the size of this parameter is also specified. you might skip this if your datatype is varchar.