Some ADO.NET Mobile Advice please.

[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

[iKiLL]

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" <iK***@NotMyEmail.comwrote in message
news:%2***************@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

[RobinS]

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" <iK***@NotMyEmail.comwrote in message
news:uS**************@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" <iK***@NotMyEmail.comwrote in message
news:%2***************@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

[iKiLL]

Thanks for your input Robin.



"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:Jv******************************@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" <iK***@NotMyEmail.comwrote in message
news:uS**************@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" <iK***@NotMyEmail.comwrote in message
news:%2***************@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