thats what i had done but after doing it i was getting double columnname
currently wht i have fr binding the grid is
in form load i hve
sqlstr="
select p.id , p.pname ,0 as QTY, p.RATE, AMOUNT, p.dtfrm as From_DT,p.dtto as To_DT from PRDT left join M_customer C On C.Cid = t.cust_id left...