Select Row Number From Sql

SELECT ROW_NUMBER() OVER(ORDER BY IDP DESC) AS SrNo,Name FROM tblAgent

How to close winforms by pressing escape key

STEP 1

First Set KeyPreview Property True in Form

STEP 2

Now Create One Keydown event of Form

STEP 3

Write Below Code in Keydown Event

if (e.KeyCode == Keys.Escape)
{
     this.Close();
}

How to Get Table Full Detail From System Table

SELECT column_name 'Column Name',data_type 'Data Type',CHARacter_maximum_length 'Maximum Length'
FROM information_schema.columns
WHERE table_name = 'TABLENAME'

How To Update One DataBase Table To Another DataBase Table In SQL

USE db1
go
UPDATE t1 SET DateOfRegistration = t2.DateOfRegistration
FROM db1.TableName1 t1
JOIN db2.TableName2 t2
ON t1.IDP = t2.IDP

How To Copy One DataBase Table To Another DataBase Table In SQL

SELECT * INTO dbStudent.dbo.tblSetting FROM dbLive.dbo.tblSetting

How To Find Procedure In Create Days & Modify Days

*** CREATE DAYS ***

SELECT name FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 7

*** MODIFY DAYS ***
 
SELECT name FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7

How To Search Text In Store Procedure SQL

SELECT R.SPECIFIC_NAME,R.ROUTINE_DEFINITION FROM
dbstud.INFORMATION_SCHEMA.ROUTINES R
WHERE UPPER(R.ROUTINE_DEFINITION) LIKE '%' + UPPER('DELETE') + '%'

How To Search SQL Table Use In Store Procedure

SELECT O.NAME FROM SYSCOMMENTS C
INNER JOIN SYSOBJECTS O ON C.ID = O.ID
WHERE TEXT LIKE '%TableName%'

How To Get All Store Procedure In Current SQL DataBase

SELECT * FROM SYSOBJECTS WHERE XTYPE='P'

How Search Text In SQL Storeprocedure

SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE OBJECTPROPERTY(OBJECT_ID(SPECIFIC_NAME),'IsMSShipped') =0
AND OBJECT_DEFINITION(OBJECT_ID(SPECIFIC_NAME)) like '%Procedure Name%'
AND ROUTINE_TYPE='PROCEDURE'

How to dynamic upload image in aspx file upload control using c# windows application

i have solution for how to dynamic upload image in any browsers file upload dialog using c# windows application for more help send mail in my gmail id i give u solution for your desktop application

thank you...