Lowyat.NET: Latest topics by slacx

Select COUNT in Datagridview

slacx — Sat, 28 Aug 2010 07:10:16 +0800

Hi everyone!

I'm using ADO.net to connect to MySQL and Oracle server and have fill the dataset with all the datas that I want. Right now I want to show in datagridview how many error I found in the dataset. For example, in my datatable I have

Product Status
A OK
A OK
A NOT_OK
B NOT_OK

I want to have table like this and show it in datagridview

Product NOT_OK Percentage_NOT_OK
A 1 33%
B 1 100%

How can I do this? I'm trying without using another SQL Query ( Select COUNT (Product) from [mydatabase] where NOT OK = 1)

Any ideas anyone?

Switches debounce and output to LCD in gcc

slacx — Sat, 12 Jan 2008 04:16:10 +0800

Interrupt Service Routine

slacx — Sat, 10 Nov 2007 04:59:03 +0800

Hi all,

i want to add one interrupt in my program but i stuck with it using microproc 80535. Currently my program run smoothly with one interrupt timer(with 6 LEDs blinking at specific time). But i want to add one more condition in it so that if i push one button all the lights will go off but just one light will blinking(but still using the same timing with the main program). What interrupt should i choose? and where can I put it?

Thanks for any help.