string A1 = " with cte0 (B,t,at,an,Bal1,c_n,t_p_a,o_d) as (select Branch,type,account_type,account_no,Bal1,customer_name,Bal2,opening_date from pigmy_payment p1 where paid_date = ( select max(convert(datetime, paid_date)) from pigmy_payment p2 where p1.account_no=p2.account_no))select r.account_no, r.customer_name from Pigmy_customers r left join cte0 c on r.account_no=c.account_no order by paid_date DESC "; DataSet ds = g.ExecuteReader(A1, null); dataGridView1.DataSource = ds.Tables[0];
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)