print last row in datagrid from table?

Posted by Hariinakoti under C# on 4/13/2012 | Points: 10 | Views : 2464 | Status : [Member] | Replies : 13

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi,

i need to print the last row of the table in the data grid form .i am using the sql server and c#.net.. i want to print the recently inserted row of the table.. can u tell me the answer..

Thanks & Regards
Hari

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Self-Innovator on: 4/13/2012 [Member] Bronze | Points: 25

0	Select TOP 1 * from tbUserMst order by 'ActNoId' desc tbUserMst-tablename ActNoId-ColumnName Join Hands Change lives Thanks & Regards Straight Edge Society Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Hariinakoti on: 4/13/2012 [Member] Starter | Points: 25

0	@Self inovator i got error at this query Thanks & Regards Hari Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Self-Innovator on: 4/13/2012 [Member] Bronze | Points: 25

0	WILL U SPECIFY THE ERROR....Post your Query Join Hands Change lives Thanks & Regards Straight Edge Society Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Hariinakoti on: 4/13/2012 [Member] Starter | Points: 25

0	select top1 * from sales orderby 'Itemcode' desc I got error at top1 and if i remove top1 next error at column name. Thanks & Regards Hari Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Self-Innovator on: 4/13/2012 [Member] Bronze | Points: 25

0	make sure u've given space betwwen TOP & 1 not like TOP1 select top 1 * from sales orderby 'Itemcode' desc Join Hands Change lives Thanks & Regards Straight Edge Society Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Hariinakoti on: 4/13/2012 [Member] Starter | Points: 25

0	Ok,Thanq . But i entered some values in the table itz displayed but not last record.. Thanks & Regards Hari Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Self-Innovator on: 4/13/2012 [Member] Bronze | Points: 25

0	It wil disp try.. Join Hands Change lives Thanks & Regards Straight Edge Society Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Hariinakoti on: 4/13/2012 [Member] Starter | Points: 25

0	itz not display dude..only highest value only displayed. Thanks & Regards Hari Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sridevi on: 4/13/2012 [Member] Starter | Points: 25

0	Try this Select * from tname order by tno desc limit 1; tname -> table name tno -> column Regards, Sridevi. Sridevi Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sridevi on: 4/13/2012 [Member] Starter | Points: 25

0	Sorry don't follow the above query its not working Sridevi Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Hariinakoti on: 4/14/2012 [Member] Starter | Points: 25

0	@sridevi ok,thanq.if u know plz solve my problem Thanks & Regards Hari Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Somasundaram on: 4/14/2012 [Member] Starter | Points: 25

0	try by using max() function Hope you can find solution in this.. Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Hariinakoti on: 4/15/2012 [Member] Starter | Points: 25

0	plz tell me that query Thanks & Regards Hari Hariinakoti, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts