Question displaying selected rows from DB to DGV

[jak]

hello experts,
i have a table in sqlserver2005 which has currently following data...

CUST_ID PAYMENT_NO DUE_DATE STATUS
1 1 15.02.09 PAID
1 2 15.03.09 NOTPAID
1 3 15.04.09 NOTPAID

2 1 20.02.09 PAID
2 2 20.03.09 NOTPAID

3 1 25.02.09 NOTPAID
3 2 25.03.09 NOTPAID

Now i want to show highligted rows in a DGV according to there status, i mean show only rows of each cust_id "notpaid" status...the 1st "notpaid" status. like in cust_id 1, first "notpaid" row. I think now u got the idea wht exactly i m trying...please guide me step by step with proper code...actually i m new and i think myself as copy-paste king...

hav a wonderfull day ahead...

 

[cjard]

Watch the videos that JohnH linked in the other thread. We really cannot give you any better help than to show you videos made by the creators of the .NET programming language