Retrieve pdf file from SQL C#

Question

0.00/5 (No votes)

See more:

Some help please
 
Insert into sql

yte[] filedata = null;  
           MemoryStream ms = new MemoryStream();  
           filedata = ms.GetBuffer();  
           axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());  
  
  
                   using (SqlConnection openCon = new SqlConnection(cs))  
                   {  
  
                       string saveStaff = "declare @maxNo integer = 0 select @maxNo = isnull(max(number), 0) from [dbo].[documents]; Set @maxNo=@maxNo+1; INSERT into dbo.documents (number, file_location, pdf_file) VALUES (@maxNo,@file_location,@pdf_file)";  
  
                       using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))  
                       {  
                           querySaveStaff.Connection = openCon;                            
                           querySaveStaff.Parameters.Add("@file_location", SqlDbType.VarChar, 255).Value = file_locationTextBox.Text;  
                           querySaveStaff.Parameters.AddWithValue("@pdf_file",SqlDbType.VarBinary).Value=filedata;  
  
                           openCon.Open();  
                           querySaveStaff.ExecuteNonQuery();  
                           openCon.Close();  
  
                             
  
                       }  
  
                   }  
               }

What I have tried:

Selection changed datagrid put this code

Error is when retrieve file...(no have error) noting hapend....what I wrong?
 
I think at line 3 to line 9

try  
                {  
                     if (documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value != null)  
                     {  
                        byte[] ap = (byte[])documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value;  
                        MemoryStream ms = new MemoryStream(ap);  
                        axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());  
                          
                    }  
                    else {  
                         axAcroPDF1.src = null;  
                     }  
                }  
                catch  
                {  
                    axAcroPDF1.src = null;  
                }

Posted 30-Jul-18 20:45pm

Goran Bibic

Updated 30-Jul-18 21:17pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2018-07-30T21:18:00

Solution 1

Start by not swallowing your exception: when you use a blank catch, and do nothing useful with it, you throw away all the information you need to identify the problem and solve it.
Do this:

try
{
    ...
}
catch (Exception ex)
{

    ... log the exception, display it in a message box,
    ... or stuff it on your web page - we have no idea
    ... what environment you are working in

    axAcroPDF1.src = null;
}

Then, when the code is run, you can look at the exception and hopefully see what is going wrong. But without that, you are working in the dark...

Posted 30-Jul-18 21:18pm

OriginalGriff

Comments

Goran Bibic 31-Jul-18 3:54am

Idea is:

If have pdf to show him in axAcroPDF1

If dont have axAcroPDF1.src = null;

Some help?

OriginalGriff 31-Jul-18 4:06am

And what do you think is happening at the moment?
Did you read anything I wrote?
Have you tried using the debugger?

Goran Bibic 31-Jul-18 4:17am

I read I try...but no have result...I need help to solve that... Thank you

Goran Bibic 2-Aug-18 1:48am

I try this

byte[] ap = (byte[])(documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value);
MemoryStream ms = new MemoryStream(ap);
ms.Position = 0;
File.WriteAllBytes(@"D:\mypdf.pdf", ms.ToArray());
Process.Start(@"D:\mypdf.pdf");

Dont work

OriginalGriff 2-Aug-18 2:10am

:sigh:

"It doesn't work" is probably the most useless problem report we get - and we get it a lot. It tells us nothing about what is happening, or when it happens.
So tell us what it is doing that you didn't expect, or not doing that you did.
Tell us what you did to get it to happen.
Tell us any error messages.

Goran Bibic 2-Aug-18 2:34am

I have error now...how to post picture?

OriginalGriff 2-Aug-18 2:50am

Why would I want a picture of an error message?
Copy and paste the text...

Goran Bibic 2-Aug-18 2:56am

The folowing exception occured in the DataGridView

System.ArgumentException: Parameter not valid. at system.Drawing.Image.FromStream(Stream stream, Boolean validateImageData)

That is short error text. But why Drawing image when I insert PDF in database and I wan to retrieve pdf in axAcroPDF1

I try this

byte[] ap = (byte[])(documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value);
MemoryStream ms = new MemoryStream(ap);
ms.Position = 0;
File.WriteAllBytes(@"C:\PDFs.pdf", ms.ToArray());
Process.Start(@"C:\PDFs.pdf");

Goran Bibic 2-Aug-18 2:56am

Not work that is error

OriginalGriff 2-Aug-18 3:15am

That indicates there is a problem with the file. But ... We have no access to your DB, or the rest of your code.

The first thing to check is the code that inserts the file to the DB: Use it to insert a known good PDF file, then extract the data and save it as a file. Check that file against the original: are they the same size? Does the new copy open correctly in a PDF reader?

If it passes those tests, you can start looking at the code which gets your data, and tries to open it. But not until!

Goran Bibic 2-Aug-18 3:26am

Table query

/****** Object: Table [dbo].[documents] Script Date: 2.8.2018. 09:25:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[documents](
[id] [int] IDENTITY(1,1) NOT NULL,
[number] [int] NULL,
[count_number] [varchar](255) NULL,
[label] [varchar](255) NULL,
[partner] [varchar](255) NULL,
[tax_number] [varchar](255) NULL,
[date] [date] NULL,
[file_location] [varchar](255) NULL,
[pdf_file] [varbinary](max) NULL,
CONSTRAINT [PK_documents] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Goran Bibic 2-Aug-18 3:27am

Insert into

private void Button2_Click(object sender, EventArgs e) //Save //snimi
{
byte[] filedata = null;
MemoryStream ms = new MemoryStream();
filedata = ms.GetBuffer();
axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());

if (count_numberTextBox.Enabled == true)
{
if (string.IsNullOrEmpty(idTextBox.Text))
{

using (SqlConnection openCon = new SqlConnection(cs))
{

string saveStaff = "declare @maxNo integer = 0 select @maxNo = isnull(max(number), 0) from [dbo].[documents]; Set @maxNo=@maxNo+1; INSERT into dbo.documents (number, count_number, label, partner, tax_number, date, file_location, pdf_file) VALUES (@maxNo,@count_number,@label,@partner,@tax_number,@date,@file_location,@pdf_file)";

using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
{
querySaveStaff.Connection = openCon;
querySaveStaff.Parameters.Add("@count_number", SqlDbType.VarChar, 255).Value = count_numberTextBox.Text;
querySaveStaff.Parameters.Add("@label", SqlDbType.VarChar, 255).Value = labelTextBox.Text;
querySaveStaff.Parameters.Add("@partner", SqlDbType.VarChar, 255).Value = partnerComboBox.Text;
querySaveStaff.Parameters.Add("@tax_number", SqlDbType.VarChar, 255).Value = tax_numberTextBox.Text;
querySaveStaff.Parameters.Add("@date", SqlDbType.Date).Value = dateDateTimePicker.Text;
querySaveStaff.Parameters.Add("@file_location", SqlDbType.VarChar, 255).Value = file_locationTextBox.Text;
//querySaveStaff.Parameters.Add("@pdf_file", SqlDbType.VarChar, 255).Value = partner_typeComboBox.Text;
querySaveStaff.Parameters.AddWithValue("@pdf_file", SqlDbType.VarBinary).Value = filedata;

openCon.Open();
querySaveStaff.ExecuteNonQuery();
openCon.Close();

dateDateTimePicker.Enabled = false;
count_numberTextBox.Enabled = false;
file_locationTextBox.Enabled = false;
labelTextBox.Enabled = false;
partnerComboBox.Enabled = false;
tax_numberTextBox.Enabled = false;
button3.Enabled = false;
button4.Enabled = false;

}

}
}
else
{

using (SqlConnection openCon = new SqlConnection(cs))
{
string saveStaff = "UPDATE dbo.documents SET count_number=@count_number, label=@label, partner=@partner, tax_number=@tax_number, date=@date, file_location=@file_location, pdf_file=@pdf_file WHERE id= " + idTextBox.Text;

using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
{

querySaveStaff.Connection = openCon;
querySaveStaff.Parameters.Add("@count_number", SqlDbType.VarChar, 255).Value = count_numberTextBox.Text;
querySaveStaff.Parameters.Add("@label", SqlDbType.VarChar, 255).Value = labelTextBox.Text;
querySaveStaff.Parameters.Add("@partner", SqlDbType.VarChar, 255).Value = partnerComboBox.Text;
querySaveStaff.Parameters.Add("@tax_number", SqlDbType.VarChar, 255).Value = tax_numberTextBox.Text;
querySaveStaff.Parameters.Add("@date", SqlDbType.Date).Value = dateDateTimePicker.Text;
querySaveStaff

OriginalGriff 2-Aug-18 3:50am

Well.
There's your problem.

Use the debugger, and tell me exactly what you have in filedata when you execute this line:

querySaveStaff.Parameters.AddWithValue("@pdf_file", SqlDbType.VarBinary).Value = filedata;

Then look back through your code and tell me why you have that ...

Goran Bibic 2-Aug-18 4:23am

If I good find error

Exception thrown: 'System.UnauthorizedAccessException' in mscorlib.dll

OriginalGriff 2-Aug-18 4:33am

And before that, what did you find in filedata?

Goran Bibic 2-Aug-18 4:44am

'DMS 2018.exe' (CLR v4.0.30319: DefaultDomain): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_32\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DefaultDomain): Loaded 'C:\Users\Bibic Goran\source\repos\DMS 2018\DMS 2018\bin\Debug\DMS 2018.exe'. Symbols loaded.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Caching\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Runtime.Caching.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Data.DataSetExtensions\v4.0_4.0.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\Users\Bibic Goran\source\repos\DMS 2018\DMS 2018\bin\Debug\AxInterop.AcroPDFLib.dll'. Module was built without symbols.
'DMS 2018.exe' (CLR v4.0.30319: DMS 2018.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089\System.Numerics.dll'. Skipped loading symbols. Module is opt

OriginalGriff 2-Aug-18 5:01am

If you aren't going to read anything I type, is there any point in you posting a question?

Goran Bibic 2-Aug-18 5:22am

I try to find and just this in debuger. Where to find errors?