Hi,

 i am using nvarchar(max) in my sql 2005 database.
These Columns are not displayed in my dynamic data website.

any idea

Thanks

I would use UIHint to choose the Text field.

My Code in UserLogMetadata Class

     <UIHint("Text_Edit")> _
    Public Message As Object

is not working still Column Message is not displayed.
When i use <asp:DynamicField DataField="Message" /> and Autogeneratedcolumns=false
it displays.
Whats wrang here

Put only the name of DynamicField without the _edit:

<UIHint("Text")>

 still not displaying using <UIHint("Text")>

nvarchar(max)  would be far to large to display (by default). If you really need nvarchar(max) , you don't want to be showing it. If you want to display something more reasonable, say nvarchar(5000) you should create a field template that checks the length, then displays the field. The UIHint suggestion should work - altho it's probably the wrong approach. I'll test it tomorrow.

UIHint  does not work. I'll come up with an alternative approach. Actually, UIHint shows the column on edit and details view, just not in the List view. The right way to do this is copy the text field template to text_Big and truncate the text to something reasonable in the text_Big template. You don't really want to show 100 pages of text do you?

If you want to show the first N chars in the list view, I need to work on that.

If you are using LINQ to SQL (a .dbml file), you can search/replace "NVarChar(MAX)" in the source code of the .designer.cs file.  Replace with something like "NVarChar(4000)" and the attribute describing the column will be updated for all fields associated with nvarchar(MAX) column types.  When you recompile and run the website, these columns will now be shown.  This is obviously a "hack" and may cause problems in certain situations, but it will display the colum in listings for you.

This problem will be fixed in .Net 4 where you can use UIHint(“MulitlineText”)