Max Size For Taking Characters through .cs page to DB

Question

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

Praveen Kumar Sreeram · 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.NVarChar5000).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

Praveen Kumar Sreeram · Answer

That's cool.. :-)

Sudheer Vasam · Answer

Thanks bro........... It's Working........

Sudheer Vasam · Answer

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............

Nitin Sontakke · Answer

Both the String variable declare in C# and the varchar(max) declared in SQL Server are capable of storing maximum of 2GB of data.

Vinay Singh · Answer

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)

Praveen Kumar Sreeram · Answer

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