Databases
StackOverflow2013
Postsdbo
POComplex editing on a gridview in C#
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POComplex editing on a gridview in C#
    text
    copied!<p>I am working on an attendance system that has the following tables: </p> <pre><code>Entry +---------+-----------+ + EntryID + EntryDate + +---------+ ----------+ Hour +---------+--------+---------+ + EntryID + InHour + OutHour + +---------+--------+---------+ </code></pre> <p>With the following example data:</p> <pre><code>Entry +---------+---------------------+ + EntryID + EntryDate + +---------+---------------------+ + 1 + 1/1/2010 8:00:00 AM + + 2 + 1/1/2010 8:01:02 AM + +---------+---------------------+ Hour +---------+---------------------+-----------------------+ + EntryID + InHour + OutHour + +---------+---------------------+-----------------------+ + 1 + 1/1/2010 8:00:00 AM + 1/1/2010 1:00:00 PM + + 1 + 1/1/2010 2:04:00 PM + 1/1/2010 6:03:00 PM + + 2 + 1/1/2010 8:01:02 AM + 1/1/2010 1:02:00 PM + +---------+---------------------+-----------------------+ </code></pre> <p>And I have the following gridview:</p> <p><img src="https://i.stack.imgur.com/YX3N2.jpg" alt="alt text"></p> <p>I need help with how I should approach a request my client has done today...</p> <p>Currently, when calling this gridview the "Arrives At" and "Leaves At" fields are retrieved by querying the database and concatenating all the hours in a string then printing it out. However, my client now wants the ability to modify any of the hours in the "Leaves At" column. I don't know how to approach this request at all, since the hours are grouped together in one cell. I've thought showing the hours in a textarea but there's no way that the changes will be correctly applied on the database if I did this.</p> <p>Any help will be greatly appreciated as I feel overwhelmed by this.</p> <p>Thanks in advance, Eton B.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload