Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

asp.net , c#

Posted on 2012-04-12
9
Medium Priority
?
296 Views
Last Modified: 2012-04-30
I have a project to build web-based insurance / auto quoting app. in asp.net c#, In  the survey, there is over 200 questions, so step by step application is required.

1. in asp.net world, what is the best approach to create the codes? using wizard, panel? or 3rd party solution? Remember, the user should be able to update after the steps by steps procedure is completed.

2. Saving the data into the database is another issue. Since there is so many data for each columns. I am trying to find a better solution instead of creating 200+ columns for the tables.

My approach is getting all of the information and create xml string like.
<quote id=1>
   <firstname>John</firstname>
  <lastname>Smiths</lastname>
</quote>

And save the xml string into the database.

However, I need some idea how to code in the frontend aspx/c#. Like create a session to store xml string during the step by step procedures....or other.

I hope experts can give me some idea how to generate the xml string
and be able to update xml string after the survey is completed.

Sound complex but actually it happens all the time in the real world app. If you need any third party asp.net component that working ... please let me know
0
Comment
Question by:Webboy2008
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
9 Comments
 
LVL 11

Expert Comment

by:MajorBigDeal
ID: 37841327
This kind of thing is very easy in asp.net.   You don't have to create the session, it is already there.  You can store information for the current user session without effort just by saying Session["field name"] = value;
0
 
LVL 11

Expert Comment

by:MajorBigDeal
ID: 37841333
There are classes built in to the common library that handle the creation of xml, updating databases, and make it easy to get data from the database to the user interface and back again with a minimum amount of effort.  Of course, there is a learning curve, and you have to learning the techniques.  

If your user has been through a login process, I would collect the answers in a database so they can continue where they left off.  If the user is anonymous (and it sounds like that is the case), then just use the current session to collect the data.
0
 
LVL 11

Expert Comment

by:MajorBigDeal
ID: 37841356
Here is a c# code snippet that builds xml.  There are lots of ways to do it, some more advanced than others and some are not available in all versions of .Net.  

 XmlDocument doc = new XmlDocument();            
 XmlElement root = CreateElement(doc,"root");            
 doc.AppendChild(root);    
 XmlElement xFirstName = CreateElement(doc,"firstName");
root.AppendChild(xFirstName);

and there are methods to add children, attributes, inner text, etc.

very simple!

Here is one way to convert that document to a string.

public static string StringFromXmlDocument(XmlDocument xmlDoc)
        {
            StringWriter sw = new StringWriter();
            XmlTextWriter xw = new XmlTextWriter(sw);
            xw.Formatting = Formatting.Indented;
            xmlDoc.WriteTo(xw);
            return sw.ToString();
        }
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:Webboy2008
ID: 37842280
Thank. But I would like more details. Assume I have three steps quoting asp.net web app.
How can I save/build xml string/save into Db in one class.

And when the user want to update those information, how can I extract the data from xml string, land the data into the UI, and save again in the Db.

Thanks
0
 
LVL 11

Expert Comment

by:MajorBigDeal
ID: 37843774
Wow, that is a lot of questions for one question.  Which aspect do you want to work on first, populating the data from the XML string into the UI,  creating the XML string from the UI, or storing and retrieiving the XML string to/from the DB?

Which database are you using?
0
 

Author Comment

by:Webboy2008
ID: 37845467
I use sql db 2008
0
 
LVL 11

Expert Comment

by:MajorBigDeal
ID: 37845601
Great,  please don't be offended if this is a dumb question:  Do you already have code that lets you update a field in the database?  Not necessarily XML but any field?
0
 

Author Comment

by:Webboy2008
ID: 37849587
MajorBigDeal: No I have not started yet. Saving one single xml in one column's purpose is to avoid unlimited columns in the database. Moving forward, we don't have to manage so many columns....
0
 
LVL 11

Accepted Solution

by:
MajorBigDeal earned 2000 total points
ID: 37863148
OK, so I guess the first thing we have to do is to establish a small test application that lets you write a field to the database and then read it back again.  Do you want to do that?
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question