How to get paragraph size data from sql server database?

Question

1.00/5 (1 vote)

See more:

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:05am

AndroidVivek

Add a Solution

Comments

Jibesh 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 25-Dec-12 4:04am

of course I tried , Its paragraph size data I want to store in sql...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Krunal Rohit · Answer 1 · 2012-12-23T19:26:00

Solution 2

You can use HttpUtility.HtmlEncode[^] and HttpUtility.HtmlDecode[^] Methods...

Posted 23-Dec-12 19:26pm

Krunal Rohit

Comments

AndroidVivek 25-Dec-12 4:05am

thanks for this link its nice

[no name] 25-Dec-12 4:16am

If you're satisfied with the given answer, Accept the Solution :)
-Krunal R.

Tim Corey · Answer 2 · 2012-12-23T19:15:00

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.