how to split an array

Question

1.00/5 (1 vote)

See more:

I am using Ms access to design my project,

i retrived data from database using sql query database is access, it is workinf properly.

sqlstring="select product_name,product_id from products where status=pending";

it is retriving data,

my problem is how can i divide the array and how to assign that divided value to a text box

Posted 5-Mar-12 18:51pm

janareddyjanareddy

Add a Solution

Comments

Sergey Alexandrovich Kryukov 6-Mar-12 0:53am

What's "divide" and why? You divide it the way you want. What's the problem?
--SA

OriginalGriff 6-Mar-12 2:43am

You don't get "an array" back, so it is difficult to work out what exactly you are trying to do.
Try giving an example: show us a short version of your SQL table, the SQL query (which you have done) and the output you want in your textbox.
Use the "Improve question" widget to edit your question and provide better information.

janareddyjanareddy 6-Mar-12 5:53am

I want to get the result of query into an array and split it to display value in textbox and how can i do that in vb

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rahul Rajat Singh · Answer 1 · 2012-03-06T22:18:00

Solution 1

I think you will not be needing an array. use same query and catch the result in a datatable. If if is returning only one row with 6 columns then you can access each element as:

dTable.Rows[0][0] ....... dTable.Rows[0][5]

Posted 6-Mar-12 22:18pm

Rahul Rajat Singh

Libish Varghese Jacob · Answer 2 · 2012-05-30T01:15:00

Solution 2

I have not gone through your requirement, but hope you can create a logic out of the below link.

How to split an array into multiple arrays[^]

Posted 30-May-12 1:15am

Libish Varghese Jacob

v2