XML datatype in sql server 2005
-
How can i insert data from textbox into xml datatype column using asp.net? Also how can i select the data from xml datatype in the datagrid? Any one can help me plz....
Hi, Without going into the complexity of Schema you could do the following: INSERT INTO TableName values('lt root /gt') lt = < gt = > Note: the value should be a valid XML documents or XML fragment (e.g. an XML document that doesn't have a root) for more information about XML, you can try this website http://jameleon.sourceforge.net/xmlBasics.html[^] about getting XML from datagrid, sorry I didn't understand your question, please explain it more. Hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
-
Hi, Without going into the complexity of Schema you could do the following: INSERT INTO TableName values('lt root /gt') lt = < gt = > Note: the value should be a valid XML documents or XML fragment (e.g. an XML document that doesn't have a root) for more information about XML, you can try this website http://jameleon.sourceforge.net/xmlBasics.html[^] about getting XML from datagrid, sorry I didn't understand your question, please explain it more. Hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...