data for mation of data grid

{0:dd-MM-yyyy}

Generate Random Number between specified range

private int GenerateNewRandomNumber(int min, int max)
{
Random Myrandom = new Random();
return Myrandom.Next(min, max);
}


//To call function
int Myrandom= GenerateNewRandomNumber(5, 20);

valuble validation scripts Asp.net C#

Enter atleast 5 characters
^.{5,}$


Please ignore the space character.

^[\S]*$

ziping folder using ICSharpCode dll

using ICSharpCode.SharpZipLib.Zip;

private static void ListZipContent(string sFile)
{
ZipFile zip = new ZipFile(File.OpenRead(sFile));
foreach (ZipEntry entry in zip)
{
//Console.WriteLine(entry.Name);
}
}

private static void CompressZip(string sPath, string zipSavingPath)
{
try
{
string zipName = DateTime.Now.ToString("m") + ".zip";
ZipOutputStream zipOut = new ZipOutputStream(File.Create(zipSavingPath + zipName));
//ZipOutputStream zipOut = new ZipOutputStream(File.Create(sPath));
foreach (string fName in Directory.GetFiles(sPath))
{
FileInfo fi = new FileInfo(fName);
ZipEntry entry = new ZipEntry(fi.Name);
FileStream sReader = File.OpenRead(fName);
byte[] buff = new byte[Convert.ToInt32(sReader.Length)];
sReader.Read(buff, 0, (int)sReader.Length);
entry.DateTime = fi.LastWriteTime;
entry.Size = sReader.Length;
sReader.Close();
zipOut.PutNextEntry(entry);
zipOut.Write(buff, 0, buff.Length);
}
zipOut.Finish();
zipOut.Close();
}
catch (Exception ex)
{

}
}

Simple copy functionality in C#

public class SimpleFileCopy
{
public void CopyFile(string sourcePath, string targetPath, string folderPath)
{
try
{
if (!System.IO.Directory.Exists(folderPath))
{
System.IO.Directory.CreateDirectory(folderPath);
}
System.IO.File.Copy(sourcePath, targetPath, true);
}
catch (Exception ex)
{
}
}
}
#endregion

create a permition script on Sql Script

GO
USE DatabaseName
GO

--~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--REMOVE EXISTING SECURITY
EXEC sp_dropuser 'UnWantedLoginName'
GO

--~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--ADD DB SECURITY
--Add Users--------------
if not exists (select * from dbo.sysusers where name = N'NewLoginName' and uid < 16382)
EXEC sp_grantdbaccess N'NewLoginName', N'NewLoginName'
GO
EXEC sp_addrole N'ro_NewLoginName', N'NewLoginName'
GO
--Add Members-------------
exec sp_addrolemember N'ro_NewLoginName', N'NewLoginName'
GO

--~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--ADD OBJECT SECURITY
--Security for Tables-------------------
DECLARE ETables CURSOR
READ_ONLY
FOR SELECT Name
FROM dbo.sysobjects
WHERE OBJECTPROPERTY(id, N'IsTable') = 1
AND Name like 'tbl%' OR Name = 'EmployeeStatus' OR Name = 'Holidays' OR Name = 'UserGroup'
ORDER BY Name
DECLARE @name varchar(200)

OPEN ETables
FETCH NEXT FROM ETables INTO @name
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
DECLARE @sSQL nvarchar(4000)
SET @sSQL = 'GRANT SELECT ON [' + @name + '] TO ro_NewLoginName'
EXEC sp_ExecuteSQL @sSQL
END
FETCH NEXT FROM ETables INTO @name
END
CLOSE ETables
DEALLOCATE ETables

--Security for Views--------------
DECLARE EViews CURSOR
READ_ONLY
FOR SELECT Name
FROM dbo.sysobjects
WHERE OBJECTPROPERTY(id, N'IsView') = 1
AND Name not like 'sys%'
ORDER BY Name
OPEN EViews

FETCH NEXT FROM EViews INTO @name
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
SET @sSQL = 'GRANT SELECT ON [' + @name + '] TO ro_NewLoginName'
EXEC sp_ExecuteSQL @sSQL
END
FETCH NEXT FROM EViews INTO @name
END

CLOSE EViews
DEALLOCATE EViews

--Security for SP's
DECLARE ESps CURSOR
READ_ONLY
FOR SELECT Name FROM dbo.sysobjects
WHERE OBJECTPROPERTY(id, N'IsProcedure') = 1
AND (name like 'usp%') OR name = 'DeleteUser' OR name = 'GetAllUsers' OR name = 'AddUser' OR name = 'UpdateUser'
ORDER BY Name
OPEN ESps

FETCH NEXT FROM ESps INTO @name
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
SET @sSQL = 'GRANT EXECUTE ON [' + @name + '] TO ro_NewLoginName'
EXEC sp_ExecuteSQL @sSQL
END
FETCH NEXT FROM ESps INTO @name
END
CLOSE ESps
DEALLOCATE ESps

--Security for Scaler Functions-----------
DECLARE EFns CURSOR
READ_ONLY
FOR SELECT Name
FROM dbo.sysobjects
WHERE OBJECTPROPERTY(id, N'IsScalarFunction') = 1
ORDER BY Name

--DECLARE @name varchar(40)
OPEN EFns

FETCH NEXT FROM EFns INTO @name
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
SET @sSQL = 'GRANT EXECUTE ON [' + @name + '] TO ro_NewLoginName'
EXEC sp_ExecuteSQL @sSQL
END
FETCH NEXT FROM EFns INTO @name
END
CLOSE EFns
DEALLOCATE EFns

Link two tables from two separate databases from separate location

select * from Databasename1.dbo.tblEmployees t1
inner join OPENDATASOURCE('SQLOLEDB','Data Source=databasename;User ID=sa;Password=123').Databasename2.dbo.leave t2 on t1.Id = t2.Id