Messages

1

Help for ParamQuery Pro / Re: Connect to Microsoft SQL Database

« on: February 26, 2016, 03:14:02 pm »

Is there a ParamQuery Grid Tutorial for ASP .NET available (like the php-tutorial) where I can see, how  the "Controller"-class or the "DbContext"-class in the remote paging demo are working?
Normally i use pqgrid only to show the query results from MS SQL or ORACLE-databases. Now I try to use it to edit the the database entries too.

2

Help for ParamQuery Pro / Connect to Microsoft SQL Database

« on: February 25, 2016, 03:20:02 pm »

I want to use pqgrid in a c# .net-application.
I didn`t found a way to connect to a MS SQL Database in the Demos (for example Remote Paging). Where I have to configure the connection to the Database(s)?

Normally i use something like this:

Code: [Select]

string source = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\x\x\documents\visual studio 2013\Projects\WebApplication3\WebApplication3\App_Data\Product.mdf;Integrated Security=True";
SqlConnection conn = new SqlConnection(source);
conn.Open();
greetings,
marco.

3

Help for ParamQuery Pro / Re: Check a checkbox only by click exactly on it

« on: April 07, 2015, 07:01:49 pm »

I could solve it by using "pqgridcheck and pqgriduncheck at the same time.

Code: [Select]

$("#evnTabelle").on("pqgridcheck", function (event, ui) {
            var ergebnis = summePrivatverbindungen();
            document.getElementById("summe").innerHTML = ergebnis + " EUR";
});
$("#evnTabelle").on("pqgriduncheck", function (event, ui) {
            var ergebnis = summePrivatverbindungen();
            document.getElementById("summe").innerHTML = ergebnis + " EUR";
});

    function summePrivatverbindungen() {
            var $grid = $("#evnTabelle").closest('.pq-grid');
            data = $grid.pqGrid('option', 'dataModel.data');
            markierte = [];
            var summe = 0;
            var betragFloat = 0.00;
            for (var i = 0, len = data.length; i < len; i++) {
                var rowData = data[i];
                if (rowData.state) {
                    var ausgewaehlte = {};
                    var betrag = verguenstigungen(rowData.Art, rowData.EUR, "punkt");
                    betragFloat = parseFloat(betrag);
                    markierte.push(betrag);
                    }
            }
            var ausgabe = 0;
            for (var k = 0; k < markierte.length; k++) {
                ausgabe = ausgabe + parseFloat(markierte[k]);
            }
            var summe = ausgabe.toFixed(2);
            var summe = summe.replace(".", ",");
            return summe;
     }
Thx,
Marco

4

Help for ParamQuery Pro / Check a checkbox only by click exactly on it

« on: April 07, 2015, 06:21:40 pm »

Hello,

is it possible to make a checkbox "checked" only by clicking exactly on the checkbox?
Currently a checkbox is checked also when you click next to her.

I try to check out if the checkboxes (in column 2) are changed:

Code: [Select]

$('#evnTabelle').on('change', 'td:nth-child(2)', function (e) {
alert("change");
});It worked, when i click exactly at a checkbox or the header-checkbox. But when i click next to a checkbox the checkbox is checked, but with "on change" i don`t get any event. I do not know how I can observe the entire column.

Thx,
Marco.

5

Help for ParamQuery Pro / Set css margin when Grid is maximized

« on: April 01, 2015, 05:24:44 pm »

css is an object containing css rules which are applied to grid in maximized state.

If i try to set the margin like

$("#evnTabelle").pqGrid({ collapsible: { css: { margin: 50 } } });

the table has only top and left a margin. The right and bottom side of the maximized Grid is cutted.
How can i set the right and bottom margin when the Grid is maximized?

6

Help for ParamQuery Pro / Disable maximize Button and set maxHeight Table

« on: March 30, 2015, 06:57:40 pm »

Hello,

i use the pro-Version.
Is it possible to disable the miximize-button? It`s a functionallity i don`t want to use.

Second i try to set the "maxHeight" of the grid. It were great if it`s possible to use flexHeight and something like maxHeight at the same time.
If the grid has for example only three rows, flexHeight works perfect, but if there are 100 rows, i want to limit the grid-Height (for example 500px).

Thank you and sorry for my english...

Marco