select [e.stdregisterno] as RegNo, [e.stdname] as Name, [e.stdsection] as Section, [e.bookno] as BookNo, FORMAT([e.stdbookretdate],'dd/mm/yyyy')as Ret_Date, FORMAT([e.bookdate],'dd/mm/yyyy')as BookDate, [e.rackname] as Rack, [f.partyname] as Party, [f.address3] as Address FROM [Tbl_sc_bookissue] e, [Tbl_com_schoolprofile] f WHERE e.compid=f.compid AND [e.Bissueflag]='I' AND [e.stdname]='" + DropDownList3.Text + "'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)