Home All Groups Group Topic Archive Search About

Adding parameters to stored procedures

microsoft.public.dotnet.languages.vb
Author
12 Sep 2006 9:11 PM
Bonzol
Thanx to the help of other memebers on this group i've gotten to where
I am

however, I seem unable to add the required paramater to my stored
procedure

my code

Dim toreturn As System.Data.DataTable
        ' Try
        Me.SqlConnection1.Open()
        Me.SqlSelectCommand1.CommandText = "[CustOrdersOrders]"
        Me.SqlSelectCommand1.Parameters.AddWithValue("@CustomerID",
"VINET")
        Me.SqlSelectCommand1.ExecuteNonQuery()
        Me.SqlDataAdapter1 = New
System.Data.SqlClient.SqlDataAdapter(Me.SqlSelectCommand1.CommandText,
Me.SqlConnection1)
        Dim dt As System.Data.DataTable
        dt = New System.Data.DataTable
        Me.SqlDataAdapter1.Fill(dt)

        Me.SqlConnection1.Close()
        toreturn = dt
        'Catch

        'End Try
        Return toreturn


the error

Procedure 'CustOrdersOrders' expects parameter '@CustomerID', which was
not supplied


any help?

thanx in advance

Author
12 Sep 2006 10:21 PM
Kerry Moorman
Bonzol,

You try modifying your code like this:

        Dim toreturn As System.Data.DataTable
        ' Try
        Me.SqlConnection1.Open()
        Me.SqlSelectCommand1.CommandText = "[CustOrdersOrders]"
        Me.SqlSelectCommand1.Parameters.AddWithValue("@CustomerID", "VINET")
        Me.SqlSelectCommand1.Connection = Me.SqlConnection1
        Me.SqlDataAdapter1 = New
System.Data.SqlClient.SqlDataAdapter(Me.SqlSelectCommand1)
        Dim dt As System.Data.DataTable
        dt = New System.Data.DataTable
        Me.SqlDataAdapter1.Fill(dt)

        Me.SqlConnection1.Close()
        toreturn = dt
        'Catch

        'End Try
        Return toreturn

Kerry Moorman


Show quoteHide quote
"Bonzol" wrote:

> Thanx to the help of other memebers on this group i've gotten to where
> I am
>
> however, I seem unable to add the required paramater to my stored
> procedure
>
> my code
>
> Dim toreturn As System.Data.DataTable
>         ' Try
>         Me.SqlConnection1.Open()
>         Me.SqlSelectCommand1.CommandText = "[CustOrdersOrders]"
>         Me.SqlSelectCommand1.Parameters.AddWithValue("@CustomerID",
> "VINET")
>         Me.SqlSelectCommand1.ExecuteNonQuery()
>         Me.SqlDataAdapter1 = New
> System.Data.SqlClient.SqlDataAdapter(Me.SqlSelectCommand1.CommandText,
> Me.SqlConnection1)
>         Dim dt As System.Data.DataTable
>         dt = New System.Data.DataTable
>         Me.SqlDataAdapter1.Fill(dt)
>
>         Me.SqlConnection1.Close()
>         toreturn = dt
>         'Catch
>
>         'End Try
>         Return toreturn
>
>
> the error
>
> Procedure 'CustOrdersOrders' expects parameter '@CustomerID', which was
> not supplied
>
>
> any help?
>
> thanx in advance
>
>
Author
13 Sep 2006 1:13 AM
Bonzol
Cheers
Kerry Moorman wrote:
Show quoteHide quote
> Bonzol,
>
> You try modifying your code like this:
>
>         Dim toreturn As System.Data.DataTable
>         ' Try
>         Me.SqlConnection1.Open()
>         Me.SqlSelectCommand1.CommandText = "[CustOrdersOrders]"
>         Me.SqlSelectCommand1.Parameters.AddWithValue("@CustomerID", "VINET")
>         Me.SqlSelectCommand1.Connection = Me.SqlConnection1
>         Me.SqlDataAdapter1 = New
> System.Data.SqlClient.SqlDataAdapter(Me.SqlSelectCommand1)
>         Dim dt As System.Data.DataTable
>         dt = New System.Data.DataTable
>         Me.SqlDataAdapter1.Fill(dt)
>
>         Me.SqlConnection1.Close()
>         toreturn = dt
>         'Catch
>
>         'End Try
>         Return toreturn
>
> Kerry Moorman
>
>
> "Bonzol" wrote:
>
> > Thanx to the help of other memebers on this group i've gotten to where
> > I am
> >
> > however, I seem unable to add the required paramater to my stored
> > procedure
> >
> > my code
> >
> > Dim toreturn As System.Data.DataTable
> >         ' Try
> >         Me.SqlConnection1.Open()
> >         Me.SqlSelectCommand1.CommandText = "[CustOrdersOrders]"
> >         Me.SqlSelectCommand1.Parameters.AddWithValue("@CustomerID",
> > "VINET")
> >         Me.SqlSelectCommand1.ExecuteNonQuery()
> >         Me.SqlDataAdapter1 = New
> > System.Data.SqlClient.SqlDataAdapter(Me.SqlSelectCommand1.CommandText,
> > Me.SqlConnection1)
> >         Dim dt As System.Data.DataTable
> >         dt = New System.Data.DataTable
> >         Me.SqlDataAdapter1.Fill(dt)
> >
> >         Me.SqlConnection1.Close()
> >         toreturn = dt
> >         'Catch
> >
> >         'End Try
> >         Return toreturn
> >
> >
> > the error
> >
> > Procedure 'CustOrdersOrders' expects parameter '@CustomerID', which was
> > not supplied
> >
> >
> > any help?
> >
> > thanx in advance
> >
> >
Author
13 Sep 2006 1:47 AM
Cor Ligthert [MVP]
Bonzol,

Be aware that the sample as Kerry gave you is only working after evertime
initializing the command.
If you using the parameter more than you have only to set the value of the
command

Me.SqlSelectCommand1.Parameters("@CustomerId").Value = "BINET"

Just as addition

Cor


Show quoteHide quote
"Bonzol" <Bon***@hotmail.com> schreef in bericht
news:1158110017.405661.71140@h48g2000cwc.googlegroups.com...
> Cheers
> Kerry Moorman wrote:
>> Bonzol,
>>
>> You try modifying your code like this:
>>
>>         Dim toreturn As System.Data.DataTable
>>         ' Try
>>         Me.SqlConnection1.Open()
>>         Me.SqlSelectCommand1.CommandText = "[CustOrdersOrders]"
>>         Me.SqlSelectCommand1.Parameters.AddWithValue("@CustomerID",
>> "VINET")
>>         Me.SqlSelectCommand1.Connection = Me.SqlConnection1
>>         Me.SqlDataAdapter1 = New
>> System.Data.SqlClient.SqlDataAdapter(Me.SqlSelectCommand1)
>>         Dim dt As System.Data.DataTable
>>         dt = New System.Data.DataTable
>>         Me.SqlDataAdapter1.Fill(dt)
>>
>>         Me.SqlConnection1.Close()
>>         toreturn = dt
>>         'Catch
>>
>>         'End Try
>>         Return toreturn
>>
>> Kerry Moorman
>>
>>
>> "Bonzol" wrote:
>>
>> > Thanx to the help of other memebers on this group i've gotten to where
>> > I am
>> >
>> > however, I seem unable to add the required paramater to my stored
>> > procedure
>> >
>> > my code
>> >
>> > Dim toreturn As System.Data.DataTable
>> >         ' Try
>> >         Me.SqlConnection1.Open()
>> >         Me.SqlSelectCommand1.CommandText = "[CustOrdersOrders]"
>> >         Me.SqlSelectCommand1.Parameters.AddWithValue("@CustomerID",
>> > "VINET")
>> >         Me.SqlSelectCommand1.ExecuteNonQuery()
>> >         Me.SqlDataAdapter1 = New
>> > System.Data.SqlClient.SqlDataAdapter(Me.SqlSelectCommand1.CommandText,
>> > Me.SqlConnection1)
>> >         Dim dt As System.Data.DataTable
>> >         dt = New System.Data.DataTable
>> >         Me.SqlDataAdapter1.Fill(dt)
>> >
>> >         Me.SqlConnection1.Close()
>> >         toreturn = dt
>> >         'Catch
>> >
>> >         'End Try
>> >         Return toreturn
>> >
>> >
>> > the error
>> >
>> > Procedure 'CustOrdersOrders' expects parameter '@CustomerID', which was
>> > not supplied
>> >
>> >
>> > any help?
>> >
>> > thanx in advance
>> >
>> >
>



Post Other interesting topics
(newbie) - reading data from a file - in VB 2005 EE
udpclient receive port# ?
Help with memory/resource use
Immediate window
Generating SQL on the fly?
GUI for Charts
Proper Way to add tbxXXX.Text to URL
Greyed out controls
AxMSFlexGrid is ambiguous in the namespace AxMSFlexGridLib
ComboBox Question?