I had a random thought today. Is it possible to make a complete application
with several forms that contain databound info such as textboxes or
dataGridViews and use 1 and only 1 dataset for the entire application?
I ask because, when I created my program, for each and every form that has
databound information, there is a dataset that is created.
Now, correct me if I'm wrong, but when a tableAdapter, or DataTable is
associated with the dataset, doesn't that contact the dataSource (ie. DB on
server or remote location) during a fill(dtTableName) using excessive
bandwidth? I ask about the bandwidth issue because I have an application
that fills from the Products table of the database which contains over 6000+
records. I have 3 different forms that need to fill a tableAdapter from the
Products table of the DB. Couldn't I just use the ONE dataset that might be
Public to the entire app and grab the info from there. I understand that
when changes are made and saved, then they will be saved to the dataSource
which uses bandwidth but having to fill the info everytime I need to use a
table from the DB takes a while to load the records.
I hope to be schooled here since I mostly know about the drag and drop
methods shown from online tutorials from Microsoft's Webcasts page.
Unfortunately, I am using an Access DB on a mapped network drive but there
has to be an easier/faster way of retrieving the data I need, right?
Tony K. 3 848
Yes.
"Tony K" <my*********@kingprogramming.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...
>I had a random thought today. Is it possible to make a complete application with several forms that contain databound info such as textboxes or dataGridViews and use 1 and only 1 dataset for the entire application?
I ask because, when I created my program, for each and every form that has
databound information, there is a dataset that is created.
Now, correct me if I'm wrong, but when a tableAdapter, or DataTable is
associated with the dataset, doesn't that contact the dataSource (ie. DB
on server or remote location) during a fill(dtTableName) using excessive
bandwidth? I ask about the bandwidth issue because I have an application
that fills from the Products table of the database which contains over
6000+ records. I have 3 different forms that need to fill a tableAdapter
from the Products table of the DB. Couldn't I just use the ONE dataset
that might be Public to the entire app and grab the info from there. I
understand that when changes are made and saved, then they will be saved
to the dataSource which uses bandwidth but having to fill the info
everytime I need to use a table from the DB takes a while to load the
records.
I hope to be schooled here since I mostly know about the drag and drop
methods shown from online tutorials from Microsoft's Webcasts page.
Unfortunately, I am using an Access DB on a mapped network drive but there
has to be an easier/faster way of retrieving the data I need, right?
Tony K.
Tony,
Is has not to be Global, all in OOP goes about references.
Let say you create a class like this
Public Class Whatever
private myDataSet as DataSet 'This is nothing more then a placeholder for
the reference
Public sub New(byval ds as DataSet)
myDataSet = ds
End Sub
End Class
And you call that sub by
dim myWhatEver as Whatever(TheDataSetIHaveFilled)
Then you can use that dataset in that class.
Cor
"Tony K" <my*********@kingprogramming.comschreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
>I had a random thought today. Is it possible to make a complete application with several forms that contain databound info such as textboxes or dataGridViews and use 1 and only 1 dataset for the entire application?
I ask because, when I created my program, for each and every form that has
databound information, there is a dataset that is created.
Now, correct me if I'm wrong, but when a tableAdapter, or DataTable is
associated with the dataset, doesn't that contact the dataSource (ie. DB
on server or remote location) during a fill(dtTableName) using excessive
bandwidth? I ask about the bandwidth issue because I have an application
that fills from the Products table of the database which contains over
6000+ records. I have 3 different forms that need to fill a tableAdapter
from the Products table of the DB. Couldn't I just use the ONE dataset
that might be Public to the entire app and grab the info from there. I
understand that when changes are made and saved, then they will be saved
to the dataSource which uses bandwidth but having to fill the info
everytime I need to use a table from the DB takes a while to load the
records.
I hope to be schooled here since I mostly know about the drag and drop
methods shown from online tutorials from Microsoft's Webcasts page.
Unfortunately, I am using an Access DB on a mapped network drive but there
has to be an easier/faster way of retrieving the data I need, right?
Tony K.
Thanks Cor. That makes sense.
Tony
"Cor Ligthert[MVP]" <no************@planet.nlwrote in message
news:A0**********************************@microsof t.com...
Tony,
Is has not to be Global, all in OOP goes about references.
Let say you create a class like this
Public Class Whatever
private myDataSet as DataSet 'This is nothing more then a placeholder for
the reference
Public sub New(byval ds as DataSet)
myDataSet = ds
End Sub
End Class
And you call that sub by
dim myWhatEver as Whatever(TheDataSetIHaveFilled)
Then you can use that dataset in that class.
Cor
"Tony K" <my*********@kingprogramming.comschreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
>>I had a random thought today. Is it possible to make a complete application with several forms that contain databound info such as textboxes or dataGridViews and use 1 and only 1 dataset for the entire application?
I ask because, when I created my program, for each and every form that has databound information, there is a dataset that is created.
Now, correct me if I'm wrong, but when a tableAdapter, or DataTable is associated with the dataset, doesn't that contact the dataSource (ie. DB on server or remote location) during a fill(dtTableName) using excessive bandwidth? I ask about the bandwidth issue because I have an application that fills from the Products table of the database which contains over 6000+ records. I have 3 different forms that need to fill a tableAdapter from the Products table of the DB. Couldn't I just use the ONE dataset that might be Public to the entire app and grab the info from there. I understand that when changes are made and saved, then they will be saved to the dataSource which uses bandwidth but having to fill the info everytime I need to use a table from the DB takes a while to load the records.
I hope to be schooled here since I mostly know about the drag and drop methods shown from online tutorials from Microsoft's Webcasts page.
Unfortunately, I am using an Access DB on a mapped network drive but there has to be an easier/faster way of retrieving the data I need, right?
Tony K. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Julian Campbell |
last post by:
I have for a few weeks now been looking to improove my computer skills. I
have been looking at learning VB but would like to know what exactly I can
use it for!!! ( I said it may be stupid ) I...
|
by: rhat |
last post by:
I heard that beta 2 now makes ASP.NET xhtml compliant.
Can anyone shed some light on what this will change and it will break stuff
as converting HTML to XHTML pages DO break things. see,...
|
by: Hoopster |
last post by:
Hello,
I know nothing about C++ but want to get started.
Is there any good free C++ program that I can try to see if I like
programming? I also need a good free compiler. I don't want to...
|
by: Agnes |
last post by:
I am so stupid that Got a object declaration question, Anyone, please be
kind to reply me.
I got a datagrid which got a button in each row , the user will do the
searching in it,
If the user do...
|
by: Adam Smith |
last post by:
I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that this then 'Must be a
stupid question' although people say that there is no...
|
by: K8CPA |
last post by:
Hi Guys,
I've got a question from a stupid question from a clueless computer
operator's standpoint.
I use Windows XP. SP2, and I've got all these neat little programs.
What language do they...
|
by: SR |
last post by:
What group would be best for posting a question about ASP.NET 2.0 using
Master/Content pages? I am trying to assign a style sheet to a content page
and I have no idea how to do so...
TIA
|
by: Malvolio |
last post by:
I know this is a *really* stupid question but what the hell is visual
c++? I downloaded it and it doesn't seem to work. It isn't like any c++
compiler I ever saw before and the manual on the...
|
by: Leslie Kis-Adam |
last post by:
Hi everyone!
Can anyone explain me this program?
I'm getting really confused.
thx in advance.
Laszlo Kis-Adam
<dfighter@freemail.hu>
"
|
by: AWW |
last post by:
Running XP - Visual Studio 2005 - VB
Want to have duplicate projects
- one safe and stable
- other for experimenting
Can't fine easy way to make duplicate project.
Stupid question? or stupid ME?...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
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: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
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...
| |