Max Size For Taking Characters through .cs page to DB

Sudheer Vasam

10y1kVisual Basic .NET

I Write

cmd.Parameters.Add("@Comment", SqlDbType.NVarChar, 5000).Value = Commnent;

To Store Blog Comment.This is Storing The Commnet Details By Using StoredProcedure in my .cs page

What is maximum size in .cs page to storing to DB

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Praveen Sreeram10y ago
Accepted answer
Hi sudheer,
Is it resolved now? If not, please make the following change.
Replace the following line of Code
cmd.Parameters.Add("@Comment",SqlDbType.NVarChar,5000).Value=Commnent;
to the following
cmd.Parameters.Add("@Comment",SqlDbType.VarChar).Value=Commnent;
Change the Datatype in C# to Varchar and remove the character limit.
Also, If you are using Stored Procedure, you also need to change varchar(5000) to varchar(max) to the @Comment variable in the parameter list of the Stored Procedure
Thanks,
Prawin
0
Praveen Sreeram10y ago
That's cool.. :-)
0
Sudheer Vasam10y ago
Thanks bro...........
It's Working........
0
Sudheer Vasam10y ago
Hi to every one........
My column data type in DB is varchar(max).....
but in the .cs page
cmd.Parameters.Add("@Comment", SqlDbType.NVarChar, 5000).Value = Commnent;
i declared 5000.So, it taken upto 5000 characters only from .cs page .......
i want more than this............
0
Nitin Sontakke10y ago
Both the String variable declare in C# and the varchar(max) declared in SQL Server are capable of storing maximum of 2GB of data.
0
Vinay Singh10y ago
Hi
As said it's totally depend upon the datatype of your table field. if you are not sure about size of data user Varchar(max)

0
Praveen Sreeram10y ago
Hi sudheer,
It depends on the type of the column of the SQL Database table where you are storing the data. It's nothing to do with C#.
if you want to store large data then I suggest you to use varchar(max) datatype for your column.
Hope it hepled,
Thanks,
Prawin
0