Upload and Download File From Database Using GridView

Introduction: In this Article we will learn how to upload files to and download files from a database. First we save user resume details and upload resume in the database. Then we display saved information in a GridView and download the selected resume.

Step 1: First create the database in SQL; give the name of the database as TestDatabase and the table name as ResumeDetails. Define the name of columns in the table, like this:



Step 2: Create a new web page Default.aspx in Visual Studio, then add Textboxes, Labels, DropDownList and FileUpload from Tools, like this:



Use the FileUpload tool to upload a file and DropDownList to select country.

Step 3: Enter the code into the Default.aspx.cs file to input values, then click the Save button to save the values in the database table. Also put in the condition that the file to upload should be text, pdf or docx.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
SqlCommand cmm;
SqlConnection con;
SqlDataAdapter da;
string s;
protected void Page_Load(object sender, EventArgs e)
{
cmm = new SqlCommand("Insert into ResumeDetail values(@a,@b,@c,@d,@e,@f,@g,@h,@k,@i,@j,@l)");
con = new SqlConnection("Data Source=.;Initial Catalog=TestDatabase;uid=sa;Pwd=wintellect");
cmm.Connection = con;
da = new SqlDataAdapter(cmm);

if (FileUpload1.HasFile)
{
string fileExt = System.IO.Path.GetExtension(FileUpload1.FileName);

if (fileExt == ".pdf" || fileExt == ".txt" || fileExt == ".docx")
{
s = MapPath("img");
s = s + "/" + FileUpload1.FileName;
FileUpload1.SaveAs(s);
}
else
{
Response.Write("Invalid Upload file format");
}
}

cmm.Parameters.AddWithValue("@a", TextBox2.Text);
cmm.Parameters.AddWithValue("@b", TextBox3.Text);
cmm.Parameters.AddWithValue("@c", TextBox4.Text);
cmm.Parameters.AddWithValue("@d", TextBox5.Text);
cmm.Parameters.AddWithValue("@e", TextBox6.Text);
cmm.Parameters.AddWithValue("@f", TextBox7.Text);
cmm.Parameters.AddWithValue("@g", TextBox8.Text);
cmm.Parameters.AddWithValue("@h", TextBox9.Text);
cmm.Parameters.AddWithValue("@i", TextBox10.Text);
cmm.Parameters.AddWithValue("@j", TextBox11.Text);
cmm.Parameters.AddWithValue("@k", DropDownList1.SelectedValue);
cmm.Parameters.AddWithValue("@l", s);
}

protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
cmm.ExecuteNonQuery();
con.Close();
}

Step 4: After clicking the save button our database Table look like this: