Need best simple way to save pdf to database from win form

Question

Need best simple way to save pdf to database from windows form Thank you

Laxmidhar Sahoo · Answer

private void button1_Click( object sender, EventArgs e) { byte [] bytes = File.ReadAllBytes(@ "C:\pdf.pdf" ); SqlParameter fileP = new SqlParameter( "@file" , SqlDbType.VarBinary); fileP.Value = bytes; SqlCommand myCommand = new SqlCommand(); myCommand.Parameters.Add(fileP); SqlConnection conn = new SqlConnection(@ "Data Source=CoastAppsDev\SQL2008;Initial Catalog=CSharpWinForms;Integrated Security=True;" ); conn.Open(); myCommand.Connection = conn; myCommand.CommandText = "spPdfInsert" ; myCommand.CommandType = CommandType.StoredProcedure; myCommand.ExecuteNonQuery(); conn.Close(); }

Laxmidhar Sahoo · Answer

hi In windos opendilog used private void selectButton_Click( object sender, EventArgs e) { if (openFileDialog1.ShowDialog() == DialogResult.OK) { try { var filePath = openFileDialog1.FileName; } catch (SecurityException ex) { } } }

Goran Bibic · Answer

How to upload file? Memory stream?

Laxmidhar Sahoo · Answer

hi 1-Select the byte array from the database then using system.io File.WriteAllBytes(@"C:	estpdf.pdf", myArrayOfBytes);

Goran Bibic · Answer

How to open this file from db to adobe reader or default pdf reader?

Need best simple way to save pdf to database from win form

Answers (5)