convert binary to zip file

 // Initalize connection before this
SqlCommand cmd=new SqlCommand("select zipdat from table",con); //con for sqlconnection

//zipdat is column where you stored bytes of zip file

con.Open();



byte [] zipbts=(byte[])cmd.ExecuteScalar();


File.WriteAllBytes("C\\myfile.zip",zipbts);