datatable using sql server
datatable using sql server
hello
i'm chris and newbie for datatable.
i want to ask about how to use datatable using sql server
i've tried to show my data from mysql to datatable and it is success. everything is perfect.
but when i tried to show my data from sql server, i got trouble in there.
i can't use datatable standart query ($sQuery) for getting data to display because i think there is no "SQL_CALC_FOUND_ROWS" function in sql server, and for "FOUND_ROWS()" (for filtering) too.
when i delete them both and write "SELECT * FROM myTable" and second "SELECT COUNT(*) the data is showed but there is no filter and limit showed. i can't use search box too.
is there anyway to solve that?
i'm chris and newbie for datatable.
i want to ask about how to use datatable using sql server
i've tried to show my data from mysql to datatable and it is success. everything is perfect.
but when i tried to show my data from sql server, i got trouble in there.
i can't use datatable standart query ($sQuery) for getting data to display because i think there is no "SQL_CALC_FOUND_ROWS" function in sql server, and for "FOUND_ROWS()" (for filtering) too.
when i delete them both and write "SELECT * FROM myTable" and second "SELECT COUNT(*) the data is showed but there is no filter and limit showed. i can't use search box too.
is there anyway to solve that?
This discussion has been closed.