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 join M_prdt P On P.id = t.id where t.cust_id = " & dropdown1.SelectedValue & "
grid_trans.DataSource = ds1.Tables("trans")
grid_trans.AllowUserToAddRows = False
grid_trans.Columns(0).Visible = False
Bookmarks