SQL query from an array in VB.NET

  • Thread starter Thread starter SM Lawless via .NET 247
  • Start date Start date
S

SM Lawless via .NET 247

I'm tying to create a SQL query from an array i've created
(through a check-box list), in VB.NET.
Your help will be much appreciated!!!!
Thanks!
 
SM Lawless via .NET 247 said:
I'm tying to create a SQL query from an array i've created
(through a check-box list), in VB.NET.
Your help will be much appreciated!!!!
Thanks!
Click to expand...


Would be helpfull if we had more information? Like, what does this array
look like and what your trying to accomplish.

Tom Shelton
 
* SM Lawless via .NET 247 said:
I'm tying to create a SQL query from an array i've created
(through a check-box list), in VB.NET.
Your help will be much appreciated!!!!
Click to expand...

Do you want to execute the query /on/ the array or do you want the
checkbox selection as parameter values?
 
SM Lawless via .NET 247 said:
I'm tying to create a SQL query from an array i've created
(through a check-box list), in VB.NET.
Your help will be much appreciated!!!!
Thanks!
Click to expand...

Help with what?

Possible answers:
[ ] Have a look at System.text.stringbuilder
[ ] Have a look at the Parameters property of the OleDBCommand/SQLCommand
[ ] Have a look at
http://msdn.microsoft.com/library/d...y/en-us/vbcon/html/vboriIntegratingDataVB.asp
and
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconaccessingdatawithadonet.asp


--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html
 
Hi SM,

What is difficult with that

I think it is something as
Dim cmd As New SqlCommand(ArrayWithstrSQL(arrayindex), Conn)

I hope this answers your question

Cor
 
Back
Top