need to show the data in gridview

Posted by Selvimca under ASP.NET on 4/7/2015 | Points: 10 | Views : 967 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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 Kumaraspcode2009@gmail.com Selvimca, if this helps please login to Mark As Answer. \| Alert Moderator

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

Kumaraspcode2009@gmail.com

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

Latest Posts