Upload an Image and an Audio file using C#


In my case, I use  a FileUpload Control(Id:->FileUpload1), an ImageButton(ImageButton1) or you can use the Image,  a Button Control(Id:->Updatebttn) to upload my Image, Button Control(Id:->Addbttn) to add my Image in database, an image(which I want to upload), add a new folder (Image) in my WebForm.

Steps:

1. Create a table in the database(abc):->

create table Image1
(
id int identity(1,1),
image1 varchar(100)
);

2. Coding for connectionstring in web.config

<connectionStrings>
    <add name="conn" connectionString="Data Source=MAHAK\SQLEXPRESS;Initial Catalog=abc;Integrated Security=True;"/>
</connectionStrings>

3. In My WebForm(Page1.aspx.cs):

providerName:

using System.Data;
using System.Data.SqlClient;

connectionstring:

SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);

4. Uploadbttn Coding:

if (FileUpload1.HasFile)
{
    string fileName = FileUpload1.FileName.ToString();
    string uploadFolderPath = "~/Image/";
    string filePath = HttpContext.Current.Server.MapPath(uploadFolderPath);
    FileUpload1.SaveAs(filePath + "\\" + fileName);
    ImageButton1.ImageUrl ="~/Image/" + "/" + FileUpload1.FileName.ToString();
}

5. Addbttn Coding:

conn1.Open();
SqlCommand cmd3 = new SqlCommand("insert into Image1(image1) values('" + ImageButton1.ImageUrl + "')", conn1);
cmd3.ExecuteNonQuery();
conn1.Close();

(b) Audio File Upload:

Create a table in the database(abc):

create table Audio1
(
id int identity(1,1),
audio1 varchar(100)
);

Use FileUpload Control and a Button(Id:->Uploadbttn)

In this case add a folder(Audio) in WebForm

Uploadbttn Coding:

if(FileUpload1.HasFile)
{
    string fileName = FileUpload1.FileName.ToString();
    string uploadFolderPath = "~/Audio/";
    string filePath = HttpContext.Current.Server.MapPath(uploadFolderPath);
    FileUpload1.SaveAs(filePath + "\\" + fileName);
}


Similar Articles