Data Entry with DevEx Grid - How To...


Author
Message
Keith Courneyea
Keith Courneyea
StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)
Group: Forum Members
Posts: 11, Visits: 196
I'm a trial user.  I'm needing to migrated a commerial Access Time and Billing application (TimeWerkes) to .net/sql.  I'm wondering if there are any examples of data entry via a grid only.  In my app 95% of the data entry is done via a grid (Janus).

I probably have too many questions to list, but maybe an example would clear things up for me.

The scenario goes:

Create Employee Timesheet  - Master record

Add many timesheet details for the current pay/billing period.  Each record that goes into the grid needs required fields checking, default values set (dependant on project setup) etc, etc.

One of my cusotmers averages between 650 and 800 timesheets per period, so that means tons of data entry via the grid. 

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
The business rules will be respected within a grid when using a BusinessBindingSOurce.  Attached is a sample that will be included in the next update.  This sample shows how to use a BusinessBindingSOurce with a grid.  If you create a new record and try to save, you will see the broken rules show up within the grid.
Attachments
BusinessBindingSource.zip (182 views, 99.00 KB)
Keith Courneyea
Keith Courneyea
StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)
Group: Forum Members
Posts: 11, Visits: 196
Thanks for the extremely quick response.  I will check this out ASAP. 
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
No problem. Smile
Keith Courneyea
Keith Courneyea
StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)StrataFrame Beginner (11 reputation)
Group: Forum Members
Posts: 11, Visits: 196
Thanks for the example.  I replaced the example's grid with one from DX and it worked great.

One question.  As you're probably aware the DX grid via built in context menu allows the user to manage which fields are visible.   How would a person disallow hidding a required field.  Trying to save a record where there's a broken rule with the offended column hidden would be difficult at best for most users.

I haven't tried to figure this out yet myself.  Thought I'd ask in case you may already have a quick answer.  If not let's see what we can turn up BigGrin 

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
How would a person disallow hidding a required field.

I am not sure.  I would have to play with this first.  We do not use the DX grid so I am not as familiar with it off the top of my head.  Sorry Ermm

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search