I have somewhat of an interesting scenario:
The form allows the user to select a service, which populates a a grid of
product information related to that service ("service grid"). The user can
then select from the products in the first grid and those choices populate
the second "choices grid".
The product grid is bound to a strongly-typed dataset table which can be
filled in a couple of different ways. More on this shortly.
The choices datatable contains expression columns related to a product
table. So if the user choses Widget A, B, and C, the product prices and a
lot of other details for that service are reflected into the choices grid
without those values actually being duplicated into the choices table.
All of the structure works well technically. But there is a fundamental
concept decision to be made. That decision is in how to populate the
products table. At some future date, the product catalog may grow to be
50,000, 100,000 or even greater. My instinct is to individually populate the
products datatable with ONLY the Widgets that relate to Service1 when it is
selected, and then ONLY populate the widgets that releate to Service 2 when
it is selected (each service requires a subset of the entire product
catalog, thus limiting how big the product table may be).
Where this becomes problematic is that the user may need 2 or more Services.
So if they select products that relate to Service 1, Service 2, etc., then
the catalog to be displayed must grow much bigger. Displaying just one set
of products at a time will not work because this would cause a partial
display of the expression columns in the choices grid (since the
non-populated products still have a primary key back to the products table,
they display a row, but not the expression data).
The easiest answer would be to just populate the entire catalog in the
products grid. Of course, the easiest solution is the most expensive in
terms of database and processor resources. The next easiest answer would be
to populate the product grid with just one set of products at a time. But
this creates the above-mentioned issue with the expression columns.
The technical implementation is not an issue. I'm just looking for some
ideas or thoughts from anyone who has been down this road with multiple
grids and expression columns.
9  965 
How does this question relate specifically to C# and VB.NET? Wouldn't you
think that ADO.NET is solely the perfect place for this post? Guess not.
How about sharing the project type you are working on (ASP.NET/Windows
Forms)?
"Earl" <br******@newsgroups.nospamwrote in message
news:uA*************@TK2MSFTNGP02.phx.gbl...
>I have somewhat of an interesting scenario:
The form allows the user to select a service, which populates a a grid of
product information related to that service ("service grid"). The user can
then select from the products in the first grid and those choices populate
the second "choices grid".
The product grid is bound to a strongly-typed dataset table which can be
filled in a couple of different ways. More on this shortly.
The choices datatable contains expression columns related to a product
table. So if the user choses Widget A, B, and C, the product prices and a
lot of other details for that service are reflected into the choices grid
without those values actually being duplicated into the choices table.
All of the structure works well technically. But there is a fundamental
concept decision to be made. That decision is in how to populate the
products table. At some future date, the product catalog may grow to be
50,000, 100,000 or even greater. My instinct is to individually populate
the products datatable with ONLY the Widgets that relate to Service1 when
it is selected, and then ONLY populate the widgets that releate to Service
2 when it is selected (each service requires a subset of the entire
product catalog, thus limiting how big the product table may be).
Where this becomes problematic is that the user may need 2 or more
Services. So if they select products that relate to Service 1, Service 2,
etc., then the catalog to be displayed must grow much bigger. Displaying
just one set of products at a time will not work because this would cause
a partial display of the expression columns in the choices grid (since the
non-populated products still have a primary key back to the products
table, they display a row, but not the expression data).
The easiest answer would be to just populate the entire catalog in the
products grid. Of course, the easiest solution is the most expensive in
terms of database and processor resources. The next easiest answer would
be to populate the product grid with just one set of products at a time.
But this creates the above-mentioned issue with the expression columns.
The technical implementation is not an issue. I'm just looking for some
ideas or thoughts from anyone who has been down this road with multiple
grids and expression columns.
I've often heard that the definition of a literalist is one who, upon seeing
the writing on the wall, stops to examine the penmanship. "Specifically," C#
and VB.Net are quite broad in scope. Since the question involved the
resources of both ADO.Net and the concept as a whole, it would seem that a
more general audience might have had some insight (the resolution was in
fact to simplify the form and roll up one of the tables). It was a winforms
app.
"Scott M." <s-***@nospam.nospamwrote in message
news:ua**************@TK2MSFTNGP03.phx.gbl...
How does this question relate specifically to C# and VB.NET? Wouldn't you
think that ADO.NET is solely the perfect place for this post? Guess not.
How about sharing the project type you are working on (ASP.NET/Windows
Forms)?
"Earl" <br******@newsgroups.nospamwrote in message
news:uA*************@TK2MSFTNGP02.phx.gbl...
>>I have somewhat of an interesting scenario:
The form allows the user to select a service, which populates a a grid of
product information related to that service ("service grid"). The user
can then select from the products in the first grid and those choices
populate the second "choices grid".
The product grid is bound to a strongly-typed dataset table which can be
filled in a couple of different ways. More on this shortly.
The choices datatable contains expression columns related to a product
table. So if the user choses Widget A, B, and C, the product prices and a
lot of other details for that service are reflected into the choices grid
without those values actually being duplicated into the choices table.
All of the structure works well technically. But there is a fundamental
concept decision to be made. That decision is in how to populate the
products table. At some future date, the product catalog may grow to be
50,000, 100,000 or even greater. My instinct is to individually populate
the products datatable with ONLY the Widgets that relate to Service1 when
it is selected, and then ONLY populate the widgets that releate to
Service 2 when it is selected (each service requires a subset of the
entire product catalog, thus limiting how big the product table may be).
Where this becomes problematic is that the user may need 2 or more
Services. So if they select products that relate to Service 1, Service 2,
etc., then the catalog to be displayed must grow much bigger. Displaying
just one set of products at a time will not work because this would cause
a partial display of the expression columns in the choices grid (since
the non-populated products still have a primary key back to the products
table, they display a row, but not the expression data).
The easiest answer would be to just populate the entire catalog in the
products grid. Of course, the easiest solution is the most expensive in
terms of database and processor resources. The next easiest answer would
be to populate the product grid with just one set of products at a time.
But this creates the above-mentioned issue with the expression columns.
The technical implementation is not an issue. I'm just looking for some
ideas or thoughts from anyone who has been down this road with multiple
grids and expression columns.
In general, it is best to post your question to the group that is most
relevant to your question and then if you don't find what you are looking
for to broaden the scope of the audience. That is simple newsgroup
etiquitte.
Your question is clearly an ADO.NET question who's solution is NOT language
specific.
"Earl" <br******@newsgroups.nospamwrote in message
news:OQ**************@TK2MSFTNGP03.phx.gbl...
I've often heard that the definition of a literalist is one who, upon
seeing the writing on the wall, stops to examine the penmanship.
"Specifically," C# and VB.Net are quite broad in scope. Since the question
involved the resources of both ADO.Net and the concept as a whole, it
would seem that a more general audience might have had some insight (the
resolution was in fact to simplify the form and roll up one of the
tables). It was a winforms app.
"Scott M." <s-***@nospam.nospamwrote in message
news:ua**************@TK2MSFTNGP03.phx.gbl...
>How does this question relate specifically to C# and VB.NET? Wouldn't
you think that ADO.NET is solely the perfect place for this post? Guess
not. How about sharing the project type you are working on
(ASP.NET/Windows Forms)?
"Earl" <br******@newsgroups.nospamwrote in message
news:uA*************@TK2MSFTNGP02.phx.gbl...
>>>I have somewhat of an interesting scenario:
The form allows the user to select a service, which populates a a grid
of product information related to that service ("service grid"). The
user can then select from the products in the first grid and those
choices populate the second "choices grid".
The product grid is bound to a strongly-typed dataset table which can be
filled in a couple of different ways. More on this shortly.
The choices datatable contains expression columns related to a product
table. So if the user choses Widget A, B, and C, the product prices and
a lot of other details for that service are reflected into the choices
grid without those values actually being duplicated into the choices
table.
All of the structure works well technically. But there is a fundamental
concept decision to be made. That decision is in how to populate the
products table. At some future date, the product catalog may grow to be
50,000, 100,000 or even greater. My instinct is to individually populate
the products datatable with ONLY the Widgets that relate to Service1
when it is selected, and then ONLY populate the widgets that releate to
Service 2 when it is selected (each service requires a subset of the
entire product catalog, thus limiting how big the product table may be).
Where this becomes problematic is that the user may need 2 or more
Services. So if they select products that relate to Service 1, Service
2, etc., then the catalog to be displayed must grow much bigger.
Displaying just one set of products at a time will not work because this
would cause a partial display of the expression columns in the choices
grid (since the non-populated products still have a primary key back to
the products table, they display a row, but not the expression data).
The easiest answer would be to just populate the entire catalog in the
products grid. Of course, the easiest solution is the most expensive in
terms of database and processor resources. The next easiest answer would
be to populate the product grid with just one set of products at a time.
But this creates the above-mentioned issue with the expression columns.
The technical implementation is not an issue. I'm just looking for some
ideas or thoughts from anyone who has been down this road with multiple
grids and expression columns.
Earl,
I think I understand what you are asking. See if this makes sense.
It sounds as though you could use a seperate datatable to populate with the
selected products only. You're choices would then link to that datatable
instead of the selection datatable.
--
Tom Garth
"Earl" wrote:
I have somewhat of an interesting scenario:
The form allows the user to select a service, which populates a a grid of
product information related to that service ("service grid"). The user can
then select from the products in the first grid and those choices populate
the second "choices grid".
The product grid is bound to a strongly-typed dataset table which can be
filled in a couple of different ways. More on this shortly.
The choices datatable contains expression columns related to a product
table. So if the user choses Widget A, B, and C, the product prices and a
lot of other details for that service are reflected into the choices grid
without those values actually being duplicated into the choices table.
All of the structure works well technically. But there is a fundamental
concept decision to be made. That decision is in how to populate the
products table. At some future date, the product catalog may grow to be
50,000, 100,000 or even greater. My instinct is to individually populate the
products datatable with ONLY the Widgets that relate to Service1 when it is
selected, and then ONLY populate the widgets that releate to Service 2 when
it is selected (each service requires a subset of the entire product
catalog, thus limiting how big the product table may be).
Where this becomes problematic is that the user may need 2 or more Services.
So if they select products that relate to Service 1, Service 2, etc., then
the catalog to be displayed must grow much bigger. Displaying just one set
of products at a time will not work because this would cause a partial
display of the expression columns in the choices grid (since the
non-populated products still have a primary key back to the products table,
they display a row, but not the expression data).
The easiest answer would be to just populate the entire catalog in the
products grid. Of course, the easiest solution is the most expensive in
terms of database and processor resources. The next easiest answer would be
to populate the product grid with just one set of products at a time. But
this creates the above-mentioned issue with the expression columns.
The technical implementation is not an issue. I'm just looking for some
ideas or thoughts from anyone who has been down this road with multiple
grids and expression columns.
Thanks Tom, I think you are right. My short-term solution was to simplify
the concept which I may later need to revisit.
"Tom Garth" <To******@discussions.microsoft.comwrote in message
news:EE**********************************@microsof t.com...
Earl,
I think I understand what you are asking. See if this makes sense.
It sounds as though you could use a seperate datatable to populate with
the
selected products only. You're choices would then link to that datatable
instead of the selection datatable.
--
Tom Garth
"Earl" wrote:
>I have somewhat of an interesting scenario:
The form allows the user to select a service, which populates a a grid of
product information related to that service ("service grid"). The user
can
then select from the products in the first grid and those choices
populate
the second "choices grid".
The product grid is bound to a strongly-typed dataset table which can be
filled in a couple of different ways. More on this shortly.
The choices datatable contains expression columns related to a product
table. So if the user choses Widget A, B, and C, the product prices and a
lot of other details for that service are reflected into the choices grid
without those values actually being duplicated into the choices table.
All of the structure works well technically. But there is a fundamental
concept decision to be made. That decision is in how to populate the
products table. At some future date, the product catalog may grow to be
50,000, 100,000 or even greater. My instinct is to individually populate
the
products datatable with ONLY the Widgets that relate to Service1 when it
is
selected, and then ONLY populate the widgets that releate to Service 2
when
it is selected (each service requires a subset of the entire product
catalog, thus limiting how big the product table may be).
Where this becomes problematic is that the user may need 2 or more
Services.
So if they select products that relate to Service 1, Service 2, etc.,
then
the catalog to be displayed must grow much bigger. Displaying just one
set
of products at a time will not work because this would cause a partial
display of the expression columns in the choices grid (since the
non-populated products still have a primary key back to the products
table,
they display a row, but not the expression data).
The easiest answer would be to just populate the entire catalog in the
products grid. Of course, the easiest solution is the most expensive in
terms of database and processor resources. The next easiest answer would
be
to populate the product grid with just one set of products at a time. But
this creates the above-mentioned issue with the expression columns.
The technical implementation is not an issue. I'm just looking for some
ideas or thoughts from anyone who has been down this road with multiple
grids and expression columns.
I don't need a lecture from some twinkie. If you don't have an answer, stay
out of the thread.
"Scott M." <s-***@nospam.nospamwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
In general, it is best to post your question to the group that is most
relevant to your question and then if you don't find what you are looking
for to broaden the scope of the audience. That is simple newsgroup
etiquitte.
Your question is clearly an ADO.NET question who's solution is NOT
language specific.
"Earl" <br******@newsgroups.nospamwrote in message
news:OQ**************@TK2MSFTNGP03.phx.gbl...
>I've often heard that the definition of a literalist is one who, upon
seeing the writing on the wall, stops to examine the penmanship.
"Specifically," C# and VB.Net are quite broad in scope. Since the
question involved the resources of both ADO.Net and the concept as a
whole, it would seem that a more general audience might have had some
insight (the resolution was in fact to simplify the form and roll up one
of the tables). It was a winforms app.
"Scott M." <s-***@nospam.nospamwrote in message
news:ua**************@TK2MSFTNGP03.phx.gbl...
>>How does this question relate specifically to C# and VB.NET? Wouldn't
you think that ADO.NET is solely the perfect place for this post? Guess
not. How about sharing the project type you are working on
(ASP.NET/Windows Forms)?
"Earl" <br******@newsgroups.nospamwrote in message
news:uA*************@TK2MSFTNGP02.phx.gbl...
I have somewhat of an interesting scenario:
The form allows the user to select a service, which populates a a grid
of product information related to that service ("service grid"). The
user can then select from the products in the first grid and those
choices populate the second "choices grid".
The product grid is bound to a strongly-typed dataset table which can
be filled in a couple of different ways. More on this shortly.
The choices datatable contains expression columns related to a product
table. So if the user choses Widget A, B, and C, the product prices and
a lot of other details for that service are reflected into the choices
grid without those values actually being duplicated into the choices
table.
All of the structure works well technically. But there is a fundamental
concept decision to be made. That decision is in how to populate the
products table. At some future date, the product catalog may grow to be
50,000, 100,000 or even greater. My instinct is to individually
populate the products datatable with ONLY the Widgets that relate to
Service1 when it is selected, and then ONLY populate the widgets that
releate to Service 2 when it is selected (each service requires a
subset of the entire product catalog, thus limiting how big the product
table may be).
Where this becomes problematic is that the user may need 2 or more
Services. So if they select products that relate to Service 1, Service
2, etc., then the catalog to be displayed must grow much bigger.
Displaying just one set of products at a time will not work because
this would cause a partial display of the expression columns in the
choices grid (since the non-populated products still have a primary key
back to the products table, they display a row, but not the expression
data).
The easiest answer would be to just populate the entire catalog in the
products grid. Of course, the easiest solution is the most expensive in
terms of database and processor resources. The next easiest answer
would be to populate the product grid with just one set of products at
a time. But this creates the above-mentioned issue with the expression
columns.
The technical implementation is not an issue. I'm just looking for some
ideas or thoughts from anyone who has been down this road with multiple
grids and expression columns.
Earl,
If you cannot stand critique, stay out of the newsgroups.
However to answer your question. Forever look where is your biggest bottle
neck.
Making a column on a client will probably go in for humans not recognize
time while it is doing for one client x times and not for x clients x time.
Therefore if you can bring processing to the client than do that.
However it that means that you have to process and collect more data than
needed for the process on the server, than the server is in my idea the
right place.
Cor
"Earl" <br******@newsgroups.nospamschreef in bericht
news:u%****************@TK2MSFTNGP06.phx.gbl...
>I don't need a lecture from some twinkie. If you don't have an answer, stay
out of the thread.
"Scott M." <s-***@nospam.nospamwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
>In general, it is best to post your question to the group that is most
relevant to your question and then if you don't find what you are looking
for to broaden the scope of the audience. That is simple newsgroup
etiquitte.
Your question is clearly an ADO.NET question who's solution is NOT
language specific.
"Earl" <br******@newsgroups.nospamwrote in message
news:OQ**************@TK2MSFTNGP03.phx.gbl...
>>I've often heard that the definition of a literalist is one who, upon
seeing the writing on the wall, stops to examine the penmanship.
"Specifically," C# and VB.Net are quite broad in scope. Since the
question involved the resources of both ADO.Net and the concept as a
whole, it would seem that a more general audience might have had some
insight (the resolution was in fact to simplify the form and roll up one
of the tables). It was a winforms app.
"Scott M." <s-***@nospam.nospamwrote in message
news:ua**************@TK2MSFTNGP03.phx.gbl...
How does this question relate specifically to C# and VB.NET? Wouldn't
you think that ADO.NET is solely the perfect place for this post?
Guess not. How about sharing the project type you are working on
(ASP.NET/Windows Forms)?
"Earl" <br******@newsgroups.nospamwrote in message
news:uA*************@TK2MSFTNGP02.phx.gbl...
>I have somewhat of an interesting scenario:
>
The form allows the user to select a service, which populates a a grid
of product information related to that service ("service grid"). The
user can then select from the products in the first grid and those
choices populate the second "choices grid".
>
The product grid is bound to a strongly-typed dataset table which can
be filled in a couple of different ways. More on this shortly.
>
The choices datatable contains expression columns related to a product
table. So if the user choses Widget A, B, and C, the product prices
and a lot of other details for that service are reflected into the
choices grid without those values actually being duplicated into the
choices table.
>
All of the structure works well technically. But there is a
fundamental concept decision to be made. That decision is in how to
populate the products table. At some future date, the product catalog
may grow to be 50,000, 100,000 or even greater. My instinct is to
individually populate the products datatable with ONLY the Widgets
that relate to Service1 when it is selected, and then ONLY populate
the widgets that releate to Service 2 when it is selected (each
service requires a subset of the entire product catalog, thus limiting
how big the product table may be).
>
Where this becomes problematic is that the user may need 2 or more
Services. So if they select products that relate to Service 1, Service
2, etc., then the catalog to be displayed must grow much bigger.
Displaying just one set of products at a time will not work because
this would cause a partial display of the expression columns in the
choices grid (since the non-populated products still have a primary
key back to the products table, they display a row, but not the
expression data).
>
The easiest answer would be to just populate the entire catalog in the
products grid. Of course, the easiest solution is the most expensive
in terms of database and processor resources. The next easiest answer
would be to populate the product grid with just one set of products at
a time. But this creates the above-mentioned issue with the expression
columns.
>
The technical implementation is not an issue. I'm just looking for
some ideas or thoughts from anyone who has been down this road with
multiple grids and expression columns.
>
>
>
And, then come the insults....Instead of the "Yeah, I see your point,
sorry.".
"Earl" <br******@newsgroups.nospamwrote in message
news:u%****************@TK2MSFTNGP06.phx.gbl...
>I don't need a lecture from some twinkie. If you don't have an answer, stay
out of the thread.
"Scott M." <s-***@nospam.nospamwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
>In general, it is best to post your question to the group that is most
relevant to your question and then if you don't find what you are looking
for to broaden the scope of the audience. That is simple newsgroup
etiquitte.
Your question is clearly an ADO.NET question who's solution is NOT
language specific.
"Earl" <br******@newsgroups.nospamwrote in message
news:OQ**************@TK2MSFTNGP03.phx.gbl...
>>I've often heard that the definition of a literalist is one who, upon
seeing the writing on the wall, stops to examine the penmanship.
"Specifically," C# and VB.Net are quite broad in scope. Since the
question involved the resources of both ADO.Net and the concept as a
whole, it would seem that a more general audience might have had some
insight (the resolution was in fact to simplify the form and roll up one
of the tables). It was a winforms app.
"Scott M." <s-***@nospam.nospamwrote in message
news:ua**************@TK2MSFTNGP03.phx.gbl...
How does this question relate specifically to C# and VB.NET? Wouldn't
you think that ADO.NET is solely the perfect place for this post?
Guess not. How about sharing the project type you are working on
(ASP.NET/Windows Forms)?
"Earl" <br******@newsgroups.nospamwrote in message
news:uA*************@TK2MSFTNGP02.phx.gbl...
>I have somewhat of an interesting scenario:
>
The form allows the user to select a service, which populates a a grid
of product information related to that service ("service grid"). The
user can then select from the products in the first grid and those
choices populate the second "choices grid".
>
The product grid is bound to a strongly-typed dataset table which can
be filled in a couple of different ways. More on this shortly.
>
The choices datatable contains expression columns related to a product
table. So if the user choses Widget A, B, and C, the product prices
and a lot of other details for that service are reflected into the
choices grid without those values actually being duplicated into the
choices table.
>
All of the structure works well technically. But there is a
fundamental concept decision to be made. That decision is in how to
populate the products table. At some future date, the product catalog
may grow to be 50,000, 100,000 or even greater. My instinct is to
individually populate the products datatable with ONLY the Widgets
that relate to Service1 when it is selected, and then ONLY populate
the widgets that releate to Service 2 when it is selected (each
service requires a subset of the entire product catalog, thus limiting
how big the product table may be).
>
Where this becomes problematic is that the user may need 2 or more
Services. So if they select products that relate to Service 1, Service
2, etc., then the catalog to be displayed must grow much bigger.
Displaying just one set of products at a time will not work because
this would cause a partial display of the expression columns in the
choices grid (since the non-populated products still have a primary
key back to the products table, they display a row, but not the
expression data).
>
The easiest answer would be to just populate the entire catalog in the
products grid. Of course, the easiest solution is the most expensive
in terms of database and processor resources. The next easiest answer
would be to populate the product grid with just one set of products at
a time. But this creates the above-mentioned issue with the expression
columns.
>
The technical implementation is not an issue. I'm just looking for
some ideas or thoughts from anyone who has been down this road with
multiple grids and expression columns.
>
>
>
If I needed useless and trivial critique, I would post in the more demanding
forums more often.
Funny how the programmers always to push processing back onto the server and
the DBAs want to push the processing back onto the clients.
"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:ev*************@TK2MSFTNGP06.phx.gbl...
Earl,
If you cannot stand critique, stay out of the newsgroups.
However to answer your question. Forever look where is your biggest bottle
neck.
Making a column on a client will probably go in for humans not recognize
time while it is doing for one client x times and not for x clients x
time.
Therefore if you can bring processing to the client than do that.
However it that means that you have to process and collect more data than
needed for the process on the server, than the server is in my idea the
right place.
Cor
"Earl" <br******@newsgroups.nospamschreef in bericht
news:u%****************@TK2MSFTNGP06.phx.gbl...
>>I don't need a lecture from some twinkie. If you don't have an answer,
stay out of the thread.
"Scott M." <s-***@nospam.nospamwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
>>In general, it is best to post your question to the group that is most
relevant to your question and then if you don't find what you are
looking for to broaden the scope of the audience. That is simple
newsgroup etiquitte.
Your question is clearly an ADO.NET question who's solution is NOT
language specific.
"Earl" <br******@newsgroups.nospamwrote in message
news:OQ**************@TK2MSFTNGP03.phx.gbl...
I've often heard that the definition of a literalist is one who, upon
seeing the writing on the wall, stops to examine the penmanship.
"Specifically," C# and VB.Net are quite broad in scope. Since the
question involved the resources of both ADO.Net and the concept as a
whole, it would seem that a more general audience might have had some
insight (the resolution was in fact to simplify the form and roll up
one of the tables). It was a winforms app.
"Scott M." <s-***@nospam.nospamwrote in message
news:ua**************@TK2MSFTNGP03.phx.gbl...
How does this question relate specifically to C# and VB.NET? Wouldn't
you think that ADO.NET is solely the perfect place for this post?
Guess not. How about sharing the project type you are working on
(ASP.NET/Windows Forms)?
>
>
"Earl" <br******@newsgroups.nospamwrote in message
news:uA*************@TK2MSFTNGP02.phx.gbl...
>>I have somewhat of an interesting scenario:
>>
>The form allows the user to select a service, which populates a a
>grid of product information related to that service ("service grid").
>The user can then select from the products in the first grid and
>those choices populate the second "choices grid".
>>
>The product grid is bound to a strongly-typed dataset table which can
>be filled in a couple of different ways. More on this shortly.
>>
>The choices datatable contains expression columns related to a
>product table. So if the user choses Widget A, B, and C, the product
>prices and a lot of other details for that service are reflected into
>the choices grid without those values actually being duplicated into
>the choices table.
>>
>All of the structure works well technically. But there is a
>fundamental concept decision to be made. That decision is in how to
>populate the products table. At some future date, the product catalog
>may grow to be 50,000, 100,000 or even greater. My instinct is to
>individually populate the products datatable with ONLY the Widgets
>that relate to Service1 when it is selected, and then ONLY populate
>the widgets that releate to Service 2 when it is selected (each
>service requires a subset of the entire product catalog, thus
>limiting how big the product table may be).
>>
>Where this becomes problematic is that the user may need 2 or more
>Services. So if they select products that relate to Service 1,
>Service 2, etc., then the catalog to be displayed must grow much
>bigger. Displaying just one set of products at a time will not work
>because this would cause a partial display of the expression columns
>in the choices grid (since the non-populated products still have a
>primary key back to the products table, they display a row, but not
>the expression data).
>>
>The easiest answer would be to just populate the entire catalog in
>the products grid. Of course, the easiest solution is the most
>expensive in terms of database and processor resources. The next
>easiest answer would be to populate the product grid with just one
>set of products at a time. But this creates the above-mentioned issue
>with the expression columns.
>>
>The technical implementation is not an issue. I'm just looking for
>some ideas or thoughts from anyone who has been down this road with
>multiple grids and expression columns.
>>
>>
>>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Kay Schluehr |
last post by:
Here might be an interesting puzzle for people who like sorting
algorithms ( and no I'm not a student anymore and the problem is not a
students 'homework' but a particular question associated with...
|
by: PankajBanga |
last post by:
My DataGrid is bound to a DataSet, with following columns: Description, CashExp, CreditExp,Frequency
On run time, I am adding two new DataColumn “AnnualCash” and “AnnualCredit” and...
|
by: TD |
last post by:
I have this expression in the criteria section of a query:
IIf(Forms!frmReports!cboProductID="<ALL PRODUCTS>",.
Like "*",Forms!frmReports!cboProductID)
(the syntax of the above expression may...
|
by: perspolis |
last post by:
I have 3 columns in my datatabel name Total,unit,Price.
I use a column expression in my project..and in this
expression i multiplied two column...
for example ...
|
by: yer darn tootin |
last post by:
Does anyone know the sort expression for a column that's data has been
returned in the format, eg '07 Jul 05'??
The sort expression {..:"dd mmm yy"} doesn't work ( if the column was
returned as...
| | |
by: Reney |
last post by:
I am using Access in my project. In one of the forms, I am calling two
tables, and two of the columns have date/time type, namely "ClockIn" and
"ClockOut". I created a dataset and filled the...
|
by: Aaron Smith |
last post by:
Ok. I have a dataset that has multiple tables in it. In one of the child
tables, I have a column that I added to the DataSet (Not in the
DataSource). This column does not need to be stored in the...
|
by: Kjetil Klaussen |
last post by:
Hi,
I’m having some troubles trying to bind my dataset to a GridView control
through an ObjectDataSource control. The binding works fine for regular
columns in my dataset, but I can’t seem...
|
by: Earl |
last post by:
I have somewhat of an interesting scenario:
The form allows the user to select a service, which populates a a grid of
product information related to that service ("service grid"). The user can...
|
by: SMH |
last post by:
Hi All,
I am currently learning .Net 2, studying for 70-528. I've hit a bit of
a brick wall with DataColumn.Expression. As I understand it, this can
be used to (For example) concatenate two...
|
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,...
| | |
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...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
| | |
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 ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
