stored procedure select statement with where clause

Hi,

Can anybody give me a sample code / sql script showing correc syntax
like SELECT * FROM TABLE WHERE FIELD =

the value to the where clause , i should be able to pass from the front end

it should return a result

how do i take this result? in a datareader? or in dataset?

thanks,
ss

Cor
Thu May 04 23:52:52 CDT 2006

ss,

This depends if it is OleDB or SQLClient or whatever.

SQLClient uses named parameters, OleDB does not here is the sequentce in
what the parmameters are given important.

See here a sample on our website

http://www.vb-tips.com/default.aspx?ID=550279ec-6767-44ff-aaa3-eb8b44af0137

If you want to bring the text Selelect to a stored procedure select than you
have to set in front the declaration of the used parameters.

ALTER Procedure [dbo].[sp_UseDateSample] @OrderDate TimeDate AS

I hope this helps,

Cor







"ss" <ss@discussions.microsoft.com> schreef in bericht
news:1A9A02EA-2E98-40D9-8438-D25E3192A105@microsoft.com...
> Hi,
>
> Can anybody give me a sample code / sql script showing correc syntax
> like SELECT * FROM TABLE WHERE FIELD =
>
> the value to the where clause , i should be able to pass from the front
> end
>
> it should return a result
>
> how do i take this result? in a datareader? or in dataset?
>
> thanks,
> ss

Jeff
Fri May 05 10:47:23 CDT 2006

Get a book

"ss" <ss@discussions.microsoft.com> wrote in message
news:1A9A02EA-2E98-40D9-8438-D25E3192A105@microsoft.com...
> Hi,
>
> Can anybody give me a sample code / sql script showing correc syntax
> like SELECT * FROM TABLE WHERE FIELD =
>
> the value to the where clause , i should be able to pass from the front
> end
>
> it should return a result
>
> how do i take this result? in a datareader? or in dataset?
>
> thanks,
> ss

ss
Tue May 09 00:06:01 CDT 2006

hi,

where in medical shop?

"Jeff Dillon" wrote:

> Get a book
>
> "ss" <ss@discussions.microsoft.com> wrote in message
> news:1A9A02EA-2E98-40D9-8438-D25E3192A105@microsoft.com...
> > Hi,
> >
> > Can anybody give me a sample code / sql script showing correc syntax
> > like SELECT * FROM TABLE WHERE FIELD =
> >
> > the value to the where clause , i should be able to pass from the front
> > end
> >
> > it should return a result
> >
> > how do i take this result? in a datareader? or in dataset?
> >
> > thanks,
> > ss
>
>
>

Jeff
Tue May 09 11:25:07 CDT 2006

I meant, get a book on ASP.NET. Any book will describe what you are looking
for

amazon.com

Jeff

"ss" <ss@discussions.microsoft.com> wrote in message
news:CFE19711-ED52-4A2D-934A-B64F1893A921@microsoft.com...
> hi,
>
> where in medical shop?
>
> "Jeff Dillon" wrote:
>
>> Get a book
>>
>> "ss" <ss@discussions.microsoft.com> wrote in message
>> news:1A9A02EA-2E98-40D9-8438-D25E3192A105@microsoft.com...
>> > Hi,
>> >
>> > Can anybody give me a sample code / sql script showing correc syntax
>> > like SELECT * FROM TABLE WHERE FIELD =
>> >
>> > the value to the where clause , i should be able to pass from the front
>> > end
>> >
>> > it should return a result
>> >
>> > how do i take this result? in a datareader? or in dataset?
>> >
>> > thanks,
>> > ss
>>
>>
>>