Intersoft Community - WebGrid Enterprise - Adding null option to ValueList

Adding null option to ValueList

somer@optima.com.tr — Fri, 28 Jan 2011 04:40:29 GMT

Sample is attached; sample database is in data folder of compressed file.

Adding null option to ValueList

yudi — Thu, 20 Jan 2011 02:01:33 GMT

Could you please kindly send us a working simple sample that reproduces the issue?

Adding null option to ValueList

somer@optima.com.tr — Mon, 17 Jan 2011 01:53:22 GMT

Yudi,
The problem is dropdown's original datasource has no null row, but i want to add it to dropdown list.
Sample Scenerio is:
Webgrid's boundend datasource is a customer table where its country field is a nullable foreign key field. So what i want is a country dropdownlist column which populates its data from country table. But also, as it is nullable field, i have to supply a null option for that field. As you may agree, it is not an option to add a null row to country table. So i'm inserting a null object to returned collection at OnSelected event of LinqDataSource.
In my opinion, as this scenerio is very generic, there must be a simple option for this in webgrid column.

Adding null option to ValueList

yudi — Mon, 17 Jan 2011 01:30:30 GMT

I tried to reproduce the problem in my local test by creating a simple sample of BatchUpdate-enabled WebGrid where one of its columns uses DropDownList as the edit type. The data source of the DropDownList is taken from a database where the first row is a null selection option. The only difference is that AccessDataSource control is used instead of LinqDataSource control. Everything worked smoothly and the null value can be saved without any issues.

I’m willing to advice you further but in order to do so we would need you to elaborate on your specific scenario and possibly give us a running simple sample that reproduce the issue and a step-by-step guide that we can use to observe the problematic behavior.

Adding null option to ValueList

somer@optima.com.tr — Fri, 14 Jan 2011 05:28:05 GMT

I have a dropdownlist column which is bound to a foreign key column and populates its data from another LinqDataSource.
To add "null" selection option for that column, i'm inserting a null object to the first position of returned object list during LinqDataSource_OnSelected event [ ((IList)e.Result).Insert(0, null); ].
This seems fine for having "null" selection option for that column. But when posting update with batchupdate it is giving error, as batchupdate sending empty string instead of null for that column.
How can i solve this?