Thursday, January 17, 2013

How to find the Size of the Screen in C#.net

   
 To find the size (Height and Width) of the computer screen write the followingcode


  Rectangle resolution = Screen.PrimaryScreen.Bounds;
            int height = resolution.Size.Height;
            int width = resolution.Size.Width;

Wednesday, January 9, 2013

How to delete Duplicate Record From a Table in SQL Server

DELETE TOP (SELECT COUNT(*) -FROM dbo.Emptest WHERE EmpID 'Basharat'FROM dbo.Emptest  WHERE EmpID 'Basharat'

Tuesday, January 8, 2013

How to Isert Data From Text File to SQL Server Table

BULK
INSERT TempSOC_Main--Table Name
FROM 'G:\KS_09_01_13_1133\SOCMain.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO