Integrating dhtmlxcombo in dhtmlxgrid using dhtmlxconnector

Suite and Optimus Suite 5
#1

Hello,
I have used a dhtmlxgrid with dhtmlxconnector. The technology used is ASP.NET and C#.

When I have the combo out of the grid it works, but inside the grid don’t.

    <div id="Div1" style="width: 600px; height: 270px; background-color: white;">
    </div>
<script type="text/javascript">
    var z = new dhtmlXCombo("Div1", "alfa4", 200);
    z.loadXML("DatosFiltro.ashx");

</script>

    <div id="gridbox" style="width: 600px; height: 270px; background-color: white;">
    </div>
    <script>
dhx_globalImgPath = "codebase/imgs/";
mygrid = new dhtmlXGridObject('gridbox');
mygrid.setImagePath("codebase/imgs/");
mygrid.enableAutoWidth(true);

mygrid.setSkin("dhx_skyblue")
mygrid.init();
mygrid.enableSmartRendering(true);
mygrid.loadXML("13_stored_procedure.ashx");
cmbEstado = mygrid.getColumnCombo(5);
cmbEstado.loadXML("DatosFiltro.ashx");

</form>

#2

From your code it looks as you are loading configuration of grid from xml - right ?
In such case you need to move the combo related code in callback of xml loading for the grid, so it will fire only when configuraton of grid will be loaded.

mygrid.loadXML("13_stored_procedure.ashx", function(){ cmbEstado = mygrid.getColumnCombo(5); cmbEstado.loadXML("DatosFiltro.ashx"); });

#3

thanks a lot … now it is working

#4

Hi GlobalBi,

I have the similar case where i bind the xml data to dhtmlxgrid. the xmldata comes from .ashx page. But i dont see the data being bound to the grid.

here is the code snippet,

[b]

<script type="text/javascript" src="Scripts/Jquery_unified.js"></script>
<script src="dhtmlxGrid/codebase/dhtmlxcommon.js" type="text/javascript"></script>
<script src="dhtmlxGrid/codebase/dhtmlxgrid.js" type="text/javascript"></script>
<script src="dhtmlxGrid/codebase/dhtmlxgridcell.js" type="text/javascript"></script>
<link href="dhtmlxGrid/codebase/dhtmlxgrid.css" rel="stylesheet" type="text/css" />

 <button  id="btnData"  onclick="getData();">Bind Data</button>
 <div id="gridbox" style="width:400px;height:200px">
<asp:Label ID="lbl" runat="server"></asp:Label>
 </div>
 

	<script type="text/javascript">
		
		function getData() {
			var mygrid = new dhtmlXGridObject('gridbox');
			mygrid.setImagePath("./codebase/imgs/"); //path to images required by grid
			mygrid.setHeader("Column A, Column B,Column A"); //set column names
			mygrid.setInitWidths("100,150,150"); //set column width in px
			mygrid.setColAlign("right,left"); //set column values align
			mygrid.setColTypes("ro,ed"); //set column types
			mygrid.setColSorting("int,str"); //set sorting
			mygrid.init(); //initialize grid
			mygrid.setSkin("dhx_skyblue"); //set grid skin

			mygrid.enableSmartRendering(true);
			mygrid.loadXML("GetXMLType.ashx");
		}

	</script>


</body>
[/b]

Moreover, mygrid.enablesmartrendereing is not supported.

The below is the snippet of ashx that returns the data in the format given next to it —
[b]using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

namespace WebApplication6
{
///


/// Summary description for GetXMLType
///
public class GetXMLType : IHttpHandler
{

	public  void ProcessRequest(HttpContext context)
	{
		context.Response.ContentType = "text/xml";

		string sqlSelect = "select personid,lastname from LocalDB.dbo.persons where lastname='Laxman'";

		SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["localDB"].ConnectionString);
		SqlCommand sqlCommand = new SqlCommand(sqlSelect, sqlConnection);
		SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCommand);
		DataSet sqlDt = new DataSet();
		sqlDa.Fill(sqlDt);

		string xmlData = sqlDt.GetXml();
	context.Response.Write(xmlData);
	}		
	
}

}[/b]

output of ashx is -----
[b]

1 Kuppili
2 Sashi
[/b]

please help me solve the issue. its road blocking for my release.

#5

The above code snippet generates xml in a custom format. Grid will not be able to parse it.

Check docs.dhtmlx.com/grid__data_forma … #xmlformat

#6

Thank you!
Yes I understand that the format that ashx returns doesn’t support the grid to load the xml data.
Please let me know the next step to make it happen. I’m completely new to dhtmlxgrid control.

Thanks in Advance.

#7

I have tried many ways like loadXML, loadXMLData, loadXMLString etc Nothing is working out in favor.

#8

There is no any API that will be able to load data in above format.

You need to
a) change format of data
or
b) code a custom data parser for the grid
docs.dhtmlx.com/grid__data_forma … dataformat