How to send .xlsx file as an email attachment in C#? - C# Discussion Boards

Re: Use of DCB structure in C#

30-Sep-15 3:21

Thanks for that link. The problem is SerialPort doesn't give you freedom to set all the parameters. And I have C++ implementation of serial communication which uses DCB structure SetCommState function and SetTimeOut functions. So I can pass that DCB structure which you linked directly to the SetCommState as in here: http://forums.codeguru.com/showthread.php?182234-serial-ports-C[^]?

Basically my option is to use either this approach: http://forums.codeguru.com/showthread.php?182234-serial-ports-C[^]?
Or try with SerialPort and if it doesn't work, try with former option

Richard Deeming30-Sep-15 4:13

Richard Deeming

30-Sep-15 4:13

Yes, you should be able to replace the DCB structure from that thread with the version from the pinvoke.net site.

P/Invoke doesn't care about methods, properties or events on a structure. It only cares about the raw bytes passed across. So long as the fields you're using produce the right bytes to send to the unmanaged method, it will work.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Use of DCB structure in C#

Member 1206160030-Sep-15 4:17

How to send .xlsx file as an email attachment in C#?

30-Sep-15 4:17

First I will try I guess with SerialPort methods. If some issue occurs, then I think I will revert to that PInvoke approach in that thread

Hi Please help me

NewbieProgs29-Sep-15 15:55

NewbieProgs

29-Sep-15 15:55

Hi is there anyone who can give me a link where can i download working remote desktop view using c# together with the source code

PS: remote desktop viewer using local area network

Re: Hi Please help me

OriginalGriff29-Sep-15 20:35

OriginalGriff

29-Sep-15 20:35

That isn't what we are here for: we are not a Google search assistant, and we don't provide full systems on demand.

Start with Google, and see where you get.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: Hi Please help me

aarif moh shaikh1-Oct-15 1:02

aarif moh shaikh

1-Oct-15 1:02

Do google for it Smile | :)

Member 1162226629-Sep-15 3:50

Re: How to send .xlsx file as an email attachment in C#?

29-Sep-15 3:50

Hi,

I am trying to send a *.xlsx file as an email attachment in #c for that we write the below code

Attachment item = new Attachment(fileName.xslx,MediaTypeNames.Application.Octet);
item.TransferEncoding = System.Net.Mime.TransferEncoding.QuotedPrintable;
mail.Attachments.Add(item);
mail.IsBodyHtml =true;
mail.BodyEncoding =Encoding.UTF7;
mail.HeadersEncoding =Encoding.UTF7;

stmp.Send(mail);

By doing this in some machines we are able to send the mail successfully,but in some machines we are not able to send and also from those machines we are getting a mail with junk characters as body of the mail.

Please help us if anybody knows anything related to this(we are suspecting it might be machine settings problem,but we dont know what settings we need to change)

Chris Quinn29-Sep-15 4:15

Chris Quinn

29-Sep-15 4:15

Don't create a duplicate thread - update your first one

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Re: How to send .xlsx file as an email attachment in C#?

ZurdoDev29-Sep-15 4:21

Re: How to send .xlsx file as an email attachment in C#?

29-Sep-15 4:21

Why are you using UTF7? That's probably the issue. You should be using UTF8.

There are only 10 types of people in the world, those who understand binary and those who don't.

Member 1162226629-Sep-15 6:19

Set Time outs on Serial Port

29-Sep-15 6:19

Hi We tried with UTF8 also that is also not working,but strangely as mentioned above even with UTF7 it is working on some machines

Member 1206160029-Sep-15 3:09

29-Sep-15 3:09

I have this C++ code for setting timeouts on serial port

C++

COMMTIMEOUTS *timeouts = new COMMTIMEOUTS ;
memset(timeouts, 0, sizeof(COMMTIMEOUTS)) ;
timeouts->ReadIntervalTimeout          = ReadIntervalTimeout ;
timeouts->ReadTotalTimeoutMultiplier   = 5 ;
timeouts->ReadTotalTimeoutConstant     = readTimeOut ; //...
timeouts->WriteTotalTimeoutConstant    = 0 ; //
timeouts->WriteTotalTimeoutMultiplier  = 2*BaudRate/8 ;
const bool ret = SetCommTimeouts(*hDev, timeouts) != FALSE ;
delete timeouts ;
m_currentTimeOut = readTimeOut ;

I need to rewrite this in C#. For SerialPort class I found these properties:

C++

_serialPort.ReadTimeout = 500;
_serialPort.WriteTimeout = 500;

Are they equivalent? It seems there are more parameters in play in the C++ code. How can I approach this? Or maybe other parameters are not needed? What is the best way to transform that C++ code to C#?

ZurdoDev29-Sep-15 4:23

29-Sep-15 4:23

Yes, I believe you are correct. See https://msdn.microsoft.com/en-us/library/system.io.ports.serialport(v=vs.110).aspx[^] for the SerialPort class. And yes, C# will be easier than C++, that is intentional.

There are only 10 types of people in the world, those who understand binary and those who don't.

Member 1206160029-Sep-15 4:25

29-Sep-15 4:25

Not really, see on C++ there are more parameters about time out whereas on C# there is only 2. So it means I can't do exact mapping...?

ZurdoDev29-Sep-15 4:47

29-Sep-15 4:47

user20044 wrote:
whereas on C# there is only 2.

Yes exactly, C# is a much easier language than C++ and is a high level language; whereas, C++ is a low-level language. C++ will likely always give equal to or greater control to the developer.

There are only 10 types of people in the world, those who understand binary and those who don't.

Member 1206160029-Sep-15 4:59

29-Sep-15 4:59

I think we don't understand each other. Please see here: http://stackoverflow.com/questions/32844940/rewrite-serial-communication-on-c-sharp[^], I asked similar question. My problem is I have C++ code which establishes serial communication and I need to rewrite this to C#.
Which approach should I take? If I take SerialPort, it seems I can't duplicate and tune all the parameters which C++ structures allow like DCB.
Should I take Pinvoke way (http://forums.codeguru.com/showthread.php?182234-serial-ports-C[^]) instead - and make 100% duplicate? Is that necessary?

ZurdoDev29-Sep-15 5:07

29-Sep-15 5:07

user20044 wrote:
and I need to rewrite this to C#.

Yes, I understand that. And I'm telling you that C# does not expose all the same features that you can access in C++. So, either do it in C++ with the code you have or write it in C# and let the OS handle some of those properties for you that C++ does allow you to set.

There are only 10 types of people in the world, those who understand binary and those who don't.

Member 1206160029-Sep-15 5:54

29-Sep-15 5:54

In C# you mean to write it using SerialPort class and see if it works?

And if not, then try Pinvoke calls and duplicate the C++ code? (as in here for example? http://forums.codeguru.com/showthread.php?182234-serial-ports-C[^])

ZurdoDev29-Sep-15 5:55

29-Sep-15 5:55

It all depends on what you are doing and what environment it is. If this is a windows application also written in C#, then yes, use the C#.

There are only 10 types of people in the world, those who understand binary and those who don't.

Member 1206160029-Sep-15 6:25

how send *.xlsx file as an attachment?

29-Sep-15 6:25

Original application is written in C++ (see for more code on the other question I linked above), and I need to rewrite to C#

Member 1162226629-Sep-15 1:33

Re: how send *.xlsx file as an attachment?

29-Sep-15 1:33

Hi

I am new to C#, I wrote a code to prepare a *.xlsx file now I need to attach that file as an email attachment and send, but by doing that Thae mail body contains some junk data and also it is not giving any exceptions to catch.

Please help

Dave Kreskowiak29-Sep-15 1:50

Dave Kreskowiak

29-Sep-15 1:50

Help with what? You haven't shown us the code that builds the email message so it's pretty much impossible to tell you what you did wrong.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: how send *.xlsx file as an attachment?

Richard Deeming29-Sep-15 2:20

Richard Deeming

29-Sep-15 2:20

You could have found the answer yourself if you'd done any research at all! D'Oh! | :doh:

How do I send an email with attachments?[^]
How do I create an attachment from a stream?[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Message Closed

29-Sep-15 2:49