Posts

Showing posts from April, 2015

(nested gridview):How to Get parent gridview rowindex on a child gridview link button click

 GridViewRow Gv2Row = (GridViewRow)((LinkButton)sender).NamingContainer; GridView Childgrid = (GridView)(Gv2Row.Parent.Parent); GridViewRow Gv1Row = (GridViewRow)(Childgrid.NamingContainer); int b = Gv1Row.RowIndex;
Post a Comment
Read more

how to get list of tables, functions and stored procedure created last month in sql server

SELECT         [name]        ,create_date        ,modify_date FROM         sys.tables where create_date >='03/01/2015'                                         SELECT * FROM sys.procedures WHERE  create_date >='03/01/2015' SELECT * FROM sys.objects WHERE type IN ('FN', 'IF', 'TF')  -- scalar, inline table-valued, table-valued
Post a Comment
Read more