Some ADO.NET Mobile Advice please.

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.







"iKiLL" <iKill@NotMyEmail.com> wrote in message
news:%23ERwCQjYHHA.208@TK2MSFTNGP05.phx.gbl...
>
>
> 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 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.
---------------------------------------------
"iKiLL" <iKill@NotMyEmail.com> wrote in message
news:uSnrbVmYHHA.5044@TK2MSFTNGP05.phx.gbl...
>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.
>
>
>
>
>
>
>
> "iKiLL" <iKill@NotMyEmail.com> wrote in message
> news:%23ERwCQjYHHA.208@TK2MSFTNGP05.phx.gbl...
>>
>>
>> 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
>>
>>
>>
>>
>
>

Thanks for your input Robin.







"RobinS" <RobinS@NoSpam.yah.none> wrote in message
news:JvOdnQt_Ae0KNWzYnZ2dnUVZ_oOknZ2d@comcast.com...
>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.
> ---------------------------------------------
> "iKiLL" <iKill@NotMyEmail.com> wrote in message
> news:uSnrbVmYHHA.5044@TK2MSFTNGP05.phx.gbl...
>>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.
>>
>>
>>
>>
>>
>>
>>
>> "iKiLL" <iKill@NotMyEmail.com> wrote in message
>> news:%23ERwCQjYHHA.208@TK2MSFTNGP05.phx.gbl...
>>>
>>>
>>> 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
>>>
>>>
>>>
>>>
>>
>>
>
>