Click here to Skip to main content
Sign Up to vote bad
good
See more: C#ASP.NETSQL
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 - 7:05

Comments
jibesh - 23 Dec '12 - 14:23
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 - 25 Dec '12 - 4:04
of course I tried , Its paragraph size data I want to store in sql...

2 solutions

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 - 25 Dec '12 - 4:05
thanks I found little solution
You can use HttpUtility.HtmlEncode[^] and HttpUtility.HtmlDecode[^] Methods...
  Permalink  
Comments
AndroidVivek - 25 Dec '12 - 4:05
thanks for this link its nice
Krunal Rohit - 25 Dec '12 - 4:16
If you're satisfied with the given answer, Accept the Solution :) -Krunal R.

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 435
1 OriginalGriff 315
2 Arun Vasu 293
3 CPallini 213
4 Zoltán Zörgő 194
0 Sergey Alexandrovich Kryukov 10,005
1 OriginalGriff 7,654
2 CPallini 4,171
3 Rohan Leuva 3,447
4 Maciej Los 2,974


Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 24 Dec 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid