How should I play the mp3 file as per gridview row selection in ASP.NET C#

Question

1.00/5 (1 vote)

See more:

SQL-Server-2012

below is my code plz help me to solve that problem

What I have tried:

GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent;
        int index = gvRow.RowIndex;
        int TID = Convert.ToInt32(gvTrainStatus.DataKeys[index]["TID"]);
        Session["TID"] = TID;

        //if (TID = Session["TID"])
        //{
            DataTable dt = new DataTable();
            SqlConnection con = new SqlConnection(CS);
            con.Open();
            SqlCommand cmd = new SqlCommand("SPShowData", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@TID", Session["TID"]);
            SqlDataAdapter sqlDa = new SqlDataAdapter(cmd);
            sqlDa.Fill(dt);
            if (dt.Rows.Count > 0)
            {



            //SoundPlayer sd = new SoundPlayer();
            //lblTrainNo.Text = dt.Rows[0]["TrainNo"].ToString();
      

            SoundPlayer player = new SoundPlayer();
            player.SoundLocation = AppDomain.CurrentDomain.BaseDirectory + "Sound/0.mp3";
            player.Play();

Posted 8-Jun-18 0:23am

Shahbaz435

Updated 8-Jun-18 6:32am

Add a Solution

2 solutions

Solution 1

You are trying to play an MP3 file using the SoundPlayer class:

C#

SoundPlayer player = new SoundPlayer();
player.SoundLocation = AppDomain.CurrentDomain.BaseDirectory + "Sound/0.mp3";

But the SoundPlayer Class (System.Media)[^] can only play WAV files:

Quote:
Controls playback of a sound from a .wav file.

Use the Media Player instead and / or search the web for something like "c# play mp3" which provides plenty of examples.

Posted 8-Jun-18 1:01am

Jochen Arndt

Comments

Shahbaz435 8-Jun-18 7:00am

I had tried but not getting anything

Jochen Arndt 8-Jun-18 7:15am

What have you tried?

There are multiple solutions to play MP3 files. However, each requires a specific player to be installed that supports MP3.

Shahbaz435 8-Jun-18 7:17am

im getting this error
The file located at E:\Railways\App_Code\0.mp3 is not a valid wave file.

Jochen Arndt 8-Jun-18 7:21am

Did you read my answer?

But the SoundPlayer Class can only play WAV files

The SoundPlayer does not support playing MP3 files which it tells you too by the error message.

Shahbaz435 8-Jun-18 7:33am

yes thanks but i need 1 more help from you

Shahbaz435 8-Jun-18 7:33am

how to add multiple wave file as per data in database

Jochen Arndt 8-Jun-18 7:41am

Do you mean adding to a single recordset?

A database is usually not intended for using some kind of array within a recordset. You would either have multiple fields (e.g. for specific types of sounds), or a reference to another table containing the file names.

But for only a few files you might store the names separated by a delimiting character like comma or semicolon and split that when reading.

Shahbaz435 8-Jun-18 7:43am

i have 1 to 10 recorded files and i want to caocate them as per gridview selection the files should be merge on the selection like 234 so sound would be like 234

Jochen Arndt 8-Jun-18 7:56am

It is a question of the database design. As already said, a "classic" database would use another table with the names.

It is finally up to you to decide.

Shahbaz435 8-Jun-18 8:13am

no the wave files should be aaded in my folder i want to fetch the record from db and as per db it will be moving to wave files and checking the both are match and as per match the sound would be flow

Jochen Arndt 8-Jun-18 8:19am

Still unclear for me but also still a database design problem.

If you have a total number of 10 files for all recordsets, create a table for those 10 files and have a field in your grid table that contains the indexes to be played (e.g. storing packed in a long integer) or any other value / method that defines what to be played.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2018-06-08T06:34:00

You have flagged this question as ASP.NET. That means your code is running on the server. The audio file will play on the server, where nobody - except maybe some bemused sysadmins - will ever hear it.

It might appear to work when you debug your code in Visual Studio. But that's only because, in that specific scenario, the server and client are the same computer.

As soon as you deploy to a real server, your users will complain that the sound doesn't play. (And your sysadmins will complain about the cacophony emanating from your server.)

To play sound on the client, you need to use the HTML <audio> element, along with some Javascript.
<audio>: The Embed Audio element - HTML | MDN[^]