error77
asked on
Add and Edit records on DBGrid
Hi all,
Is it possible to Add and Edit records on the DBGrid itself?
If yes, how please?
Thanks
Is it possible to Add and Edit records on the DBGrid itself?
If yes, how please?
Thanks
Using the TDBGrid component
http://delphi.about.com/od/usedbvcl/a/tdbgrid.htm
http://delphi.about.com/od/usedbvcl/a/tdbgrid.htm
ASKER
So, can it be done or not?
If you mean add TEdit in DBGrid, so
Yes, you can
Yes, you can
ASKER
Well, I'm using KDBGrid, which has all that:
http://www.tkweb.eu/en/delphicomp/kcontrols.html
but even if it was a normal dbgrid, how can I edit a cell manually?
http://www.tkweb.eu/en/delphicomp/kcontrols.html
but even if it was a normal dbgrid, how can I edit a cell manually?
I didn't use this component, but if KDBGrid is ReadOnly by default you could switch ReadOnly property to false
ASKER
I've check and it hasn't got a radonly property :o/
Hi There;
Yes you can,
Use UpdateSQL Component to update Your DBGrid Content.
But you have to write SQL Statments to do :
Delete
Insert
Modfiy
Your Application Must have :
1-DBGrid ReadOnly = False
2-Query Component
3-UpdateSQL Component
Best Regards
Abdel
Yes you can,
Use UpdateSQL Component to update Your DBGrid Content.
But you have to write SQL Statments to do :
Delete
Insert
Modfiy
Your Application Must have :
1-DBGrid ReadOnly = False
2-Query Component
3-UpdateSQL Component
Best Regards
Abdel
ASKER
KDBGrid does not have a readonly property :o/ Also, I want to edit the cell manually not by code.
Is this not possible?
Is this not possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Mixed both solutions and it worked. Thanks very much!
Adding and editing records always affects data of the underlying dataset...