Tuesday, June 2, 2009

upload Audio Files in Sql Server by using ASP.NET and C#

Code to upload Audio/Image Files in Sql Server

First Add FileUpload Control in your Aspx Page, Then use this code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Configuration;

using System.IO;

namespace WebApplication1


public partial class _Default : System.Web.UI.Page


protected void Page_Load(object sender, EventArgs e)



protected void Button1_Click(object sender, EventArgs e)


Int32 intAudioSize = 0;

string strAudioType = null;

Stream AudioStream = null;

// Gets the Size of the Audio

intAudioSize = FileUpload1.PostedFile.ContentLength;

// Gets the Audio Type

strAudioType = FileUpload1.PostedFile.ContentType;

// Reads the Audio

AudioStream = FileUpload1.PostedFile.InputStream;

byte[] AudioContent = new byte[intAudioSize + 1];

int intStatus = 0;

intStatus = AudioStream.Read(AudioContent, 0, intAudioSize);

// Create Instance of Connection and Command Object

SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

SqlCommand myCommand = new SqlCommand("Insert into AudioTable (Audio,AudioType) Values (@Audio,@AudioType)", myConnection);

// Mark the Command as a SPROC/Query

myCommand.CommandType = CommandType.Text;

// Add Parameters to SPROC

SqlParameter prmAudio = new SqlParameter("@Audio", SqlDbType.Image);

prmAudio.Value = AudioContent;


SqlParameter prmAudioType = new SqlParameter("@AudioType", SqlDbType.VarChar, 255);

prmAudioType.Value = strAudioType;







Response.Write("New audio file uploaded successfully!");


catch (SqlException SQLexc)


Response.Write("Insert Failed. Error Details are: " + SQLexc.ToString());





1 comment:

  1. Hi Its A Great Article.

    Can U Tell Me How to Retrieve That Audio File From SqlServer2005.

    In SqlServer 2005 I have Inserted 3 Audio Files (Voice1,Voice2,Voice3) In a Row.

    I have a Button "Retrieve" in Asp.Net,C#.When I press the Retrieve Button Depending on the Row I have Selected It Has to Play Me all the Audios.

    Thanks in Advance