Loading

Retrieve wav file from mysql

learner learner

i found the way to store wave file in mysql database as blob format.

But how to retrieve the wave file from the database and store it as audio Stream in c#?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair16y ago
SqlCommand com = new SqlCommand("select * from table", con);
DataTable dt = new DataTable();
SqlDataReader dr = com.ExecuteReader();
dt.Load(dr);
byte[] stream = (byte[])dt.Rows[0][0];
refer link
0