need to show the data in gridview

Posted by Selvimca under ASP.NET on 4/7/2015 | Points: 10 | Views : 231 | Status : [Member] | Replies : 1
i have data in a table like


name date amount

celv 15/04/15 6000


raj 15/04/15 500000


mani 16/04/15 1000



i show it in gridview


now the data is update for this column


mani 16/04/15 0


i have to show the following data only



name date amount

celv 15/04/15 6000


raj 15/04/15 500000




Responses

Posted by: Jayakumars on: 4/7/2015 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
Try this code

Create Table Tes1
(
Name varchar(50),
date date,
amount decimal(18,2)
)

Insert into Tes1 values('celv','2015/04/15',6000)
Insert into Tes1 values('raj','2015/04/15',500000 )
Insert into Tes1 values('mani','2015/04/16',1000 )


SELECT * from Tes1 WHERE date ='2015-04-15'

Mark as Answer if its helpful to you

Selvimca, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response