Entering Data

Hi!

I'd like to know how I can enable the user to enter data in an access-like or excel-like way. I'd like the user to enter a product-subscription, Prize, number of products to order and some other data. This has to be presented in a column-like way.

Product Prize No. Total
Product A 100.00 5 500.00
Product B 150.00 4 600.00
etc..

What I want is something like the DB grid to enter the data.
I DON'T like 3rd party controls or OCX-es, so what is the best solution?

(An array of textboxes is an option, but I'd like to know what you all think of it). As far as I know the DBGrid and all other controls are read-only if they're not connected to a database?

[Ober]

The MSFlexGird can be connected to a database but you're right it would be read only. It cannot update using the Grid. You will have to use some type of textbox to update.
Or purchase an extra control.

I also know that the MSFLexGrid requires the Data control.

I think an array of textboxs isn't bad but that depends on how much data you want you're application to be able to view.

I have some source code to connect the MSFlexGrid with the data control.

Let me know if you need anything.

-Ober

Like I said, I don't like 3rd party (other people's) controls for several reasons:

• You never know what unknown bugs there are in it
• IF they're in it you can't fix them yourself and i.e. you have to wait for the developer to fix it...which could be years
• You can't extend it to your own needs
• You have to pay for it
• You can't just distribute it withou permission

Then, I know the MSFlexgrid is read only, and I don't want to connect it to a data-control because I don't have any (I use references and do it all in the source-code).

An array of textboxes would do the trick, but I think there has to be a better way. Can't I just set a bit or two for some Gridcontrol that makes it behave like a sort of textbox array? I know a grid-control is also a third party control (because MS made it, not me) so don't start bugging me about that . I just think MS's way has been proven for several years now.. So I don't mind using MS's controls....

Question is: wich one????

(Thanx for the reply anyways... Sorry if I sound a bit cranky, I just am... I've been looking for too long now... <sigh> maybe I'll go with the array of textboxes anyway... )