#select_filter

Suite and Optimus Suite 5
#1

Hello,



I have around 10 columns in which first column is check box column, second column is of String, and third column is a date column, rest of the columns are of integer, I wanted a dropdown filter in the second column header, so i have added the following code.



mygrid.attachHeader("#rspan,#select_filter,#rspan");



Now I am getting the dropdwon in the second column header, but it is empty, i have included dhtmlxgrid_filter.js, could you please help us.



Thanks in advance.



#2

How is data loading in the grid?
If you adding rows through addRow command - be sure to call
grid.refreshFilters();
after all necessary rows will be added to the grid.

#3
#4

No i am not using any addrow, infact i just want only update from the grid, no rows deletion/addition. from my http handler i am populating the rows like

Dim connector As dhtmlxGridConnector = New dhtmlxGridConnector("SELECT IsDone,HotelName,Date,UniqueVisits,TotalVisits,ReservationClicks,DirectTrackedRevenue,DirectReservations,DirectRoomnights,ClickstoReservationWidgets,HyattClickthroughs,CalculatedColumns,DisabledColumns FROM ClientFact " + whereCondition, “ID”, dhtmlxDatabaseAdapterType.SqlServer2005, ConfigurationManager.ConnectionStrings(“ConnectionString”).ConnectionString)



Return connector



 



and in the aspx page i have teh following scripts



mygrid = new dhtmlXGridObject(‘gridbox’);


mygrid.setImagePath(’…/JScripts/dhtmlx/imgs/’);



mygrid.setSkin(“light”);



var myColumns = “Is Done,Account Name,Date,Unique Visits,…”;



mygrid.setHeader(myColumns);



mygrid.attachHeader("#rspan,#select_filter,#rspan");




mygrid.setColTypes(“ch,ro,ro,ed,ed,ed,ed,ed,ed,ed,ed…”)



mygrid.setColSorting(“str,str,date,int,int,int,int,int,int…”)



mygrid.init();



mygrid.loadXML(“Edit.ashx”);



//============================================================================================



myDataProcessor = new dataProcessor(“Edit.ashx”); //lock feed url



myDataProcessor.setTransactionMode(“POST”,true); //set mode as send-all-by-post



myDataProcessor.setUpdateMode(“off”); //disable auto-update



myDataProcessor.init(mygrid); //link dataprocessor to the grid



 



NOTE: “…” i have given the actual values