Some ADO.NET Mobile Advice please.

  • Thread starter Thread starter iKiLL
  • Start date Start date
I

iKiLL

Hi all



I am building an Windows Mobile 5 forms control in C#, for a Windows Mobile
5 application. I am using CF2.0 and SQL Mobile 2005.



The control is a Questions and answer control.

Basically I have 3 applications using the same code to dynamically display
questions and save the answers.



I am trying to consolidate it all into 1 control for easer maintenance.



I need to pass the control the questions and meta data for the questions.
And when the last question has been completed the control should hand back
the Answers for saving.



What is the best why of doing this? I really would like to get this right
the first time.



I know I am developing with the CF2 platform. So I am concerned about
getting the most efficient why of doing this.



Possible scenarios I are.



1.. Pass the control a Questions DataTable and an Answers DataTable (Flat
File), use the Questions DataTable to load up an array and loop through the
array asking questions and saving the answers to Answers DataTable. When
the Questions are finished raise an event handing the Answers table as an
Event Arg.
2.. Pass the control a QuestionsAnswers DataSet with a Questions DataTable
and an Answers DataTable in it, use the Questions DataTable to loop round
asking questions and saving the answers to Answers DataTable. When the
Questions are finished raise an event handing the QuestionsAnswers DataSet
as an Event Arg.
3.. Hand the control a Connection and get it to read the questions
directly from the Database and save the answers directly to the database.


I really am lost.

I don't what to take the wrong path and I don't have enough background
experience to make an informed decision about what the best way to handle
this with ADO.NET and the CF would be.



Any suggestions would be welcomed.



Thanks,

ink
 
I think i am going to go with option 2.

It seems to give me the most functionality with Filtering and navigation
back and forth through the questions.
 
I don't know anything about programming for mobile devices, but option 2
gives you the best disconnectedness. The only question is, what if there's
a problem in the middle -- are all the answers lost? I would probably
choose option 3, but only if it didn't have performance problems. If
retrieving the info dynamically didn't have as good of performance as
option 2, I would choose option 2.

Good luck.
Robin S.
---------------------------------------------
 
Thanks for your input Robin.







RobinS said:
I don't know anything about programming for mobile devices, but option 2
gives you the best disconnectedness. The only question is, what if there's
a problem in the middle -- are all the answers lost? I would probably
choose option 3, but only if it didn't have performance problems. If
retrieving the info dynamically didn't have as good of performance as
option 2, I would choose option 2.

Good luck.
Robin S.
Click to expand...
 
Back
Top