[onefortypoint6Participant]

I am having the issue also, but not using the latest copy of jqwidgets. It looks like the latest update of Firefox is preventing the number keys from accepting input, and users are forced to use up and down arrows to adjust the time. (ugh!) I guess I’ll have to update to the latest version of jqwidgets and fix everything that the update breaks in my code.

[onefortypoint6Participant]

Follow-up question: are the controls that have a data source set to a jqx data adapter observable? (i.e. if I add or remove an item from the data source, client-side, will the controls automatically reflect the change in data)?

Thanks again Peter

[onefortypoint6Participant]

Thanks Peter, that must be it. I am using custom cells rendering to change the background color on a single column of data.

Any insight you think of will be helpful. I am looking for a solution that will change the background color of cells in column A, based on the data results from column B. Currently I am using custom cell rendering, but also would like to have all of the grid’s columns auto resize.

So I suppose the question is, is there any CSS trickery I can use to change the background color of one column, based on another columns results (without cell rendering)?

Thanks in advance

[onefortypoint6Participant]

Thanks for the great work Peter and team

[onefortypoint6Participant]

spirit, I had the same need as well – here is how I handled it (because we are using ASP.NET as a web service and no PHP).

add a hidden field to your page to save the filters/etc.

then, when your data grid building the query, save the parameters to the hidden field
$(‘#hidGridFormatedData’).val(formatedData);

then, when the user clicks the export button, use your ajax call to pass the hidden parameters back to the server (which will persist your filters, etc.) – server-side you can ignore the paging, etc.

For us, we then pass back a message to the user, which they use the link to download their file.

Here is the server side code if it helps.

[WebMethod]
        [ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Json)]
        public string ExportData()
        {
            var queryString = this.Context.Request.QueryString;
            var query = "select * FROM " + this.BuildQuery(queryString);
           
            string strConnString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
            MySqlConnection con = new MySqlConnection(strConnString);
            MySqlCommand cmd = new MySqlCommand(query, con);
            MySqlDataAdapter da = new MySqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable dt = new DataTable();
            da.Fill(dt);
            StringBuilder sb = new StringBuilder();
            IEnumerable<string> columnNames = dt.Columns.Cast<DataColumn>().
                                              Select(column => column.ColumnName);
            sb.AppendLine(string.Join(",", columnNames));
            foreach (DataRow row in dt.Rows)
            {
                IEnumerable<string> fields = row.ItemArray.Select(field => field.ToString());
                sb.AppendLine(string.Join(",", fields));
            }
            string strFilename = Guid.NewGuid().ToString() + ".csv";
            string strUploadPath = Server.MapPath("userexports").ToString();
            File.WriteAllText(strUploadPath + "\\" + strFilename, sb.ToString());
            return strFilename;
        }

[onefortypoint6Participant]

temp work around:

if (defaultHtml) {
var element = $(defaultHtml);
element.css({ ‘background-color’: delStatusColor, ‘color’: ‘#000’, ‘width’: ‘100%’, ‘height’: ‘100%’, ‘margin’: ‘0px’ });
return element[0].outerHTML;
}

[onefortypoint6Participant]

Hi Peter, thanks, I am seeing that on some records also.

defaultHtml is undefined

In my code, the first several rows return good data, then I error out with no defaultHtml.

Thanks

[onefortypoint6Participant]

$(‘#jqxButton’).jqxButton({disabled: true });

[onefortypoint6Participant]

$(“.jqx-calendar”).css(“z-index”, 99999);

[onefortypoint6Participant]

Thanks Peter. Using I’m using addrow as a function from a button. (my grid has an ‘Edit’ button column for popup editing) When addrow completes from the ajax call and commits to the grid, how can I find the new row in the grid, then simulate clicking the Edit button?

[onefortypoint6Participant]

Thanks Peter, always great job on the quick responses.

[onefortypoint6Participant]

Thanks Peter, will try the false parameter

[onefortypoint6Participant]

Thanks Peter, I also tried to disable the grid during page load, then enable the grid later. Didn’t work, but thanks for the reply.

[onefortypoint6Participant]

Hi Peter, when I use “clearfilters” it does clear all of the filters, but when I add a new filter in the same function, the newly added filters are not passed to my web service. It’s okay, it is working great with the manual removal of entries. Love the product though, great work

[onefortypoint6Participant]

var removeAllFilters = function () {
                var filtersinfo = $('#jqxgrid').jqxGrid('getfilterinformation');
                $.each(filtersinfo,
                    function (filter, filtercolumn, filtercolumntext) {
                        $('#jqxgrid').jqxGrid('removefilter', filtercolumn.filtercolumn);
                    }
                );
            }

[Author]

Posts