paulthepaddy
Well-known member
Hey Guys, I Dont Know If This Is Possable But I Was Looking To Store A List into A Data base field. Il Give As Much Information As I Think Is Needed.
The DataBase :
The DataBase is accdb (dont know if it helps). It Has Multiple Tables And Is Saved Locally On Machine So I Dont Think Size Is An Issue Regaurding Performance.
The Table im Interested In Reguarding The Post Is Cars And Is As Follows.
Reg | Make | Model | Colour | Year | Customer | Price | Date | Inc Invoice | Assinged Ord Num | Work Done | Paid ------------------------------------------------------------------------------------------------------------------
The Plan Is That Work Done Coloum Will Store A List Of The Work Done, but it get complecated As Their Is Quite A Few Diffrent Things We Do On The Cars.
If Their Was A Way To Save A List To The Database Field That Would Be great. Or If Any One Could Think Of A Way To keep The Lists Of Damage Within The Database, As The Only Ways I Can Think Of Doing This Are Listed Below.
My Ideas On How To Do This :
1) Text File List's
I Was Thinking I Could Save The Damage Lists As A Text File And Name Them by Reg As Their Wont Be Multiple Regs, But I Think Their Is Far To Much Can Go Wrong Since I Would Be Working With The Database And Addintional Files.
2) XmlSerializer
Since The Car Is Also A Class I Was Thinking I Could Serialise It Then Load The File When Needed but Again This Means Having The DB And Extra Files, kind of the same problem as above.
I Would Prefere If I Could Be Using The DataBase And Create The Car From The DataBase As I Plan To Be Loading The Cars Into Listboxs For A Few Diffrent Things.
Any Help Would Be Much Appreicated, Also I Would Like To Give Rep To Other People As It Wont Allow Me To Keep Giving Rep To The Same Person Im Sure They Know Who They Are
Thanks Guys
The DataBase :
The DataBase is accdb (dont know if it helps). It Has Multiple Tables And Is Saved Locally On Machine So I Dont Think Size Is An Issue Regaurding Performance.
The Table im Interested In Reguarding The Post Is Cars And Is As Follows.
Reg | Make | Model | Colour | Year | Customer | Price | Date | Inc Invoice | Assinged Ord Num | Work Done | Paid ------------------------------------------------------------------------------------------------------------------
The Plan Is That Work Done Coloum Will Store A List Of The Work Done, but it get complecated As Their Is Quite A Few Diffrent Things We Do On The Cars.
If Their Was A Way To Save A List To The Database Field That Would Be great. Or If Any One Could Think Of A Way To keep The Lists Of Damage Within The Database, As The Only Ways I Can Think Of Doing This Are Listed Below.
My Ideas On How To Do This :
1) Text File List's
I Was Thinking I Could Save The Damage Lists As A Text File And Name Them by Reg As Their Wont Be Multiple Regs, But I Think Their Is Far To Much Can Go Wrong Since I Would Be Working With The Database And Addintional Files.
2) XmlSerializer
Since The Car Is Also A Class I Was Thinking I Could Serialise It Then Load The File When Needed but Again This Means Having The DB And Extra Files, kind of the same problem as above.
I Would Prefere If I Could Be Using The DataBase And Create The Car From The DataBase As I Plan To Be Loading The Cars Into Listboxs For A Few Diffrent Things.
Any Help Would Be Much Appreicated, Also I Would Like To Give Rep To Other People As It Wont Allow Me To Keep Giving Rep To The Same Person Im Sure They Know Who They Are
Thanks Guys