c# - Retrieving VARCHAR(MAX) -

how can retrieve column of datatype varchar(max) sql server database in c#?

i don't think sqldatareader helps retrieve it.

any clue?

thanks

it's string field .... grab other string.....

// define query string query = "select yourfield dbo.yourtable id = 1";  using(sqlconnection conn = new sqlconnection("......")) using(sqlcommand cmd = new sqlcommand(query, conn)) {    conn.open();     using(sqldatareader rdr = cmd.executereader())    {        if(rdr.read())        {           string fieldvalue = rdr.getstring(0);        }    }     conn.close(); } 

there's nothing special varchar(max) type - it's text field, , can hold 2 gb of text - .net string. don't need special, streaming or - read column string!