C# Discussion Boards - CodeProject

7-Jul-09 8:27

Hi,

when you are accumulating numeric values, you have to take care of the order you apply; the right order could be:
- small to large if you don't expect values to cancel out (say you have to add a million times 1 and one billion; doing the ones first will yield one million, which is visible when added to one billion. The other way around each individual one would be lost against the billion.
- large to small if you have large values that cancel each other out.

As you can see, it isn't straightforward. There is a difference between computer hardware+software and algebraic equations.

Smile | :)

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.

Excel Parseing

guchu7-Jul-09 7:26

guchu

7-Jul-09 7:26

Excel.Application ExcelApp = new Excel.ApplicationClass();
ExcelApp.Visible = false;
String WorkbookPath = filename;
Excel.Workbook ExcelWorkbook = ExcelApp.Workbooks.Open(WorkbookPath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
Excel.Worksheet Sheet = (Excel.Worksheet)ExcelWorkbook.Sheets[1];
DataTable newTable = new DataTable();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties= Excel 8.0";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [" + Sheet + "$]", conn);
cmd.CommandType = CommandType.Text;
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(newTable);
dataGridView1.DataSource = newTable;

I am using this code to read an excel file and save the data in a datatable ....
I am getting this error "System.__ComObject$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long." and the error pointer comes on the second last line of the code ... can neone help

Re: Excel Parseing

DarrenShultz7-Jul-09 8:21

DarrenShultz

7-Jul-09 8:21

You are building your SQL string by concatenating the object Sheet. This object is of type Excel.Worksheet - which is not a string. Thus, as with all objects, it is calling it's ToString() method to obtain a string value it can concatenate with the rest of the SQL string. Since Excel.Worksheet is a COM Object, it's ToString is returning "System.__ComObject". You'll need to obtain the actual text name of the worksheet and use that to build the SQL string.

Re: Excel Parseing

guchu8-Jul-09 22:17

guchu

8-Jul-09 22:17

Thankyou very much ... the answer was not only precise but was very well explained Smile | :)

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.

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.

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...

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 | :)

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![^]

Luc Pattyn7-Jul-09 8:39

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.

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![^]

Luc Pattyn7-Jul-09 12:06

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.

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.

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.

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?

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.

Luc Pattyn7-Jul-09 8:41