Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Paulo Gil on Oct 19, 2008 18:24
open dhtmlx forum
SQL server

I want to by this tool but i have one question.
I make a xml by sql server. that have a structure of the database.
I use studio 2008 .net

How can i make the xml been read by grid?

they dont load nothing...
Answer posted by Support on Oct 20, 2008 01:55

The grid accepts only XML data in specific format
       http://dhtmlx.com/docs/products/dhtmlxGrid/doc/articles/Loading_data_in_grid.html#grid_art_loadingdata
( xmlA format is native for MsSQL , so it must not be a problem ) 

If you output XML by server side script and get "Incorrect XML" error - please check next article. 
       http://dhtmlx.com/docs/products/dhtmlxGrid/doc/articles/Common_Problems_in_Grid.html#grid_art_comprob

Answer posted on Oct 20, 2008 04:37
Do you have some examples ? i don't understand how i will make. i have tried and the grid are all the ways empty with my xml.
Answer posted by Support on Oct 20, 2008 07:42
You can use generate xml stream using a server-side language:

    grid.loadXML(path_to_the_script);

But xml must be in the especial format. Grid has default format, but default can be changed. For example, xmlA format  is native for MsSQL. Please, see the sample in the package dhtmlxGrid/samples/initialization_loading/grid_xml_formats.html (on our web site -  http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/initialization_loading/grid_xml_formats.html)
 
   Unfortunately, we have only one ready .Net sample (the sample for rather complicated functionality - Data Processor ) and it requires PRO edition. The sample  can be gotten with the evaluation version of the PRO edition.  If you are interested in it, please, contact us at the support@dhtmlx.com.