C # nvarchar (max) Operations)

 

Like normal nvarchar operations, note that the length of sqldbtype. nvarchar is set to-1,

new SqlParameter("@text",SqlDbType.NVarChar,-1)

Public bool addmax () {stringbuilder strsql = new stringbuilder (); strsql. append ("insert into tb_maxtest ("); strsql. append ("ID, text) values (@ ID, @ text);"); sqlparameter [] parameters = new sqlparameter [] {New sqlparameter ("@ ID", sqldbtype. varchar, 50), new sqlparameter ("@ text", sqldbtype. nvarchar,-1)}; Parameters [0]. value = "111"; Parameters [1]. value = "when writing stored procedure, if the type of the parameter is nvarchar (max) in. for example, if there is a parameter @ message whose data type is nvarchar (max), it must be written as follows: new sqlparameter (\ "@ message \", sqldbtype. nvarchar,-1) "; int ROW = dbhelpersql. executesql (@ "Server = CNPVG-SQLVM \ Tester; initial catalog = dms_quotation; Pwd = welcome88; uid = sqladmin;", strsql. tostring (), parameters); Return row> 0 ;}