Hello,
I'm developing an application with one parent table and 12 child tables.
The parent table is patient information and the children contain such things
as lab results, medications, emergency room visits, etc. I'm trying to
decide how many gridview and sqldatasource controls is too many for one page.
I like the way the user interface works with everything on one page where
they can select a parent record from a gridview control then with a drop down
select the one child they want to view or edit. I would have a gridview and
sqldatasource for each child table and simply use the visible property to
show the one corresponding to what they select from the dropdown. I have it
working with 3 at the moment and it works fine but that's only 3 and it's on
my local machine. I've never put 12 of each on a page so I don't know what
issues I may encounter. Good idea? Bad idea? Would it be better to break
it out into 12 separate pages? Other suggestions?
8  1179 
"Tim Tafflinger" <Ti***********@ discussions.mic rosoft.comwrote in message
news:05******** *************** ***********@mic rosoft.com...
Would it be better to break it out into 12 separate pages?
Not necessarily into 12 separate pages, but I would certainly not show more
than a couple of GridViews at a time - generally speaking, people don't
really take in information overload...
Other suggestions?
Use a DAL - then you wouldn't have to use any SqlDataSources at all... http://www.microsoft.com/downloads/d...displaylang=en
--
Mark Rae
ASP.NET MVP http://www.markrae.net
Hi Mark, I'm only showing 2 gridviews at a time. One is the parent table
and the other is the one showing the child information they choose from a
dropdown. All the other child gridviews are set to invisible. When they
make a new selection I set the visible property of the one being viewed to
false and the visible property of the one selected to true.
So you don't think having that mamy gridviews on one page will be an issue
as far as stability, response, etc.?
I'll look at implementing a DAL. Thanks!
"Mark Rae [MVP]" wrote:
"Tim Tafflinger" <Ti***********@ discussions.mic rosoft.comwrote in message
news:05******** *************** ***********@mic rosoft.com...
Would it be better to break it out into 12 separate pages?
Not necessarily into 12 separate pages, but I would certainly not show more
than a couple of GridViews at a time - generally speaking, people don't
really take in information overload...
Other suggestions?
Use a DAL - then you wouldn't have to use any SqlDataSources at all...
http://www.microsoft.com/downloads/d...displaylang=en
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
"Tim Tafflinger" <Ti***********@ discussions.mic rosoft.comwrote in message
news:89******** *************** ***********@mic rosoft.com...
[top-posting corrected]
Would it be better to break it out into 12 separate pages?
Not necessarily into 12 separate pages, but I would certainly not show
more
than a couple of GridViews at a time - generally speaking, people don't
really take in information overload...
Other suggestions?
Use a DAL - then you wouldn't have to use any SqlDataSources at all...
http://www.microsoft.com/downloads/d...displaylang=en
So you don't think having that mamy gridviews on one page will be an issue
as far as stability, response, etc.?
So long as you only show them when needed, no..
I'll look at implementing a DAL.
Good idea.
--
Mark Rae
ASP.NET MVP http://www.markrae.net
as long as you turn viewstate off, otherwise the page size will be too large
for performance.
-- bruce (sqlwork.com)
"Tim Tafflinger" wrote:
Hi Mark, I'm only showing 2 gridviews at a time. One is the parent table
and the other is the one showing the child information they choose from a
dropdown. All the other child gridviews are set to invisible. When they
make a new selection I set the visible property of the one being viewed to
false and the visible property of the one selected to true.
So you don't think having that mamy gridviews on one page will be an issue
as far as stability, response, etc.?
I'll look at implementing a DAL. Thanks!
"Mark Rae [MVP]" wrote:
"Tim Tafflinger" <Ti***********@ discussions.mic rosoft.comwrote in message
news:05******** *************** ***********@mic rosoft.com...
Would it be better to break it out into 12 separate pages?
Not necessarily into 12 separate pages, but I would certainly not show more
than a couple of GridViews at a time - generally speaking, people don't
really take in information overload...
Other suggestions?
Use a DAL - then you wouldn't have to use any SqlDataSources at all...
http://www.microsoft.com/downloads/d...displaylang=en
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
I'd use MultiViews as you can add additional information if you need to. It
is alos much eaisier than managing visability for twelve controls.
"Tim Tafflinger" <Ti***********@ discussions.mic rosoft.comwrote in message
news:05******** *************** ***********@mic rosoft.com...
Hello,
I'm developing an application with one parent table and 12 child tables.
The parent table is patient information and the children contain such
things
as lab results, medications, emergency room visits, etc. I'm trying to
decide how many gridview and sqldatasource controls is too many for one
page.
I like the way the user interface works with everything on one page where
they can select a parent record from a gridview control then with a drop
down
select the one child they want to view or edit. I would have a gridview
and
sqldatasource for each child table and simply use the visible property to
show the one corresponding to what they select from the dropdown. I have
it
working with 3 at the moment and it works fine but that's only 3 and it's
on
my local machine. I've never put 12 of each on a page so I don't know
what
issues I may encounter. Good idea? Bad idea? Would it be better to
break
it out into 12 separate pages? Other suggestions?
Thanks Mark, Bruce, and Randy for your suggestions. I've researched and
implemented a DAL and was surprised to see that now instead of a dozen
sqldatasource controls it requires a dozen objectdatasourc e controls. I was
thinking I would end up with one control on the page for all my data access.
So the advantage must be the abstraction and not really a less complex page
or am I still missing the boat?
"Tim Tafflinger" wrote:
Hello,
I'm developing an application with one parent table and 12 child tables.
The parent table is patient information and the children contain such things
as lab results, medications, emergency room visits, etc. I'm trying to
decide how many gridview and sqldatasource controls is too many for one page.
I like the way the user interface works with everything on one page where
they can select a parent record from a gridview control then with a drop down
select the one child they want to view or edit. I would have a gridview and
sqldatasource for each child table and simply use the visible property to
show the one corresponding to what they select from the dropdown. I have it
working with 3 at the moment and it works fine but that's only 3 and it's on
my local machine. I've never put 12 of each on a page so I don't know what
issues I may encounter. Good idea? Bad idea? Would it be better to break
it out into 12 separate pages? Other suggestions?
"Tim Tafflinger" <Ti***********@ discussions.mic rosoft.comwrote in message
news:DE******** *************** ***********@mic rosoft.com...
Thanks Mark, Bruce, and Randy for your suggestions. I've researched and
implemented a DAL and was surprised to see that now instead of a dozen
sqldatasource controls it requires a dozen objectdatasourc e controls. I
was
thinking I would end up with one control on the page for all my data
access.
So the advantage must be the abstraction and not really a less complex
page
or am I still missing the boat?
Yes, I'm afraid you are...
A DAL does not require any SqlDataSource / ObjectDataSourc e controls -
that's the whole point...
--
Mark Rae
ASP.NET MVP http://www.markrae.net
Well, then here is my problem. With a sqldatasource or objectdatasourc e I
can pull data into a gridview and use the native edit, update, and delete
commands to manipulate data with my stored procs. I can also pull data into
a gridview using a method in my DAL, configured with the same stored procs,
but when I try to edit or delete I get an error that says the RowEditing or
RowDeleting event wasn't handled.
So, either the native data commands should still work and I have have
something configured wrong, or they aren't supposed to work and I need to
capture those events and use the methods in my DAL to manipulate the data.
Which is it?
"Mark Rae [MVP]" wrote:
"Tim Tafflinger" <Ti***********@ discussions.mic rosoft.comwrote in message
news:DE******** *************** ***********@mic rosoft.com...
Thanks Mark, Bruce, and Randy for your suggestions. I've researched and
implemented a DAL and was surprised to see that now instead of a dozen
sqldatasource controls it requires a dozen objectdatasourc e controls. I
was
thinking I would end up with one control on the page for all my data
access.
So the advantage must be the abstraction and not really a less complex
page
or am I still missing the boat?
Yes, I'm afraid you are...
A DAL does not require any SqlDataSource / ObjectDataSourc e controls -
that's the whole point...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Frnak McKenney |
last post by:
Back when computer dinosaurs roamed the earth and the precursors to
today's Internet were tiny flocks of TDMs living symbiotically with
the silicon giants, tracking access to data processing resources was
much simpler: you logged in with a userID and password, and when
you were done you ended your session by logging out (or occasionally
by being disconnected). Connection time was easy to measure, and it
made sense to both the customer...
|
by: Litron |
last post by:
Appologies, this isn't really a javascript specific question....
Just wondering what the current size standard is for web-page design...
it used to be 800 x 600 pxls (which seems quite small these days).
Any suggestions.
Thanx in advance,
Litron
|
by: Felix Kater |
last post by:
Hi,
when I need to execute a general clean-up procedure (inside of a
function) just before the function returns -- how do I do that when
there are several returns spread over the whole function?
My first approach: Use "while(1)" and "break", however this doesn't work
if there is another loop inside (since I can't break two loops at the
same time):
|
by: JezB |
last post by:
What's the generally accepted approach for using Styles and Stylesheets in a
web application based on .aspx files, Web Controls, User Controls, and
code-behind modules (c# in my case)? Most style and stylesheet guides on the
internet seem to be based on web sites (rather than applications) based on
relatively static textual information.
I have read that external stylesheet files are the way to go, but it seems
to me that these only lend...
|
by: Jeffrey |
last post by:
At the launch yesterday in San Francisco, I was told by MS technical staff
in the Q and A area that migrating my code from ASP.NET 1.1 to 2.0 should be
a "no rewrite anything" scenario. Aapparently I would just create a new 2.0
project, include all of my references, classes, aspx, asxc + code behind,
etc in the 2.0 project, and it "should just run" without any changes.
Granted, if I were to do that I wouldn't be taking advantage of any...
| | |
by: Christoph Zwerschke |
last post by:
Sometimes I find myself stumbling over Python issues which have to do
with what I perceive as a lack of orthogonality.
For instance, I just wanted to use the index() method on a tuple which
does not work. It only works on lists and strings, for no obvious
reason. Why not on all sequence types?
Or, another example, the index() method has start and end parameters for
lists and strings. The count() method also has start and end parameters...
|
by: MP |
last post by:
context:
vb6 / ado / adox 2.8/ mdb file format / jet 4.0 provider (not using Access)
trying to design first database
I work for a very small company, detailing building 'components'
There is currently no database usage in our company.
On my own time I'm trying to learn database/ado so as to improve the way we
work.
|
by: Tom Edelbrok |
last post by:
I'm reading the section "Postbacks and Round Trips" in the Visual Studio
2005 Help (I use VB.NET). Amongst other things, it says that as a result of
a postback "On the Web server, the page runs again. The information that the
user typed or selected is available to the page."
I can set this up in a test project and see that it occurs ... ie: my text
boxes retain their data (ie: "Hello world") even when a postback occurs on
the same or...
|
by: eholz1 |
last post by:
Hello PHP group,
I looks like this is a good forum to ask my question. I am using both
PHP and MySQL.
I would like/am designing a photo database for the web - not heavy duty
- not complex, like menalto Gallery, etc. My idea is to use PHP and
MySQL. I would like to store the images in the MySQL database, and
display them using PHP. I would like to have a table with thumbnail
images, that when "clicked" will link to a veiw page that...
|
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: 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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
