Batch Statments C# SQL Server 2000

[Vinny Vinn]

I have used simple batch statments with C#.for example:
string select = "select model from cars where id = ?;select * from trucks
where model = ?";
where ? is a parameter whose value i have before running the bach statment.

I was wondering if it possible to use the value (model) retuned in the first
statement for the where clause in the second statment?

TIA,
Vinny

[Nicholas Paldino [.NET/C# MVP]]

Vinny,

You would have to use a different select statement to do this, like
this:

select * from trucks where model in (select model from cars where id = ?)

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Vinny Vinn" <Vi*******@discussions.microsoft.com> wrote in message
news:DC**********************************@microsof t.com...

I have used simple batch statments with C#.for example:
string select = "select model from cars where id = ?;select * from trucks
where model = ?";
where ? is a parameter whose value i have before running the bach
statment.

I was wondering if it possible to use the value (model) retuned in the
first
statement for the where clause in the second statment?

TIA,
Vinny

[carion1]

what about...

select t.* from trucks t inner join cars c on t.model = c.model where c.id = ?

I don't know if there is a specific reason for using inline sql but I would
suggest using stored procedures.

"Vinny Vinn" wrote:

I have used simple batch statments with C#.for example:
string select = "select model from cars where id = ?;select * from trucks
where model = ?";
where ? is a parameter whose value i have before running the bach statment.

I was wondering if it possible to use the value (model) retuned in the first
statement for the where clause in the second statment?

TIA,
Vinny

[carion1]

what about...

select t.* from trucks t inner join cars c on t.model = c.model where c.id = ?

I don't know if there is a specific reason for using inline sql but I would
suggest using stored procedures.

"Vinny Vinn" wrote:

I have used simple batch statments with C#.for example:
string select = "select model from cars where id = ?;select * from trucks
where model = ?";
where ? is a parameter whose value i have before running the bach statment.

I was wondering if it possible to use the value (model) retuned in the first
statement for the where clause in the second statment?

TIA,
Vinny