Dear sir,
I'm working on a library project. The price of all books store in money data type in sql server 2008. It shows the correct format in sql select statement. But when I'm show the data in a grid view it shows four zero after decimal point.
Thanks in advance
Bigyan ranjan sahoo
select UGC,BookName,AuthorName,Edition,PublisherName,AccessingNo,Segment,Department,RackCatagory,Type,DamagedStatus,IssueStatus,round(Cost,2) AS Cost,BillDate,PurchaseDate,DateofRecieved,CompleteAddress,DateOfPublisher from tblBookStore where AuthorName='R. N. Nanda'