Database

Manufacture                 Model No                Length         Width      height 

Manufacture 1              MD-01                    200               300        100

Manufacture 1              MD-02                    300               400        100

Manufacture 1              MD-03                    400               300         150

Manufacture 2              MAD-01                    200              450        100

Manufacture 2              MAD-02                   250               400        100

Manufacture 3              MDI-01                   300               300         100

Manufacture 4              MOv-01                   350               300         100

public bool DeleteFile(Int32 identity)
{
    string connString = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Code\\FileDB.mdf;Integrated Security=True;Connect Timeout=30";

    SqlConnection dbConn = new SqlConnection(connString);
    dbConn.Open();

    using (SqlCommand com = new SqlCommand("DELETE FROM HiddenFile WHERE Id = @Identity)", dbConn))
    {
        com.Parameters.AddWithValue("@Identity", identity);

        com.ExecuteNonQuery();
    }

    dbConn.Close();

    return true;
}