ADO.NET is returning wrong length of the columns

Question

Hello Frields I'm getting incorrect size of columns. Please tell me how to get the correct size of varchar type columns using C#.

Shweta Lodha · Answer

Nithika Please have a look at this post it talks about similar kind of problem: https://social.msdn.microsoft.com/Forums/en-US/c027921e-8884-4546-a52d-80eb7315db38/ado-does-not-return-the-actual-size-of-the-columns-nvarcharmax-ntext-data?forum=sqldataaccess

Nithika · Answer

Thanks mam for your quick response.