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 = newSqlConnection(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);
}
