Dim Command Question

[Keith]

Good Morning,

I am new to .Net so forgive me if this is question is kind of out there. Is there a way to consolidate multiple Dim statements for Sql Commands? I have a page that has around 50 Dim statements for Sql Commands and was wondering if there was a way much like an array where I could just do something like:

Dim cmdSelect(50) as Sql Command

This may be far fetched, but just thought I would ask.

Thanks,
Keith

[Hermit Dave]

i am not sure whether you need all the 50 commands at the same time !!!
if you dont i would advise you to have an array of sql command text and then
use something like Microsoft Data Access Application Block to create the
corresponding amout.
Even then i am not sure whether this is the best advice. If you could write
a bit more on what you are trying to achieve, maybe someone around here will
be able to answer your question in a better way.

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Keith" <kc****@hotmail .com> wrote in message
news:ez******** *****@TK2MSFTNG P12.phx.gbl...
Good Morning,

I am new to .Net so forgive me if this is question is kind of out there. Is
there a way to consolidate multiple Dim statements for Sql Commands? I have
a page that has around 50 Dim statements for Sql Commands and was wondering
if there was a way much like an array where I could just do something like:

Dim cmdSelect(50) as Sql Command

This may be far fetched, but just thought I would ask.

Thanks,
Keith

[Karl Seguin]

You can have an array of SqlCommands, or you could simply keep reusing the same name and reinstantiate it

dim command as SqlCommand
for i as integer = 0 to 50
command = new SqlCommand()

command.dispose ()
next i

karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Keith" <kc****@hotmail .com> wrote in message news:ez******** *****@TK2MSFTNG P12.phx.gbl...
Good Morning,

I am new to .Net so forgive me if this is question is kind of out there. Is there a way to consolidate multiple Dim statements for Sql Commands? I have a page that has around 50 Dim statements for Sql Commands and was wondering if there was a way much like an array where I could just do something like:

Dim cmdSelect(50) as Sql Command

This may be far fetched, but just thought I would ask.

Thanks,
Keith

[Keith]

I have a page that where someone can select a date (JAN 04) from a dropdown
list. When they click submit it returns the given results for 5 different
locations (Just simple Select statements). So I would say I need all those
commands at the same time. Right now I have the following:

Dim cmdSelect1 as SqlCommand
Dim cmdSelect2 as SqlCommand
etc
etc

Thanks,

"Hermit Dave" <he************ @CAPS.AND.DOTS. hotmail.com> wrote in message
news:OZ******** ******@TK2MSFTN GP10.phx.gbl...

i am not sure whether you need all the 50 commands at the same time !!!
if you dont i would advise you to have an array of sql command text and then use something like Microsoft Data Access Application Block to create the
corresponding amout.
Even then i am not sure whether this is the best advice. If you could write a bit more on what you are trying to achieve, maybe someone around here will be able to answer your question in a better way.

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Keith" <kc****@hotmail .com> wrote in message
news:ez******** *****@TK2MSFTNG P12.phx.gbl...
Good Morning,

I am new to .Net so forgive me if this is question is kind of out there. Is there a way to consolidate multiple Dim statements for Sql Commands? I have a page that has around 50 Dim statements for Sql Commands and was wondering if there was a way much like an array where I could just do something like:
Dim cmdSelect(50) as Sql Command

This may be far fetched, but just thought I would ask.

Thanks,
Keith

[Hermit Dave]

consider using a stored procedure instead of direct select commands and you
can get multiple recordsets

as long as the datasource is the same you select command can indeed return
more than one recordsets

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Keith" <kc****@hotmail .com> wrote in message
news:OE******** ********@TK2MSF TNGP10.phx.gbl. ..

I have a page that where someone can select a date (JAN 04) from a dropdown
list. When they click submit it returns the given results for 5 different
locations (Just simple Select statements). So I would say I need all
those
commands at the same time. Right now I have the following:

Dim cmdSelect1 as SqlCommand
Dim cmdSelect2 as SqlCommand
etc
etc

Thanks,

"Hermit Dave" <he************ @CAPS.AND.DOTS. hotmail.com> wrote in message
news:OZ******** ******@TK2MSFTN GP10.phx.gbl...

i am not sure whether you need all the 50 commands at the same time !!!
if you dont i would advise you to have an array of sql command text and

then

use something like Microsoft Data Access Application Block to create the
corresponding amout.
Even then i am not sure whether this is the best advice. If you could

write

a bit more on what you are trying to achieve, maybe someone around here

will

be able to answer your question in a better way.

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Keith" <kc****@hotmail .com> wrote in message
news:ez******** *****@TK2MSFTNG P12.phx.gbl...
Good Morning,

I am new to .Net so forgive me if this is question is kind of out there.

Is

there a way to consolidate multiple Dim statements for Sql Commands? I

have

a page that has around 50 Dim statements for Sql Commands and was

wondering

if there was a way much like an array where I could just do something

like:

Dim cmdSelect(50) as Sql Command

This may be far fetched, but just thought I would ask.

Thanks,
Keith

[Keith]

Thanks for everyone's input.
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net> wrote in message news:Ow******** ******@TK2MSFTN GP10.phx.gbl...
You can have an array of SqlCommands, or you could simply keep reusing the same name and reinstantiate it

dim command as SqlCommand
for i as integer = 0 to 50
command = new SqlCommand()

command.dispose ()
next i

karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Keith" <kc****@hotmail .com> wrote in message news:ez******** *****@TK2MSFTNG P12.phx.gbl...
Good Morning,

I am new to .Net so forgive me if this is question is kind of out there. Is there a way to consolidate multiple Dim statements for Sql Commands? I have a page that has around 50 Dim statements for Sql Commands and was wondering if there was a way much like an array where I could just do something like:

Dim cmdSelect(50) as Sql Command

This may be far fetched, but just thought I would ask.

Thanks,
Keith