Rod Stephens started out as a mathematician, but while studying at MIT, he discovered how much fun algorithms are. He took every algorithms course MIT offered and has been writing complex algorithms ever since.

During his career, Rod has worked on an eclectic assortment of applications in such fields as telephone switching, billing, repair dispatching, tax processing, wastewater treatment, concert ticket sales, cartography, and training for professional football players.

Rod has been a Microsoft Visual Basic Most Valuable Professional (MVP) for more than 10 years, and has taught introductory programming at ITT Technical Institute. He has written more than 2 dozen books that have been translated into languages from all over the world. He has also written more than 250 magazine articles covering C#, Visual Basic, Visual Basic for Applications, Delphi, and Java.

Rod’s popular VB Helper web site receives several million hits per month and contains tips, tricks, and example programs for Visual Basic programmers. His C# Helper web site (www.csharphelper.com) contains similar material for C# programmers.

You can contact Rod at RodStephens@CSharpHelper.com.

hello ;

i have a question about an article but i can’t contact you using contact us because i can’t install the Really Simple CAPTCHA plugin, how can i contact you.

Regards

You can leave a message here or on a post, or email user name RodStephens at this web site.

You have often shown algorithms for various tree structures and graphs. I’ve studied shortest path or maximum flow algorithms years ago. How do mapping or routing programs like Microsoft Mappoint or Garmin auto GPS store their data and calculate a route?

Hold on… I just found your answer in your http://www.devx.com/dotnet/Article/38666 article. Thanks,

I don’t know exactly which data structures and algorithms those sites and others use, but that article describes some of the more likely choices.

They may also store pre-computed paths for at least some of the data, for example between major street and highway intersections. Or they may favor highways for longer paths. Then you can calculate a path from the start point to the nearest stored intersections, follow a pre-calcuated path to the stored intersections nearest to the destination, and finish by calculating a path from those to the destination. That can save a lot of time for really long paths like from Los Angeles to New York.

There are lots of tweaks and modifications they might use.

Pre-computed paths could save a lot of effort. Thanks,

hello. I am writing from turkey. I wrote using google translation.

I want to save RichTextBox or TextBox using SQL to mathematical equations. Is something like this possible?

Do you mean you want to write equations in a RichTextBox or TextBox and save the equation in SQL?

If you can create the equation using Unicode, then you may be able to do that. A RichTextBox is a lot more powerful so it would be a better bet. For example, it can display subscripts and superscripts. You can probably also times, divide, square root, and other symbols in Unicode.

But I don’t think you can do things like roots that actually go over the terms inside them. I also don’t think you can do vertical fractions, integrals, matrices, etc. So unless you can use very simple equations, no you can’t do this.

Usually when I need an equation, I build it in Word, take a screen shot, and then save it as an image.

Hello

I am Mohammed

Hello

I just bought C# 24-Hour Trainer, 2nd Edition. I tried to go to book web page videos http://www.wrox.com/go/csharp24hourtrainer2evdeos

I get the message the :

You Encountered the Following Error:

Page Not Found

/WileyCDA/redirect/go/csharp24hourtrainer2evdeos

If you are looking for a specific product, you can go to the homepage and enter the information in the Search Titles box or begin browsing.

Please contact our webmaster if you need more assistance.

Could you please send the correct video link

Regards

I just tried this URL and it worked:

http://www.wrox.com/WileyCDA/Section/id-826633.html

http://www.wrox.com/WileyCDA/Section/id-826633.html

I think it must just have been a temporary error. Give it another try.

Hello ;

I have (value1, value2) as a result of a program on visual studio and I want to export these results to create a graphic in Excel, i have an exception and i cannot resolve it. This is my code

private void InsertValuesIntoExcel(int note1, int note2)

{

string fileName = @”D:\test.xlsx”;

string connectionString = String.Format(@”Provider=Microsoft.ACE.OLEDB.12.0;” +

“Data Source={0};Extended Properties=’Excel 12.0;HDR=YES;IMEX=0′”, fileName);

using (OleDbConnection cn = new OleDbConnection(connectionString))

{

cn.Open();

if (first)

{

OleDbCommand cmd0 = new OleDbCommand(@”CREATE TABLE [RawData] ” +

“([NOTEA] int, ” + “[NOTEB] int)”, cn);

cmd0.ExecuteNonQuery();

first = false;

}

OleDbCommand cmd1 = new OleDbCommand(“INSERT INTO [RawData$] ” +

“([NOTEA],[NOTEB]) ” +

“VALUES(@value1,@value2)”, cn);

cmd1.Parameters.AddWithValue(“@value1”, note1);

cmd1.Parameters.AddWithValue(“@value2”, note2);

//cmd1.Parameters.Add(“@value1”, OleDbType.Integer).Value = note2;

//cmd1.Parameters.Add(“@value2”, OleDbType.Integer).Value = note1;

cmd1.ExecuteNonQuery();

}

i have excel 2007, and i use .Net Framework 4 and i have this exception

The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

Hi, Rod. I have a question about ellipse intersection.

In these 2 articles i think

http://csharphelper.com/blog/2014/11/calculate-the-formula-for-an-ellipse-selected-by-the-user-in-c/

http://csharphelper.com/blog/2014/11/see-where-two-ellipses-intersect-in-c-part-2/

you write conic section equation not properly. I explaint.

in first article you wrote formula: Ax^2 + By^2 + Cxy, but

in the next article you wrote A1x^2 + B1xy + C1y^2. Why so? Is it mistake ore not?

And please explain i’ve tried to substitute these vars A = 1/Rx^2, B=1/Ry2, C=0, and so on in main formula from this article(http://csharphelper.com/blog/2014/11/see-where-two-ellipses-intersect-in-c-part-2/). But I think i’ve got bad results, because my B variable is zero.

The most general form of a conic section is:

Ax

^{2}+ Bxy + Cy^{2}+ Dx + Ey + F = 0Depending on the value of B

^{2}– 4AC you get an ellipse, circle, parabola, hyperbola, or some degenerate form such as a point or two lines. For example, see math2.org.The first example works with ellipses that have axes parallel to the X and Y axes. in those cases B is 0. If the ellipse is rotated, then B is not 0.

Your result might be correct when B is 0 if the ellipses are parallel to the axes.

Hi Rod,

I’m about to start my C# journey having been a VBA programmer for many years. Looking for web resources I stumbled across csharphelper.com.

Wow, what a gold-mine! Just wanted to say thanks for making this available. I think I’m going to be a regular visitor and appreciative fan.

Hi Nick. I hope you find the site useful. Be sure to tell your friends and coworkers. (The ones who might care 😉

You might want to start off with a book. You can certainly learn everything from the Internet, but a book can make things simpler. If you’ve worked with VBA a lot, then you should probably steer away from the “Idiot’s” and “Dummies” books. They’d be too easy.

Good luck!

Rod,

What is the license for the code you post on your blog? Is there a proper way to use one of your algorithms in free (GNU LGPL) software?

You can use the code you find on this site or in my books. I request but don’t require an acknowledgement. I also recommend (but again don’t require) that you put the URL where you found the code in a comment inside your code in case you need to look it up later.

So really no restrictions.