Command Parameters

[msali36]

do you know what wornge with this

dim number as integer = 3453



myCommand = New OleDbCommand("S elect * from emp where eno=@number", myConnection)

myCommand.Param eters.Add("@id" , OleDbType.Integ er).Value = number

[Plater]

Easy.
You use @number in the command string and then use @id in the parameter adding.

[msali36]

Even by changing it does'nt work

[msali36]

myCommand = New OleDbCommand("S elect * from emp where ename like '@Name' ", myConnection)

Dim par As New OleDbParameter( "@Name", OleDbType.VarCh ar)

par.Value = "FORD"

myCommand.Param eters.Add(par)

[Plater]

What doesn't work about it?