473,386 Members | 1,736 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

SQL query from an array in VB.NET

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!

--------------------------------
From: SM Lawless

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>E9NkGTyKtk2nQKD3vVVlBg==</Id>
Nov 20 '05 #1
4 3771

"SM Lawless via .NET 247" <an*******@dotnet247.com> wrote in message
news:eu**************@TK2MSFTNGP09.phx.gbl...
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!

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

Tom Shelton
Nov 20 '05 #2
* SM Lawless via .NET 247 <an*******@dotnet247.com> scripsit:
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!!!!


Do you want to execute the query /on/ the array or do you want the
checkbox selection as parameter values?

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
Nov 20 '05 #3
"SM Lawless via .NET 247" <an*******@dotnet247.com> schrieb
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!


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/de...tingDataVB.asp
and
http://msdn.microsoft.com/library/en...withadonet.asp
--
Armin

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

Nov 20 '05 #4
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
Nov 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: James Perry | last post by:
Hi, I have been trying to build an custom report interface for a charity manangement system; which is part of my dissertation. This interface will allow the chairty to input a SQL query and...
4
by: Diamondback | last post by:
I have two tables, WIDGETS and VERSIONS. The WIDGETS table has descriptive information about the widgets while the VERSIONS table contains IDs relating to different iterations of those widgets...
3
by: cover | last post by:
I have a table with 50 fields that receive input depending on whether that input came in from a 'shaker' form or a 'conveyor' form. Input from the 'conveyor' form might populate 25 fields while...
4
by: frizzle | last post by:
Hi there, Still building my forum. I have a certain mysql-query i just can't figure out. These are my tables (simplified): categories -> id, description forums -> id, cat_id,...
1
by: DavidB | last post by:
I am working with a database and I would like to be able to populate an array at run time and then use the values that were pushed into the array as criteria for a select query. It seems that this...
13
by: Karl Groves | last post by:
I'm missing something very obvious, but it is getting late and I've stared at it too long. TIA for responses I am writing a basic function (listed at the bottom of this post) that returns...
1
by: Kurt Jakobsen | last post by:
Hello, I have a MySQL query that I want to perform in a utility (not page) class. This query should fill up an array of string's and then return the array to the calling class. The array will then...
14
by: gert | last post by:
Why does query = www ? int main(void) { char *user="www"; char *password=""; char *database="www"; char *query={"SHOW DATABASES;"}; db(user,password,database,query);
4
by: TechnoAtif | last post by:
Hi ALL I have entered some array values using checkboxes into mysql database through a form. Next iam creating a searchpage where all those cateogories inserted through checkboxes has to be...
4
by: zion4ever | last post by:
Hello good people, Please bear with me as this is my first post and I am relative new to ASP. I do have VB6 experience. I have a form which enables users within our company to do an intranet...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.