Click here to Skip to main content
11,437,816 members (32,097 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL
I am new in asp and i want to set dynamic data..

in making site i have full page size of data so how i can store that data in database and can retrieve it into the site..
Posted 23-Dec-12 8:05am
Comments
jibesh at 23-Dec-12 14:23pm
   
what do you mean by paragraph? is it data your are going to store in sql?

Your question and the explanation do not match. have you tried to use the already available information on the net ? any effort so far?
AndroidVivek at 25-Dec-12 4:04am
   
of course I tried , Its paragraph size data I want to store in sql...
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

You can use HttpUtility.HtmlEncode[^] and HttpUtility.HtmlDecode[^] Methods...
  Permalink  
Comments
AndroidVivek at 25-Dec-12 4:05am
   
thanks for this link its nice
Krunal Rohit at 25-Dec-12 4:16am
   
If you're satisfied with the given answer, Accept the Solution :)
-Krunal R.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

If you want to store large amounts of text in a SQL database, then you want to use either a varchar(max) or a nvarchar(max) column to store that data. In case you don't know the difference, nvarchar will support Unicode characters. If you aren't sure if you will need Unicode support, that means you probably will so use nvarchar. If you know for absolute certainty that you won't need it then use varchar (uses half the space). These column types work like any other column in how you read and write to them. The only difference is that if the data gets too large, SQL will store it on disk outside the normal storage. That will make the retrieval process take longer.

I would recommend you look into these options and carefully think through what is best for your situation.
  Permalink  
Comments
AndroidVivek at 25-Dec-12 4:05am
   
thanks I found little solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web03 | 2.8.150506.1 | Last Updated 24 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100