C# Discussion Boards - CodeProject

27-Aug-08 3:32

Hi how do i write files to a database, i have used streams in vb before, but i cant see an example of doing it in c#. can anyone please help me with a simple example or links to examples.
in the table the column format is image

thank u

laziale27-Aug-08 3:32

27-Aug-08 3:32

what kind of database do you use?

omlac27-Aug-08 4:05

27-Aug-08 4:05

im using sql server 2005

omlac27-Aug-08 3:55

27-Aug-08 3:55

i try doing the following

streamreader strReader = new StreamReader(@"c\logfile.pdf")
;
and then i pass it as parameter like this
SqlCmd.Parameters.AddWithValue("@Attachment", strReader.ReadToEnd());

But i get the following error message
System.Data.SqlClient.SqlException: Operand type clash: nvarchar(max) is incompatible with image

leppie27-Aug-08 3:57

27-Aug-08 3:57

you want to use varbinary(max) instead.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

omlac27-Aug-08 4:08

27-Aug-08 4:08

will this handle any file format Leppie

leppie27-Aug-08 4:12

27-Aug-08 4:12

omlac wrote:
will this handle any file format

Yes, as long as you pass a byte[] into it (I see your snippet was reading a string, you probably want the bytes instead).

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

omlac27-Aug-08 4:28

27-Aug-08 4:28

@Leppie
Thats correct im gettin an error that cant convert from string to byte, but how do i read a file as byte, may u please here.

leppie27-Aug-08 4:29

27-Aug-08 4:29

File.ReadAllBytes()

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

omlac27-Aug-08 4:31

27-Aug-08 4:31

thank u very much

webBrowser control question

Alireza Loghmani27-Aug-08 9:12

Alireza Loghmani

27-Aug-08 9:12

You can use this, it's simple:

dataSet11.DataTable1.AddDataTable1Row(File.ReadAllBytes("C:\\File.ext"));
sqlDataAdapter1.Update(dataSet11.DataTable1);

Just u must using System.IO.
Dataset1.DataTable1 have 1 column, it's datatype is binary.
and File.ReadAllBytes("FilePath") raturn a byte[] datatype (equal binary).

Good Luck. Rose | [Rose]

laziale27-Aug-08 3:06

27-Aug-08 3:06

hi there! I have a question if anyone can help me. I have an app and two webBrowser controls, the first one is populated with html code, and the second one I am viewing a PDF file. There is a button on the form, and I want to know if I can like combine the data from both webBrowser controls and display them on a single PDF or image document. Thx ahead

leppie27-Aug-08 4:15

27-Aug-08 4:15

Probably not without generating your own PDF. There are many article here on CP and the rest of the internet on that specific subject.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

chaiguy133727-Aug-08 4:20

27-Aug-08 4:20

If you create the document by hand by merging the two existing documents I think you could, however I don't fully understand your question. Could you give an example?

“Time and space can be a bitch.”
–Gushie, Quantum Leap

{o,o}.oO( Looking for a great RSS reader? Try FeedBeast! )
|)””’) Built with home-grown CodeProject components!
-”-”-

laziale27-Aug-08 4:27

27-Aug-08 4:27

here is the example, I mean the real problem: I have two documents: xml file and pdf file. From the xml file, I am creating an html table populated with the requested informations at a webBrowser control within my app. The pdf file is a file what is related with the data in the xml file and is used just for previewing a document with some items from the catalogue. Right now the user can preview the html table at one webBrowser and preview the pdf document at another webBrowser control. I want to merge them and put them in one single pdf document, instead of using two webBrowsers and more button pressing for a same action. Is that possible? Thx for the cooperation

chaiguy133727-Aug-08 4:32

27-Aug-08 4:32

Although as leppie says, you won't be able to actually modify the PDF document unless you use a tool to do that, my thought was that you could still host the table and PDF document in the same web browser, by generating the code for the web page to include the table and the embedded PDF (on the same page). I don't know if this would look good or not, but it might allow you to get rid of the other web browser.

“Time and space can be a bitch.”
–Gushie, Quantum Leap

{o,o}.oO( Looking for a great RSS reader? Try FeedBeast! )
|)””’) Built with home-grown CodeProject components!
-”-”-

laziale27-Aug-08 4:35

27-Aug-08 4:35

can you give me some idea (example) how I can try to do that and see how it looks a like? Thx ahead

chaiguy133727-Aug-08 4:40

27-Aug-08 4:40

Well you mentioned you were generating the html for the one web browser manually, so I'll assume you know how to do that. All you need to do now is add an embedded pdf document to that page, and set its url to the pdf document you want to show. Any time either the table (xml) or the pdf document changes, you'll still have to update the web browser's generated html, but at least this way it'll all be in one place, as you want:

src ="path/to/myPdf.pdf"
width="100%">

“Time and space can be a bitch.”
–Gushie, Quantum Leap

{o,o}.oO( Looking for a great RSS reader? Try FeedBeast! )
|)””’) Built with home-grown CodeProject components!
-”-”-

laziale27-Aug-08 4:53

27-Aug-08 4:53

thx....this can help me with my issue, but I am done for today, I will continue working tomorrow. Thanks a lot and have a nice evening(day) Big Grin | :-D

bye

chaiguy133727-Aug-08 4:58