I have the following questions:
1., Can I mapping datas in a datagrid binded to a sqlceresultset? Fe.: In the database there is "1" in a field, but i would like to display "yes" instead of in the datagrid.
2., Can I color somehow datagrid rows based on the datas ( by sql where if possible )? Fe.: I want to color to red all the rows which meets the following sql criteria WHERE col1 = '1' AND col2 LIKE '%query%' ? I would like to do this dynamically and i dont want to write an sql interpreter if not neccessary.
3., Can I add a plus row to all datagrid pages dynamically to sum the above rows values?
Thanks for help.
1., Can I mapping datas in a datagrid binded to a sqlceresultset? Fe.: In the database there is "1" in a field, but i would like to display "yes" instead of in the datagrid.
2., Can I color somehow datagrid rows based on the datas ( by sql where if possible )? Fe.: I want to color to red all the rows which meets the following sql criteria WHERE col1 = '1' AND col2 LIKE '%query%' ? I would like to do this dynamically and i dont want to write an sql interpreter if not neccessary.
3., Can I add a plus row to all datagrid pages dynamically to sum the above rows values?
Thanks for help.