PC Review


Reply
Thread Tools Rate Thread

Some ADO.NET Mobile Advice please.

 
 
iKiLL
Guest
Posts: n/a
 
      9th Mar 2007


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




 
Reply With Quote
 
 
 
 
iKiLL
Guest
Posts: n/a
 
      9th Mar 2007
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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>
>
> 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
>
>
>
>



 
Reply With Quote
 
RobinS
Guest
Posts: n/a
 
      9th Mar 2007
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>>
>>
>> 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
>>
>>
>>
>>

>
>



 
Reply With Quote
 
iKiLL
Guest
Posts: n/a
 
      12th Mar 2007
Thanks for your input Robin.







"RobinS" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>>
>>>
>>> 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
>>>
>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mobile Phone Advice bodhi General Discussion 7 24th Mar 2008 01:35 AM
I need some mobile advice murdoch General Discussion 4 27th Apr 2007 01:20 AM
Some ADO.NET Mobile Advice please. iKiLL Microsoft ADO .NET 3 12th Mar 2007 02:38 PM
Some ADO.NET Mobile Advice please. iKiLL Microsoft C# .NET 3 12th Mar 2007 02:38 PM
Some advice for mobile pages Steven Blair Microsoft C# .NET 0 3rd Sep 2006 01:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:58 PM.