Re: Email In C# - C# Discussion Boards

First Prev Next

Re: Excel Parseing

DarrenShultz9-Jul-09 5:18

DarrenShultz

9-Jul-09 5:18

You may also want to take a look at OleDbConnection.GetSchema (Google it to find the MSDN documentation link). This will allow you to directly obtain schema information for the Excel file. The schema is returned as a DataSet containing DataTables for a variety of entities. One of these DataTables will contain a list of table names (which are the Excel worksheet names you'll use in your queries). This will allow you to avoid using COM automation entirely (ie. Excel Object library) to obtain the list of Worksheets. The benefit: no dependency on Excel object library DLLs, registration, versioning, etc... all the headaches that come with COM automation.

Email In C#

kibromg7-Jul-09 5:41

kibromg

7-Jul-09 5:41

Hi all,

if someone forgets there password for login to a website, i would like to send them an email with there username and password by quering the database.

Can any one advice me on the C# code that is used for sending email to a user?

Thank you in advance.

Re: Email In C#

Christian Graus7-Jul-09 5:42

Christian Graus

7-Jul-09 5:42

If you search this site for an article called 'how to use google', you'll find that I both answer your question, and the underlying question that caused you to need to ask this.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Email In C#

kibromg7-Jul-09 5:57

kibromg

7-Jul-09 5:57

Hi Christain,

Thank you for your response.

Can you at least learn to be polite?

Any ways I have the Answer :

System.Net.NetworkCredential SMTPUserInfo = new System.Net.NetworkCredential(sSMTPUser, sSMTPPass);

SmtpClient emailClient = new SmtpClient("smtp.gmail.com",587);

The 587 works with some mail Client but not with others like Gmail, etc...

Re: Email In C#

Eddy Vluggen7-Jul-09 6:02

Eddy Vluggen

7-Jul-09 6:02

He is being polite, and you're being lazy. You can find out what port Google expects by Googling for "SMTP port gmail".

Good luck Smile | :)

I are troll Smile | :)

Re: Email In C#

EliottA7-Jul-09 7:00

EliottA

7-Jul-09 7:00

kibromg wrote:
Can you at least learn to be polite?

Watch your tone there, Christian Graus has been a member at codeproject for years, with over 50,000 posts and 30 articles, his Fixture/Legend status has been earned.

You are a firstly and obviously a beginner and new to programming, you're putting in NO effort to make your system functional other then expecting your work handed to you.

I'll be less polite then others, get the f*** off your ass and go learn to use Google, and if you can't find your answer there then guess what, it's time to find a different f***ing profession, one that is more suited to your (lack of) intelligence.

How's that for polite, buddy?

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: Email In C#

Luc Pattyn7-Jul-09 8:39

Luc Pattyn

7-Jul-09 8:39

EliottA wrote:
How's that for polite, buddy?

Not much, I'm afraid.

However it is pretty clear, except for some asterisks.
Do you really need 27 letters in your alphabet?

Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Email In C#

EliottA7-Jul-09 9:32

EliottA

7-Jul-09 9:32

I could have circumvented then filter, but I didn't feel it appropriate.

Those responses truly get to me, especially when geared towards people with high post/article counts who have contributed more then enough for others. I knew zilch about programming before I stumbled my butt onto this site, and learned from various tutorials and posts before I began to post myself.

So retorts like that, insulting from people from whom I've directly (or indirectly) learned off of comes as a direct insult to me.

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: Email In C#

Luc Pattyn7-Jul-09 12:06

Luc Pattyn

7-Jul-09 12:06

Yes, you and I both don't like what was said.

However, if I would want to call someone impolite, I would still try and do so in a polite way if such is possible at all.

Rose | [Rose]

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Email In C#

kibromg7-Jul-09 23:20

kibromg

7-Jul-09 23:20

Sorry Guys.Appologies

Transparent Pictureboxes

Jordanwb7-Jul-09 5:40

Jordanwb

7-Jul-09 5:40

I have a class called "Card" (as in a deck of cards), which extends the PictureBox class. Now the picturebox is the size of the image (150X215). When you mouse over the card it "hovers" (its Y location decreases 20 pixels) and is supposed to show part of the card underneath it. However this does not happen. See this picture: http://img199.imageshack.us/i/cardsj.jpg/[^]

I've done this in the OnLoad event of the Card class:

this.SetStyle(ControlStyles.SupportsTransparentBackColor, true);
this.BackColor = Color.Transparent;

But it doesn't work (as you can see in the picture). I found this article: http://www.codeproject.com/combobox/TransListBox.asp[^]

But how do I do this in C#?

BTW the images are transparent png's.

Re: Transparent Pictureboxes

Christian Graus7-Jul-09 5:43

Christian Graus

7-Jul-09 5:43

Using pictureboxes for this, is a little insane. Just draw your cards onto your form in your paint event.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Transparent Pictureboxes

Jordanwb7-Jul-09 5:49

Jordanwb

7-Jul-09 5:49

I've changed it from PictureBox to Panel and added this:

protected override void OnPaint(PaintEventArgs pe)
{
    base.OnPaint(pe);

    pe.Graphics.DrawImage(this.card_image, new Point(0, 0));
}

But it's still not transparent. Do you want to look at my code?

Re: Transparent Pictureboxes

Christian Graus7-Jul-09 5:52

Christian Graus

7-Jul-09 5:52

No, I want you to do what I suggested. DON'T put the images inside a control, draw them on your form directly, in your paint event.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Transparent Pictureboxes

Luc Pattyn7-Jul-09 8:41

Luc Pattyn

7-Jul-09 8:41

Christian Graus wrote:
Using pictureboxes ~~for this~~, is a little insane

ftfy

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

web automation

T_Teef7-Jul-09 5:11

T_Teef

7-Jul-09 5:11

hi i am working on an application that automates a website, my work is to upload a file but it is not clear to me how i can get the browse folder dialog box event(on clicking the browse button).

Re: web automation

DoctorMick7-Jul-09 5:33

DoctorMick

7-Jul-09 5:33

More clarity in your question would be helpful.

Read Outlook Message from msg file

sajan_f7-Jul-09 4:15

sajan_f

7-Jul-09 4:15

Kindly some one help me out how to find the Received time in mail & Sender mail address.
I had used OutlookStorage where sender mail & Received time property is not available.
kindly some one help me urgently

Urgent request

Not Active7-Jul-09 4:32

Not Active

7-Jul-09 4:32

sajan_f wrote:
help me urgently

This is very rude, it may be urgent to you but not to us.

only two letters away from being an asset

DataReader data writing to Excel sheet - cells in different row

Krishna Aditya7-Jul-09 3:13

Krishna Aditya

7-Jul-09 3:13

Hi Guys,

I am DataReader to get data from DB and dump the data into Excel sheet using XML's.
but,as the data reader holds the data for entire row, i am unable to get the data for other cells.

from datareader, i am getting <b>txt1, dt1, dt2 </b>in a single row, but i have to export this data to excel in multiple rows,
like

<pre>if (CurTaskNode.ReadFormat == "ColumnbyColumn")
                                                                  { for (int iCol = 0; iCol < lengthHeader; iCol++)
                                                                        {

                                                                              // Checking whether the Header data exists or not
                                                                              if (CurTaskNode.HeaderData[minCol] != "")
                                                                              {
                                                                                    //if (!(excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol]).Locked)
                                                                                    //{

                                                                                    // Assigning the Value from readerto   to the particular cell in excel sheet

                                                                                                excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol] = values[iValueIndex];
                                                                                                iValueIndex++;

                                                                                    //}

                                                                              }
                                                                              minCol++;
                                                                        }
                                                                        minRow++;
                                                                  }
</pre>

so, xml has 2 tasks namely projdata, projduration, so for the first task it should take the data and put in excel cell( 1,1 ) and in second task it should place it excel (10,2) and (10, 3)

<   <Reference>
                  <SheetName>Setup_View</SheetName>
                  <TaskName>SubProjectName</TaskName>
                  <TaskName>ProjectDuration</TaskName>
            </Reference> >

pleasee help me in modifying the code??
Thanks Ramm

Serial Data

Tauseef A7-Jul-09 2:39

Tauseef A

7-Jul-09 2:39

hi guys

i want to read from a simulator (an clinical test device) which
is sending data on serial port , but i cant get correct data it shows junk characters ,
application works fine , simulator also shows correct output if connected with DockLight ,
any idea ?

thanks

regards ,

Tauseef A Khan
MCP Dotnet framework 2.0.

Re: Serial Data

musefan7-Jul-09 2:43

musefan

7-Jul-09 2:43

So you are saying that you can succesfully connect to the device and receive its data?

If so, what is your reason to think the data is not correct?

Life goes very fast. Tomorrow, today is already yesterday.

Re: Serial Data

Dave Kreskowiak7-Jul-09 3:47

Dave Kreskowiak

7-Jul-09 3:47

If you're getting junk characters when you're supposed to be getting nice looking text, you've most likely got the communication parameters wrong, like baud rate, stop bits, data bits, parity, handshaking, yada, yada, yada, ...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Oracle commit

swpr7-Jul-09 2:24

swpr

7-Jul-09 2:24

Hello,
I need to make some few update statements in my C# code (ORACLE database). The problem is that I can't keep it as stored procedure (statement must be in C# code).

My question is: do I have to commit this statement somehow ? In stored procedure there wouldn't be any problem but I'm not sure what to do with SQL statement in C# code

regards,
S.W.

Re: Oracle commit

Christian Graus7-Jul-09 2:27

Christian Graus

7-Jul-09 2:27

No, you just execute the SQL, and it will execute normally.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Last Visit: 31-Dec-99 18:00 Last Update: 27-Apr-24 20:53

Refresh

ᐊ Prev 1...4755 4756 4757 475847594760 4761 4762 4763 4764 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.