Loading

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

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

Goran Bibic

6y780Learn iOS Programming

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

Thank you

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
Accepted answer
1. private void button1_Click(object sender, EventArgs e)
2. {
3. byte[] bytes = File.ReadAllBytes(@"C:\pdf.pdf");
4. SqlParameter fileP = new SqlParameter("@file", SqlDbType.VarBinary);
5. fileP.Value = bytes;
6. SqlCommand myCommand = new SqlCommand();
7. myCommand.Parameters.Add(fileP);
8. SqlConnection conn = new SqlConnection(@"Data Source=CoastAppsDev\SQL2008;Initial Catalog=CSharpWinForms;Integrated Security=True;");
9. conn.Open();
10. myCommand.Connection = conn;
11. myCommand.CommandText = "spPdfInsert";
12. myCommand.CommandType = CommandType.StoredProcedure;
13. myCommand.ExecuteNonQuery();
14. conn.Close();
16. }

Laxmidhar Sahoo

Laxmidhar Sahoo6y ago

hi

1-Select the byte array from the database then

using system.io

File.WriteAllBytes(@"C:\testpdf.pdf", myArrayOfBytes);

Goran Bibic6y ago

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

Laxmidhar Sahoo

Laxmidhar Sahoo6y ago

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 Bibic6y ago

How to upload file? Memory stream?