471,356 Members | 1,646 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,356 software developers and data experts.

Ideal method....

VK
Hi,

We have a questionnaire of 75 questions with some radio button choices.
We are trying to update the database with these selections made by user.
Using ASP.NET and SQL2000.

Is - using a disconnected environment meaning -- store the answers of
the these questions in XML file, and update the database on completing
the entire questionnaire a good idea?

Many thanks,
Vani

*** Sent via Developersdex http://www.developersdex.com ***
Jul 21 '05 #1
2 1010
I don't follow you.

Is it a constraint of your system that the questionnaire must be filled out
in a disconnected environment?

Why use ASP.Net for that? Why not just use Infopath?

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"VK" <vk@vk.com> wrote in message
news:O%*****************@TK2MSFTNGP12.phx.gbl...
Hi,

We have a questionnaire of 75 questions with some radio button choices.
We are trying to update the database with these selections made by user.
Using ASP.NET and SQL2000.

Is - using a disconnected environment meaning -- store the answers of
the these questions in XML file, and update the database on completing
the entire questionnaire a good idea?

Many thanks,
Vani

*** Sent via Developersdex http://www.developersdex.com ***

Jul 21 '05 #2
VK,

When I understand you well, than I think it is a good idea. . Otherwise you
will probably have to do a lot of database maintanance because this sounds
as a solution with a lot of changes in time. Beneath the code to fulfill
this

Serialize dataset
\\\\
Dim sw As New System.IO.StringWriter
ds.WriteXml(sw)
Dim mystring As String = sw.tostring
///
Deserialize
\\\
Dim sr As New System.IO.StringReader(mystring)
Dim ds2 As New DataSet
ds2.ReadXml(sr)
///

I hope this helps a little bit?

Cor
Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by mixo | last post: by
1 post views Thread by Dave | last post: by
1 post views Thread by Satish Appasani | last post: by
1 post views Thread by Campano, Troy | last post: by
4 posts views Thread by Richard Levasseur | last post: by
reply views Thread by R. Rajesh Jeba Anbiah | last post: by
1 post views Thread by Jon Harrop | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.