ASP.NET Dynamic Data

Re: nvarchar(max) Columns are not displayed

ricka6 — Wed, 01 Jul 2009 18:21:59 GMT

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

Re: nvarchar(max) Columns are not displayed

sysmo — Wed, 01 Jul 2009 16:48:29 GMT

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.

Re: nvarchar(max) Columns are not displayed

ricka6 — Wed, 27 May 2009 18:55:15 GMT

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.

Re: nvarchar(max) Columns are not displayed

ricka6 — Wed, 27 May 2009 04:16:41 GMT

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.

Re: nvarchar(max) Columns are not displayed

orimaspnet — Mon, 25 May 2009 13:05:51 GMT

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

Re: nvarchar(max) Columns are not displayed

andreadottor — Mon, 25 May 2009 12:14:04 GMT

Put only the name of DynamicField without the _edit:

<UIHint("Text")>

Re: nvarchar(max) Columns are not displayed

orimaspnet — Mon, 25 May 2009 11:26:21 GMT

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

Re: nvarchar(max) Columns are not displayed

sjnaughton — Sun, 24 May 2009 20:31:16 GMT

I would use UIHint to choose the Text field.

nvarchar(max) Columns are not displayed

orimaspnet — Sun, 24 May 2009 18:17:51 GMT

Hi,

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

any idea

Thanks