C#

public static byte [] File2ByteArray (string szFileName)
	{
		Stream st = new FileStream (szFileName,FileMode.Open);
		byte[] bit = new byte[st.Length];
		st.Read(bit, 0 , (int)st.Length);
		st.Close();
		return bit;
	}

#region Fields

private Guid _guid;
public Guid guid
{
    get
    {
        return _guid;
    }
    set
    {
        _guid = value;
    }
}
private string _songname;
public string songname
{
    get
    {
        return _songname;
    }
    set
    {
        _songname = value;
    }
}
private Byte[] _song;
public Byte[] song
{
    get
    {
        return _song;
    }
    set
    {
        _song = value;
    }
}

#endregion

#region Database
public void Insert()
{
    DBConnect.DBCommand.CommandText = "INSERT INTO tbSongs VALUES (?, ?, ?)";

    DBConnect.DBCommand.Parameters.AddWithValue("@guid", guid);
    DBConnect.DBCommand.Parameters.AddWithValue("@songname", songname);
    DBConnect.DBCommand.Parameters.AddWithValue("@image", song);

    DBConnect.DBCommand.ExecuteNonQuery();
    DBConnect.DBCommand.Parameters.Clear();
}

public static byte[] GetFilebytes(guid guid)
{
    DBCommand = new DBCommand("SELECT songfile FROM tbsongs WHERE guid = @guid", DataBase.DBConnection);
    DBCommand.Parameters.AddWithValue("@guid", guid);
    byte[] filebytes = (byte[])DBCommand.ExecuteScalar();
    DataBase.DBCommand.Parameters.Clear();
    return filebytes;
}

byte[] filebites = GetFilebytes(songguid)
           FileStream fs = new FileStream("c:\\mysong.mp3", FileMode.CreateNew, FileAccess.Write);
           BinaryWriter bw = new BinaryWriter(fs);
           bw.Write(filebytes);
           bw.Close();
           fs.Close();

string date = DateTime.Now.ToString("dd/MM/yyyy");
string time = DateTime.Now.ToString("hh:mm:ss");

var formatted = DateTime.Now.ToString("MM_dd_yy")

var path = String.Format("Some/Directory_{0:MM_dd_yy}/somefile.txt",DateTime.Now);

protected string FormatDate()
    {
        string strTemp;
        strTemp = DateTime.Now.ToString("MM/dd/yy").Replace("/", "_");
        return strTemp;
    }

mohammadkaab wrote:

overflow error