hey all,
what's the best way to get database records into an array?
thanks,
rodchar
2  1846 
"rodchar" <ro*****@discus sions.microsoft .com> wrote in message
news:A0******** *************** ***********@mic rosoft.com... hey all,
what's the best way to get database records into an array?
thanks,
rodchar
When you say "database records" are you referring to rows in a DataTable as
retrieved using a SQL query? Typically, such rows consist of multiple fields
with disparate data types. Arrays, by default, store multiple instances of a
single data type. Are you trying to create an array of DataRow objects?
If you could be a bit more specific about what you intend to store in your
array, I'm sure better answers will appear.
--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
please disregard this. i'm confusing myself.
"pvdg42" wrote:
"rodchar" <ro*****@discus sions.microsoft .com> wrote in message
news:A0******** *************** ***********@mic rosoft.com... hey all,
what's the best way to get database records into an array?
thanks,
rodchar
When you say "database records" are you referring to rows in a DataTable as
retrieved using a SQL query? Typically, such rows consist of multiple fields
with disparate data types. Arrays, by default, store multiple instances of a
single data type. Are you trying to create an array of DataRow objects?
If you could be a bit more specific about what you intend to store in your
array, I'm sure better answers will appear.
--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Haydnw |
last post by:
Hi,
I'd like to put a load of database results (several rows for 5 fields) into
a two-dimensional array. Now, this may be a really stupid question, but can
someone give me a pointer for how to do it? I can bind data to datagrids and
lists and stuff all day long, but can't seem to grasp this one. Any pointers
to a useful article / demo (or just any useful pointers!) would be much
appreciated.
Thanks,
|
by: Bob Sanderson |
last post by:
I have created a MySQL database for my company which is accessed by PHP
pages. I would like to permit some users to edit the records but allow
others read-only access. However, I don't want to have to enter a password
every time I want to edit a record. Is there a way to use our network login
to do this? If not, what is the easiest way to accomplish this? The
database is running on our server and is not accessible via the net.
Any help...
|
by: Ian Davies |
last post by:
Hello
Needing help with a suitable solution.
I have extracted records into a table under three columns 'category',
'comment' and share (the category column also holds the index no of the
record in a hidden field)
I wish the user to be able to edit the data in the table, so I have
extracted the records into hiddenfield, textareas, dropdown list and
checkbox so that they can make changes.
I named these elements as arrays and wish to run an...
|
by: Susan Mackay |
last post by:
I have a data table that is connected to a database table with a data
adapter in the 'standard' manner.
However I want to be able to remove selected rows from the data table (i.e.
no longer include them in the set that is displayed to the user) but I don't
want to delete the corresponding row from the database.
I've tried using the .Rows.Remove() method but an exception is thrown to say
I don't have a 'delete' command in the data...
|
by: gmccammon |
last post by:
I am working on a class assignment where I have to connect to an MS Access database. The perl script is contained in a separate file *.pl
I went into Control panel/ODBC/ and selected Microsoft Access driver and identified the source name.
I was looking at a previous post here and many things appear to be similar to my requirements.
1. Add dbi inclusion. (pretty straight forward, like an “include” in C or “import” in Java
use...
| | |
by: ianenis.tiryaki |
last post by:
well i got this assignment which i dont even have a clue what i am
supposed to do. it is about reading me data from the file and load
them into a parallel array here is the question:
Step (1)
Your first task is to write a program which reads this file into two
parallel arrays in memory. One array contains the titles, and the
other array contains the authors. The arrays are 'parallel' in the
sense that the n-th element of the authors...
|
by: Muchach |
last post by:
Hello,
Ok so what I've got going on is a form that is populated by pulling
info from database then using php do{} to create elements in form. I
have a text box in each table row for the user to enter input. I need
to take this user input and put it back into the database. What would
be the best method to do this. I can't use a normal post because the
name of the text box is the same for each table row. I've heard that
posting the...
|
by: dheroan |
last post by:
Hi there,
I'm fairly new to using databases with VB .NET. I'm currently working on an application using a Microsoft Access database as a data source. I have created a form to display the fields for each record in a particular table (using the feature that allows you to drag and drop a field from a table in the database onto the form, automatically attaching a BindingNavigator and TableAdapter and all that jazz to it). As you probably know,...
|
by: Dhiru1009 |
last post by:
Hi guys,
I am trying to build a user registration form using PHP and MYSQL but encountring a problem.
When I click on submit with empty fields it adds records to database also it doesn't matter what information I put it always add records to database when I click on submit. What can I do to make sure user will not be able to add records to database until he enters the right information?
I am posting my code for you guys to have a look...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
