Ideal method....

  • Thread starter Thread starter VK
  • Start date Start date
V

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
 
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,

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
 
Back
Top