Check if Binary File already exists in Database in ASP.Net

Hi firoz1986,

I have made a sample that full-fill your requirement.

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        BindGrid();
    }
}
private void BindGrid()
{
    string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(strConnString))
    {
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = "select Id, Name from tblFiles";
            cmd.Connection = con;
            con.Open();
            GridView1.DataSource = cmd.ExecuteReader();
            GridView1.DataBind();
            con.Close();
        }
    }
}

protected void btnUpload_Click(object sender, EventArgs e)
{
    using (BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream))
    {
        byte[] bytes = br.ReadBytes((int)FileUpload1.PostedFile.InputStream.Length);
        string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(strConnString))
        {
            SqlCommand cmd = new SqlCommand("SELECT COUNT(*) from tblFiles where Name like @Name1", con);
            con.Open();
            cmd.Parameters.AddWithValue("@Name1", Path.GetFileName(FileUpload1.PostedFile.FileName));
            int count = Convert.ToInt32(cmd.ExecuteScalar());
            if (count <= 0)
            {
                cmd.CommandText = "insert into tblFiles(Name, ContentType, Data) values (@Name, @ContentType, @Data)";
                cmd.Parameters.AddWithValue("@Name", Path.GetFileName(FileUpload1.PostedFile.FileName));
                cmd.Parameters.AddWithValue("@ContentType", "audio/mpeg3");
                cmd.Parameters.AddWithValue("@Data", bytes);
                cmd.Connection = con;
                cmd.ExecuteNonQuery();
                Response.Redirect(Request.Url.AbsoluteUri);
            }
            else
            {
                Response.Write("<script language=javascript>alert('File already exist.');</script>");
            }

            con.Close();
        }
    }
}

Screenshot

Hope this will solve your problem.