Set FormView mode depending on query results?

[pbb72]

Hi all,

I want to set the mode of my FormView based on the values the SelectCommand of my SqlDataSource returns. If a certain field contains Null, I want to have Edit mode, and when the field has a value, I want to have ReadOnly.

Apparently I cannot use databinding to set the DefaultMode, so I guess I have to attach code to SqlDataSource1_Selected? But I don't really know how to read out the field values in this way...

Thanks, Peter

 

[jbenson001]

You will have to use something other than a sqldatasource for this. You can use a sqldataadapter, or command object to fill a datatable. Then from there, check the value and set the mode accordingly.

 

[pbb72]

I found it, I needed to use FormView.DataItem["label"] to access the fields...

 

[jbenson001]

cool.. thanks for posting your find.