< asp: FileUpload AllowMultiple = "true"
ID = "fileuploadimages"
runat = "server" / > < asp: Button runat = "server"
ID = "btnUpload"
CssClass = "btnStyle"
Text = "Upload Image"
OnClick = "btnUpload_Click" / >
protected void btnUpload_Click(object sender, EventArgs e)
{
if (fileuploadimages.HasFile == false)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", "
<script>alert('No File Uploaded.')</script>", false);
}
else
{
foreach(var file in fileuploadimages.PostedFiles)
{
string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);
fileuploadimages.SaveAs(Server.MapPath("../Pictures/" + filename));
SqlCommand cmd = new SqlCommand("Insert into
EventPageView(Event_name,Event_Text,Image_Path)
values(@EventName,@EventText,@ImagePath)", conn);
cmd.Parameters.AddWithValue("@ImagePath", filename);
cmd.Parameters.AddWithValue("@EventName", txtEventName.Text);
cmd.Parameters.AddWithValue("@EventText", txtEnterDesc.Text);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
BindDataList();
}
}
}In this code I will explain how to upload and save (insert) multiple files to SQL Server database in ASP.NET using C#.
