How to create NVarchar(max) Sqlparameter in C#?

Description:

In this example we explain that how to define varchar max in stored procedure parameter in C#. or how to create NVarchar(Max) SqlParameter in C# to pass into the stored procedure. Or how to define the size for the varchar(Max) in your SqlParameter in C#. or setting the nvarchar(max) length for stored procedure using C#.

So here we demonstrate that how to create NVarchar(max) Sqlparameter in C#. here we have one field like “Comments” that have no limit for the input text into this field in database so we have defined Varchar(Max) for this SqlParameter to pass into the procedure like this.

Code:

cmd.Parameters.Add("@Comments", SqlDbType.NVarChar, -1);