Sai mantra – New Windows app for peace, prosperity and joy

Dear All,

It give me immense pleasure to introduce new windows app  “Sai Mantra”.

Enjoy the sai mantra.

You can download the windows app from http://www.windowsphone.com/en-us/store/app/saimantra/653b08fc-36b4-4312-a754-8536a2398892

Thanks & Best Regards,

Rajat Jaiswal

New Windows Phone App – Mata Mantra Hurry up and download now.

 

Dear All,

How are you ?

It give me pleasure to introduce a new application develop by  “Indiandotnet”.  The application is all about “Durga Mantra” which increase peace, prosperity  so enjoy by downloading following windows app with following link.

http://www.windowsphone.com/en-us/store/app/mataji-mantra/dcfa42bd-09fc-4c9e-bd66-a9caa5e75864

Enjoy :)

Thanks & Best Regards,

Rajat Jaiswal

How to determine list of all the databases and size of the database ?

 

Dear All,

Sometimes you require list of all the database and size.

To achieve this we need to write  following script

 

   1:  

   2: SELECT sd.name,Convert(Decimal(10,0),(mf.size /1024)) As size

   3: FROM 

   4: sysdatabases sd

   5: INNER JOIN sys.master_files mf ON mf.database_id = 

   6: sd.dbid

   7:  

   8: AND mf.type = 0 

   9: WHERE sd.Name Not IN ('MASTER','tempdb','Model','MSDB')

 

Hope it will resolve your query. Enjoy :)

Rajat Jaiswal

How to do 7zip programmatically using C# ?

Dear All,

Some times it may be possible you require to  make zip of  a file or directory.

so here is simple example.

To start it you have to download “SevenZipSharp.dll”, “7z.dll” you can download sdk from http://www.7-zip.org/sdk.html

Once you download sdk copy above 2 DLL in your project bin folder.

Now write below code which i am writing here

   1:  

   2: public bool CompressFolder(String 

   3: backupFolder)

   4:  

   5: {

   6:  

   7: try

   8:  

   9: {

  10:  

  11: SevenZipCompressor sz = new SevenZipCompressor(); 

  12:  

  13: SevenZip.SevenZipCompressor.SetLibraryPath(DLLPath);

  14:  

  15: sz.CompressionLevel = 

  16: CompressionLevel.Ultra;

  17:  

  18: sz.CompressionMode = 

  19: CompressionMode.Create;

  20:  

  21: sz.CompressionMethod = 

  22: CompressionMethod.Default;

  23:  

  24: sz.FastCompression = 

  25: true;

  26:  

  27: sz.CompressDirectory(backupFolder, BackupPath + "\\" + 

  28: DateTime.Now.Date.ToString("yyyyMMddHHmmss") + 

  29: "_7Zip.7z");

  30:  

  31: Directory.Delete(backupFolder,true);

  32:  

  33: return true;

  34:  

  35: }

  36:  catch (Exception 

  37: ex)

  38:  

  39: {

  40:  

  41: throw ex;

  42:  }

Now let me describe the code to you.

This is function which compress the folder to 7zip what ever pass as a paramter

in this function we have created a sevenzip compressor object

SevenZip.SevenZipCompressor.SetLibraryPath(DLLPath);

in the above line we set the DLLpath which is basically your bin folder path

sz.CompressionLevel = CompressionLevel.Ultra; is compress level which can be different according to your need.

sz.CompressDirectory(backupFolder, BackupPath + "\\" + DateTime.Now.Date.ToString("yyyyMMddHHmmss") + "_7Zip.7z");

above row compress the directory of backupfolder and rename with datetime_7zip.7z

I hope this will help you.

Enjoy 7zip.

Thanks & Best Regards,

Rajat Jaiswla