C# MS Access Connection String OLE DB OleDbConnection

The Connection String for MS Access can be set as ;

 private constr =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdbfile.mdb;
Jet OLEDB:Database Password=yourpassword;";

And the C# code to connect to MS Access database ;

 public bool OpenConnection()
{
OleDbConnection con; con = new OleDbConnection(constr);

if (con.State != ConnectionState.Open)
{
 try
 {
   con.Open(); return true;
 }
catch (Exception) { return false; }
}
else return false;
}

C# Access Connection String OLE DB OleDbConnection password field is the password you set up in access database.

Mobile Phone Hide Your Number

To hide your number when you are calling someone with your mobile phone,
simply add *31# in the beginning of the number you will call.

hide number
*31#

Imei Number Learn Your Mobile Phone Imei Number

You can easily learn you mobile phone's IMEI number
by pressing star square 06 square

*#06#

C# Read Harddisk Serial Number WMI ManagementClass Win32_LogicalDisk

With the Win32_LogicalDisk Management path we can reach the local disk information.

Even you can read harddisk serial number,
size, partitions, free space and so on.

Now let's read the serial number of a harddisk in C# with ManagementClass WMI.

public static string HardDiskID()
{
 ManagementClass partionsClass = new ManagementClass("Win32_LogicalDisk");
 ManagementObjectCollection partions = partionsClass.GetInstances();

 string hdd = string.Empty;

 foreach (ManagementObject partion in partions)
 {
 hdd = Convert.ToString(partion["VolumeSerialNumber"]);

 if (hdd != string.Empty)
 return hdd;
}

return hdd;
}

This static function will simple give us the volume serial numbers.
C# Read Harddisk Serial Number WMI ManagementClass.

C# Textbox Auto Scroll To End ScrollToCaret Scrolling Textbox

Many of my sample C# codes,
I use textbox to write the results.

When textbox is multiline property set to true, and when I insert text into it,
I want it to auto scroll to the last line.

Here is a simple way to auto scrolling textbox.

 textbox1.SelectionStart = textbox1.Text.Length;
 textbox1.ScrollToCaret();
 textbox1.Refresh();

Textbox SelectionStart will force the textbox control to select the last part of the text,
and ScrollToCaret() function will auto scroll textbox to the end.

C# The process cannot access the file because it is being used by another process

The process cannot access the file because it is being used by another process.
This error message is mostly comes up,
when you try to access a file which is opened by another process.

You may open an image file in one of your form in a picturebox with using ImageFromFile or something.
I mostly use memorystream to open an image.
After read it in byte[] write it into a stream and close it.

You can check whether a file is being used or not with a simple function.
Try to open a file with none share.

 public bool IsFileUsedbyAnotherProcess(string filename)
 {
 try
 {
  File.Open(filename, FileMode.Open, FileAccess.Read, FileShare.None);
}
catch (System.IO.IOException exp)
{ 
return true;
}
return false;

}

This function will return true if
the file because it is being used by another process or not.

C# Convert Hexadecimal to Binary String Conversion

There is no need to code tons of codes, loops, to convert hex to binary string. Convert.ToInt32 function is very useful for this purpose.
Let's convert the "A" character to binary format.

private string hex2binary(string hexvalue)
{
  string binaryval = "";
  binaryval = Convert.ToString(Convert.ToInt32(hexvalue, 16), 2);
  return binaryval;
}

When we call hex2binary("A"); it will return "1010" similar samples below;

hex2binary("1a"); will return "11010";
hex2bianry("1a2c"); will return "1101000101100"; and so on.

Keep in mind that this hex to binary conversion style uses 32 bit integer number.