How to detect file size of a file inside App_Data [Answered]RSS

• • Reply
  hkbeer

  Member

  737 Points

  2362 Posts

  How to detect file size of a file inside App_Data

  Oct 11, 2017 03:19 AM|hkbeer|LINK

  I am planning to have code to detect the file size of a db1 file I am using inside App_Data and if its size exceed
  say 5G then my next add record to db will use connectionstring2 to add to db2 instead.

  So in the first place what is the code to get file size of db1 ?

  Thanks

  Thanks. I will try to credit the ones who helped but most important is we really do sincerely thanks to all who have helped.
  
  www.developerfusion.com/tools/convert/csharp-to-vb/
• • Reply
  A2H

  All-Star

  50601 Points

  9821 Posts

  Re: How to detect file size of a file inside App_Data

  Oct 11, 2017 05:06 AM|A2H|LINK

  hkbeer

  what is the code to get file size of db1 ?

  You can use the FileInfo.Length property to get the size of file

  Sample Code

  //Change the name of file accordingly
  				string path = Server.MapPath("~/App_Data/db1.mdf");
  				System.IO.FileInfo file = new System.IO.FileInfo(path);
  				//Check if file exists or not
  				if (file.Exists)
  				{
  					//FileSize in bytes
  					long filesize = file.Length;
  					//Converting Bytes to GB
  					long Gbsize = filesize / (1024 * 1024 * 1024);
  				}

  Thanks,
  Aje
  My Blog | Dotnet Funda