I have a form with 7 datagrids, each on a seperate tabpage and reading from
it's own dataTable. I would like to take the first three fields of each row
and show them in a listbox (for example, ID, first name and last name). I
know how to join them to create a single string and how to add them to the
listbox items collection, but is there an easy way of reading every single
row in my dataset, rather than reading each table one at a time? I seem to
have to use the same code 7 times just to add, delete, update or query the
data I.E query the Manager table, then the Cashier table, then the next, etc. 2 1649
I forgot to mention that I am working in C#
"cashdeskmac" wrote: I have a form with 7 datagrids, each on a seperate tabpage and reading from it's own dataTable. I would like to take the first three fields of each row and show them in a listbox (for example, ID, first name and last name). I know how to join them to create a single string and how to add them to the listbox items collection, but is there an easy way of reading every single row in my dataset, rather than reading each table one at a time? I seem to have to use the same code 7 times just to add, delete, update or query the data I.E query the Manager table, then the Cashier table, then the next, etc.
I was alreayd asking myself what language you where using
However probably you are looking for the the binding and the
currencymanager. http://msdn.microsoft.com/library/de...classtopic.asp http://msdn.microsoft.com/library/de...classtopic.asp
This is probably the right start, however next time I advise you when it
becomes probably more language related I advice you to ask it in the
newsgroup.
microsoft.public.dotnet.languages.csharp
I hope this helps so far,
Cor
"cashdeskmac" <ca*********@discussions.microsoft.com> schreef in bericht
news:EE**********************************@microsof t.com... I forgot to mention that I am working in C#
"cashdeskmac" wrote:
I have a form with 7 datagrids, each on a seperate tabpage and reading
from it's own dataTable. I would like to take the first three fields of each
row and show them in a listbox (for example, ID, first name and last name).
I know how to join them to create a single string and how to add them to
the listbox items collection, but is there an easy way of reading every
single row in my dataset, rather than reading each table one at a time? I seem
to have to use the same code 7 times just to add, delete, update or query
the data I.E query the Manager table, then the Cashier table, then the next,
etc. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Piyoosh Rai |
last post by:
Hi,
I have multiple XML files that I am reading into a DataSet in C#. What I
would want to do it Create Tables from the DataSet in the destination
database and fill the tables with data from the...
|
by: Bill C. |
last post by:
Hi,
I've got a simple console app that just reads an XML file into a DataSet
then prints out a description of each table in the DataSet, including
column names and row values for each column. ...
|
by: |
last post by:
Hi,
I have an app that uses a typed dataset to persist user data. The dataset
has a multiple tables with multiple table relations. The problem I am
running into is that the user data is...
|
by: Ahmet Karaca |
last post by:
Hi.
myds.Reset();
mycommand.SelectCommand.CommandText=
"Select att1 from Ing as Ingredient, Pro as Product "+
"where Pro.ad='apple' and Pro.id=Ing.id";
mycommand.Fill(myds, "Product"); // Here...
|
by: Graham |
last post by:
I have been having some fun learning and using the new Controls and methods in .Net 2.0 which will make my life in the future easier and faster. Specifically the new databinding practises and...
|
by: sneha123 |
last post by:
There will be some 20 questions and for each question there will be 4
choices.what i want to do is to select multiple answers by clicking the
checkbox. i m using asp.net,vb.net
pls help me
we...
|
by: jaYPee |
last post by:
I have search a lot of thread in google newsgroup and read a lot of
articles but still i don't know how to update the dataset that has 3
tables.
my 3 tables looks like the 3 tables from...
|
by: Jason L James |
last post by:
Hi all,
does anyone know if I can create a dataview
from multiple datatables. My dataset is constructed
from four separate tables and then the relationships
are added that link the tables...
|
by: Dave Edwards |
last post by:
I understand that I can fill a datagrid with multiple queries, but I cannot
figure out how to fill a dataset with the same query but run against
multiple SQL servers, the query , table structure...
|
by: =?Utf-8?B?TG9zdEluTUQ=?= |
last post by:
Hi All :)
I'm converting VB6 using True DBGrid Pro 8.0 to VB2005 using DataGridView.
True DBGrid has a MultipleLines property that controls whether individual
records span multiple lines. Is...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
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,...
|
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...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
| |