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

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

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.


Enjoy 🙂

Thanks & Best Regards,

Rajat Jaiswal

New windows App from Indiandotnet in to increase peace, prosperity and success enjoy downloading it and share.


Dear All,

it give me immense pleasure to introduce that “Indiandotnet” release first version of  peace mantra “Ganesha Mantra”

This mantra help you in many ways.

I would like to thank many friends “SK”, “SV” who helped me in this idea and thanks all the other team member who helped me and provided feedback.

so why are you waiting enjoy by downloading


So Just download and enjoy & share

Many more to come in this week.

Enjoy learning, enjoy sharing.

|| Shri Ganeshaye namah ||



Indiandotnet Team

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



   2: SELECT,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


   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 check whether music already running in windows phone or not when you are trying to play music from your app?


Dear Friends,

Once your app is complete and  you have some background music you try to run it on simulator and you think everything working.

When you submit the app in app store you get error test case  6.5 failed.

Which Says

When the user is already playing music on the phone when the app is launched, the app must not pause, resume, or stop the active music in the phone”

So next question arises how to pass this test. so its fairly simple

Just follow below steps assuming that your page has a media player control with name  mplayer.

Step 1:- Add reference of Microsoft.Xna.Framework & Microsoft.Xna.Framework.Media on your page

Step 2: You need to write following line

   1: FrameworkDispatcher.Update();


   3: f(MediaPlayer.GameHasControl)

   4:}else if(MessageBox.Show("Isitoktostopcurrentlyplayingmusicandplaychant?")==MessageBoxResult.OK)




Now your issue is resolved.

to test this just play music in your app then run your app. It will give you popup. which we wrote above.

I hope you can submit your app now.


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

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

Now write below code which i am writing here


   2: public bool CompressFolder(String 

   3: backupFolder)


   5: {


   7: try


   9: {


  11: SevenZipCompressor sz = new SevenZipCompressor(); 


  13: SevenZip.SevenZipCompressor.SetLibraryPath(DLLPath);


  15: sz.CompressionLevel = 

  16: CompressionLevel.Ultra;


  18: sz.CompressionMode = 

  19: CompressionMode.Create;


  21: sz.CompressionMethod = 

  22: CompressionMethod.Default;


  24: sz.FastCompression = 

  25: true;


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

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

  29: "_7Zip.7z");


  31: Directory.Delete(backupFolder,true);


  33: return true;


  35: }

  36:  catch (Exception 

  37: ex)


  39: {


  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


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