Hi,
I want to keep some timesries data in my database. Raw data are something like below:
Time Col1 Col2 Col3
8:00 12 18 20
8:30 14 12 13
9:00 17 15 14
Where number of columns and time steps are undetermined. So I created three tables like this:
TimeStamp(ID,Time)
Columns(ID,Name)
Values(ID,TimeStampID,ColumnID,Value)
Now my question is how can I bind this data to a DataGridView using EF? I want my data to be editable by user (Add,Delete for rows and Edit in each cell) in form of a all-in-one table.
Thank you.