Stored Procedure/Parameter problem

[ElmoWatson]

I'm getting an error I don't understand....

Here's my Code:


Dim dr As SqlDataReader
Dim retVal As Boolean = False
Dim MySQL as string = "spGetEmployee"
Dim Myconn as New
SQLConnection(ConfigurationSettings.AppSettings("E mpLogin"))
Dim Cmd as New SQLCommand(MySQL, MyConn)
cmd.CommandType=CommandType.StoredProcedure
cmd.parameters.add(New SQLParameter("@Login", txtUID.text))
cmd.parameters.add(New SQLParameter("@Password", txtPWD.text))
cmd = New SqlCommand(MySQL, MyConn)
MyConn.Open()
dr = cmd.ExecuteReader()

But on that last line (executeReader), I get this error:
Procedure 'spGetEmployee' expects parameter '@Login', which was not supplied

What am I doing wrong?

[Jerry]

Marina is correct. You can also just comment out cmd = New SqlCommand(MySQL,
MyConn)
line of code.


"Marina" <zlatkinam@nospam.hotmail.com> wrote in message
news:u5FMYcqWDHA.1640@TK2MSFTNGP10.phx.gbl...

> When you say: cmd = new SqlCommand(MySQL,MyConn), this creates a new
> SqlCommand object.
>
> All the parameters you set before, just got wiped out, because the object
> you set it on, no longer exists.
>
> Move the parameter statements to after this constructor call.
>
> "ElmoWatson" <sputnik75043@yahoo.com> wrote in message
> news:%23XPL9aqWDHA.2424@TK2MSFTNGP12.phx.gbl...

> > I'm getting an error I don't understand....
> >
> > Here's my Code:
> >
> >
> > Dim dr As SqlDataReader
> > Dim retVal As Boolean = False
> > Dim MySQL as string = "spGetEmployee"
> > Dim Myconn as New
> > SQLConnection(ConfigurationSettings.AppSettings("E mpLogin"))
> > Dim Cmd as New SQLCommand(MySQL, MyConn)
> > cmd.CommandType=CommandType.StoredProcedure
> > cmd.parameters.add(New SQLParameter("@Login", txtUID.text))
> > cmd.parameters.add(New SQLParameter("@Password", txtPWD.text))
> > cmd = New SqlCommand(MySQL, MyConn)
> > MyConn.Open()
> > dr = cmd.ExecuteReader()
> >
> > But on that last line (executeReader), I get this error:
> > Procedure 'spGetEmployee' expects parameter '@Login', which was not

> supplied

> >
> > What am I doing wrong?
> >
> >

>
>