- RowDatabound event tips and tricks in Gridview control
Gridview header checkbox select and deselect all rows using client side JavaScript and server side C#
All FAQ Questions - http://www.questions-interviews.com
Running Total In Gridview Footer in Asp.net
Imp Points
SELECT ISNULL(MAX(ConfirmId),0)+1 AS ConfirmId from tbl_table
Some examples
SET @recid = Substring(Cast((@MAX_ID+1000001 ) AS VARCHAR),2,6)
SET @NEW_RECNO=('XYZ'+ @recid)