Re: Database question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well said glenn,

I thought i am only person who thinks outside the box[.Net].
I know there are lot of people here reading this reply but cannot reply as
they don't have answer or they think this is stupid. Let me tell you
something, as you mentioned, Delphi supports loading data as you scroll "I
love that stuff" and Microsoft will never be able to do that rather tell you
that you stupid to download such large dataset and always want
developers/users to do things their way. I dont know how Borland does that
but if they can do I think anyone can do[Microsoft???].

we as developers need to display data to the user and make programs the way
they like. We should have the way to do things the way we[they] like, i know
its not good thing to download 100,000 but if I really have to then i should
be able to do that and .Net should support that.

Anyway, I am a Delphi and now C# developer even though i hate the fact that
i cannot do things the way Delphi does we still have to deal with it. I like
CSharp for its ease of coding but i still wish to see lot of improvements in
..Net.

Arun


"glenn" <ghancock@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23GM1c2cQFHA.1096@xxxxxxxxxxxxxxxxxxxxxxx
> Well, let me explain:
>
> 1) Drop down lists that allow you to start typing a customer's phone and
> it
> matches customers as you type. This is a feature easily accomplished in
> Delphi as it only read over necessary records to keep things appearing as
> if
> the drop down had 50,000 records in it, but in reality it was only
> bringing
> over enough records to keep the 10 height of the drop down filled with
> records.
>
> 2) Parts lists. We have a business application that will typically have
> over 1 million records in the parts list. Our customers love our current
> version of the application because they can scroll up and down in the
> parts
> grid and look for things visually without having to do hundreds of
> searches
> to try to find things. They also can start typing in a part number and
> the
> system will immediately begin narrowing the view of the grid with numbers
> that match their entry.
>
> This is all accomplished without much data moving over the wire at all,
> because Delphi allows you to read over only enough records to fill the
> grid.
> Its also extremely fast as you can imagine.
>
> This is a feature that allows you to accomplish things that customers
> love.
> From what I'm seeing trying to accomplish such a task in C# and VS 2003 is
> next to impossible but I wanted to be sure I understood what was going on
> as
> no Book I've read so far has even bothered to mention how it was handling
> things such as this.
>
> A disconnected model works well for Internet applications but its my
> opinion
> that its pretty slack for trying to provide customers with the types of
> applications they require. I love C# but am constantly amazed at how
> Microsoft could hire Borlands top developers from out from under them and
> this is what they would design.
>
> glenn
>
>
> "Evert Timmer" <reply_to_group_only@xxxxxxxxxxxxx> wrote in message
> news:OrtnbKcQFHA.1476@xxxxxxxxxxxxxxxxxxxxxxx
>> glenn wrote:
>> > If I setup a connection and the appropriate items in C# to link a
> queried
>> > dataset that comes back with 100,000 results to a grid component on a
>> > windows form, does that mean that my program just read 100,000 records
> over
>> > the network at once? Or does the grid and dataset have built in
> knowledge
>> > that allows them to retrieve a select few of the records and then
> retrieves
>> > more as I scroll up and down through the grid?
>> >
>> > Thanks,
>> >
>> > glenn
>> >
>> >
>>
>> considering the fact that the dataset is part of the
>> disconnected ado.net model, i would assume that all records
>> where transmitted over the network.
>>
>> i would, however, reconsider my design strategies if my
>> application receives 100,000 results. what could possibly be
>> the reason for retrieving 100,000 records from a database
>> besides exporting them to a file?
>>
>> is there no way you can reduce the number of records being
>> retrieved?
>>
>> evert.
>
>


.

Relevant Pages

  • Re: StringGrid
    ... grids appear a lot more powerful then the datagrid. ... It's hard to put my finger on it, but in delphi land, we moved away ... or not supported in most grid examples. ... >AFAIK string grid is a grid where all cells represent a string or text - ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Smart Client applications (Comments from MS Lounch Event Croatia)
    ... All that juiced with how new NET 2.0 grid is powerful, and how bad 1.1 grid was. ... Delphi 1 launch session. ... client apps, thin and rich, ... It works at the desktop computer, has rich GUI, can work offline, ...
    (borland.public.delphi.non-technical)
  • Re: Sharing data between forms
    ... In Delphi the current record in the ... dataset bound to the grid is the one selected in the grid. ... Where DM1 is the name of the datamodule, Qry1 is the Ado query that is bound ... The second form requires setting the query parameter before ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: c# datagrid updating
    ... Basically Delphi spoilt you by handling all the work ... You can have Update Buttons in your Grid, as one of the column and ... >> adapteres, etc. Do I really have to write routines to create the Update ... >> Are data grids in c# really that convoluted or am I missign something? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Delphi client / VS 2003 COM Server
    ... I also tried the second method using the variant ... > Hi Glenn, ... > problem getting a variation of the sample to work via Delphi 6. ... > object then you must explicitly cast it to your interface to get to the ...
    (microsoft.public.dotnet.languages.csharp)