TableAdapter.Fill Method

TableAdapter.Fill Method

I was successfully calling a TableAdapter.Fill command in code which was tied 
to an SQL stored procedure.  I altered the stored procedure in SQL Server to 
include two additional parameters and it stopped working in code.  The stored 
procedure works when previewing it in the dataset designer.  But the line of 
code comes up with an error stating 'Expression Expected' and the comma after 
the first 
parameter is underlined.  Can't find the problem.  I only added three 
additional parameters in the stored procedure which I include on the line of 
code but no dice.  Any ideas?  Here is the line of code:

Me.SpWPJOs_TableAdapter.Fill(Me.DsWPJOs.spWPJOs, 'Pending', blWPsCompleted, 
'1/1/2007', '12/31/2007')

Thx.

date: Thu, 21 Feb 2008 14:55:02 -0800 author: Ron

RE: TableAdapter.Fill Method

Hello Ron,

Did u mean that you added new parameters to the sp.?
if so did u miss adding the same to the parameter list for the stored proc 
in the .net side???

Regards,
~Vinu

"Ron" wrote:

> I was successfully calling a TableAdapter.Fill command in code which was tied 
> to an SQL stored procedure.  I altered the stored procedure in SQL Server to 
> include two additional parameters and it stopped working in code.  The stored 
> procedure works when previewing it in the dataset designer.  But the line of 
> code comes up with an error stating 'Expression Expected' and the comma after 
> the first 
> parameter is underlined.  Can't find the problem.  I only added three 
> additional parameters in the stored procedure which I include on the line of 
> code but no dice.  Any ideas?  Here is the line of code:
> 
> Me.SpWPJOs_TableAdapter.Fill(Me.DsWPJOs.spWPJOs, 'Pending', blWPsCompleted, 
> '1/1/2007', '12/31/2007')
> 
> Thx.

date: Tue, 13 May 2008 03:30:01 -0700 author: Vinu

RE: TableAdapter.Fill Method

Look at your code below. All code after the first ' character (just before 
Pending) is viewed as a comment.

Me.SpWPJOs_TableAdapter.Fill(Me.DsWPJOs.spWPJOs, 'Pending', blWPsCompleted, 
'1/1/2007', '12/31/2007')


"Ron" wrote:

> I was successfully calling a TableAdapter.Fill command in code which was tied 
> to an SQL stored procedure.  I altered the stored procedure in SQL Server to 
> include two additional parameters and it stopped working in code.  The stored 
> procedure works when previewing it in the dataset designer.  But the line of 
> code comes up with an error stating 'Expression Expected' and the comma after 
> the first 
> parameter is underlined.  Can't find the problem.  I only added three 
> additional parameters in the stored procedure which I include on the line of 
> code but no dice.  Any ideas?  Here is the line of code:
> 
> Me.SpWPJOs_TableAdapter.Fill(Me.DsWPJOs.spWPJOs, 'Pending', blWPsCompleted, 
> '1/1/2007', '12/31/2007')
> 
> Thx.

date: Wed, 28 May 2008 14:51:01 -0700 author: jp2msft

Re: TableAdapter.Fill Method

Wow good eye. That would certainly account for it. Ditto for the framing 
quotes on the dates as well.

-- 
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205  (Pacific time)
Hitchhikerâs Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

"jp2msft"  wrote in message 
news:BDAB0F2D-2E64-4472-97C2-B0E64760D5D6@microsoft.com...
> Look at your code below. All code after the first ' character (just before
> Pending) is viewed as a comment.
>
> Me.SpWPJOs_TableAdapter.Fill(Me.DsWPJOs.spWPJOs, 'Pending', 
> blWPsCompleted,
> '1/1/2007', '12/31/2007')
>
>
> "Ron" wrote:
>
>> I was successfully calling a TableAdapter.Fill command in code which was 
>> tied
>> to an SQL stored procedure.  I altered the stored procedure in SQL Server 
>> to
>> include two additional parameters and it stopped working in code.  The 
>> stored
>> procedure works when previewing it in the dataset designer.  But the line 
>> of
>> code comes up with an error stating 'Expression Expected' and the comma 
>> after
>> the first
>> parameter is underlined.  Can't find the problem.  I only added three
>> additional parameters in the stored procedure which I include on the line 
>> of
>> code but no dice.  Any ideas?  Here is the line of code:
>>
>> Me.SpWPJOs_TableAdapter.Fill(Me.DsWPJOs.spWPJOs, 'Pending', 
>> blWPsCompleted,
>> '1/1/2007', '12/31/2007')
>>
>> Thx.

date: Wed, 28 May 2008 16:30:22 -0700 author: William Vaughn [MVP]

Re: TableAdapter.Fill Method

Thank you, Sir!

Coming from an MVP, that means a lot!

"William Vaughn [MVP]" wrote:

> Wow good eye. That would certainly account for it. Ditto for the framing 
> quotes on the dates as well.
> 
> -- 
> __________________________________________________________________________
> William R. Vaughn
> President and Founder Beta V Corporation
> Author, Mentor, Dad, Grandpa
> Microsoft MVP
> (425) 556-9205  (Pacific time)
> Hitchhikerâs Guide to Visual Studio and SQL Server (7th Edition)
> ____________________________________________________________________________________________
> 
> "jp2msft"  wrote in message 
> news:BDAB0F2D-2E64-4472-97C2-B0E64760D5D6@microsoft.com...
> > Look at your code below. All code after the first ' character (just before
> > Pending) is viewed as a comment.
> >
> > Me.SpWPJOs_TableAdapter.Fill(Me.DsWPJOs.spWPJOs, 'Pending', 
> > blWPsCompleted,
> > '1/1/2007', '12/31/2007')
> >
> >
> > "Ron" wrote:
> >
> >> I was successfully calling a TableAdapter.Fill command in code which was 
> >> tied
> >> to an SQL stored procedure.  I altered the stored procedure in SQL Server 
> >> to
> >> include two additional parameters and it stopped working in code.  The 
> >> stored
> >> procedure works when previewing it in the dataset designer.  But the line 
> >> of
> >> code comes up with an error stating 'Expression Expected' and the comma 
> >> after
> >> the first
> >> parameter is underlined.  Can't find the problem.  I only added three
> >> additional parameters in the stored procedure which I include on the line 
> >> of
> >> code but no dice.  Any ideas?  Here is the line of code:
> >>
> >> Me.SpWPJOs_TableAdapter.Fill(Me.DsWPJOs.spWPJOs, 'Pending', 
> >> blWPsCompleted,
> >> '1/1/2007', '12/31/2007')
> >>
> >> Thx. 
>

date: Thu, 29 May 2008 06:09:01 -0700 author: jp2msft