How to use String Array as SqlParameter in VS 2005

  • Thread starter Thread starter Marcus Kraus
  • Start date Start date
M

Marcus Kraus

Hi there,

I can't figure it out.
I have following SQL Statement:

Select xx from yy where yy in ( 'value1', 'value2')

That one is running fine.

Now I want to use that SQL Statement in VStudio 2005 DataDesigner...
so I would have a string array or else ( maybe Object ) for the values.

Is that possible ?

Thanx in advance
and
please excuse my bad english :-)
 
SQL Server doesn't have the concept of an Array oriented datatype
that you could pass as a single entity to sql or to a stored procedure.


--
Robbe Morris - 2004-2006 Microsoft MVP C#
I've mapped the database to .NET class properties and methods to
implement an multi-layered object oriented environment for your
data access layer. Thus, you should rarely ever have to type the words
SqlCommand, SqlDataAdapter, or SqlConnection again.
http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp
 
Am Fri, 20 Oct 2006 20:20:21 -0400 schrieb Robbe Morris [C# MVP]:
SQL Server doesn't have the concept of an Array oriented datatype
that you could pass as a single entity to sql or to a stored procedure.
Click to expand...

Hi Rob,

thank you very much for the quick helpful answer...

Marcus
 
Back
Top