473,325 Members | 2,872 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,325 software developers and data experts.

Stupid Question..Maybe

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.

Jun 27 '08 #1
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.
Jun 27 '08 #2
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.
Jun 27 '08 #3
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.

Jun 27 '08 #4

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

Similar topics

4
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...
119
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,...
36
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...
2
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...
6
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...
4
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...
2
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
6
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...
19
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> "
9
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?...
0
isladogs
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...
0
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...
0
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...
1
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)...
1
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...
1
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....
0
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
0
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...
0
isladogs
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 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.