I'm trying to build a usercontrol to access the SQL CheckBoxList Values.
I included the umbraco and ucomponent dlls in my project, but I can't seem to figure out how to get the values. The only luck I've had was "umbraco.library.GetItem("alias")" This returns the checkboxlist IDs, ie: 123.
I'm not sure how to get the XML data. Any help is greatly appreciated!
I was able to figure this out. It wasn't the checkbox IDs, it was the ID from a SQL column. I updated the SQL expression and I have something I can work with.
I was still under the impression that this would return XML though.
Are you able to show me an example in .net and razor? I am only able to get text values (example: "valuevaluevalue" if I check 3 boxes), not an xml format. Thanks for your help!
Retrieving SQL CheckBoxList Values
I'm trying to build a usercontrol to access the SQL CheckBoxList Values.
I included the umbraco and ucomponent dlls in my project, but I can't seem to figure out how to get the values. The only luck I've had was "umbraco.library.GetItem("alias")" This returns the checkboxlist IDs, ie: 123.
I'm not sure how to get the XML data. Any help is greatly appreciated!
I was able to figure this out. It wasn't the checkbox IDs, it was the ID from a SQL column. I updated the SQL expression and I have something I can work with.
I was still under the impression that this would return XML though.
Hi Ryan,
yes, SQL CheckBoxList should store an XML fragment if the datatype has been configured save as XML
Are you able to show me an example in .net and razor? I am only able to get text values (example: "valuevaluevalue" if I check 3 boxes), not an xml format. Thanks for your help!
is working on a reply...