Save audio into SQL

Question

Hello everybody, I want to save a file audio into SQL but I don't know how to save. Can you help me, please?

Dinkar Chavhan · Answer

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} Audio Song Uploading and save in DB In this Article we see how to upload Audio or MP3 song in Database and also Aplication folder like Audio.This is simple code useful for Developer So lets see step by step procedure Step 1) Take textbox and fileupload control and Button Step 2)Create table like { Create table with two colomns like id(pk) and song ( } Step 3)Now write stored procedure { ALTER procedure Sp_Audio(@id int ,@song varchar (50)) As Begin insert into Audio(id,song) values (@id,@song) end } } Step 4)Now double click on Button and write code { SqlConnection cn = new SqlConnection ( "Give Path" ); SqlCommand cmd = new SqlCommand (); cmd.Connection = cn; cn.Open(); cmd.CommandText = "Sp_Audio" ; cmd.CommandType = CommandType .StoredProcedure; cmd.Parameters.AddWithValue( "@id" , TextBox1.Text); cmd.Parameters.AddWithValue( "@song" , FileUpload1.FileName); int i=cmd.ExecuteNonQuery(); if (FileUpload1.HasFile) { string fname = FileUpload1.FileName.ToString(); string folderpath = "~/Audio" ; string path = HttpContext .Current.Server.MapPath(folderpath); FileUpload1.PostedFile.SaveAs(path + "\" + fname); Label1.Text = "file uploaded successfully" ; } } } Step 5)Now Run Application

Krishna Garad · Answer

Check out this article .

Save audio into SQL

Answers (2)