Playing Audio and Video File in Windows Form Application

Here, I will explain how to store audio and video files in, and how to restore them from, a local database then how to play them in the Windows Media Player. I used a COM component, in other words the built-in media player in Windows. I will explain the following points:

Step 1: Go to "New Project" -> "Windows Forms application" then click on "Ok".

Step 2: Add two Buttons, one ComboBox and an OpenFileDialouge from the Toolbox.

Step 3: Now add a COM Component to the form.

Open the ToolBox then Right-click then choose "Items" -> "COM components" then select "Windows Media Player" then click "Ok". Next it will add something from the ToolBox then drag it from the Toolbox to the form.



Finally your form will look like this.



Your form is now designed. Next is the operations for the buttons. Here the Upload Button saves the file in the local database; see the following code.

Button Save

private void btnSave_Click(object sender, EventArgs e)
{
var file = GetFile();
var lst = new string[] { ".mp3", ".avi", ".mp4", ".wmv" };
if (!lst.Contains(Path.GetExtension(file)))
{
MessageBox.Show("Please select proper file.");
}
else
{
var result = SaveToDataBase(Path.GetFileName(file), GetCompressedData(file, ConvertFileToByteData(file)));
if (result)
{
cmbPlayList.Items.Add(Path.GetFileName(file));
MessageBox.Show("!! File Saved Successfully !!");
}
}
}

Here is the code to save the file in the database:

private bool SaveToDataBase(string fileName, byte[] data)
{
try
{
var ds = new DataSet();
SqlCommand cmd = new SqlCommand("insert into MyPlay values('" + Guid.NewGuid() + "','" + fileName + "',@content)");
SqlParameter param = cmd.Parameters.Add("@content", SqlDbType.VarBinary);
param.Value = data;
cmd.Connection = new SqlConnection(ConnectionString);
cmd.CommandTimeout = 0;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
return true;
}
catch (Exception)
{
throw;
}
return false;
}