Comments by shiny13 (Top 26 by date)

I have found the solution to Oracle, the equivalent to Top is Rownum. For MySQL its limit... Thanks for suggesting Top though.

Well if you said that in the beginning you would have had a whole of different answers and suggestions!

That's ok no need to join, the table Employee has these columns: Id, Name and Salary. You can just perform this operation there.

Thanks! Is this only for SQL Server? Or will this sql also run in MySQL and Oracle? Is there any chance to solve this with aggregate functions like Max(Salary) ?

yepp definitely. Focus on the theoretical parts 1st. Here in C# the exception handling is almost the same as C++ but slightly different, then generics in C# is different from Templates n C++ but same concept. So easier to test it out, debug and see output on the console project.

Follow a book or video tutorial series and practice on console. Then slowly proceed to ASP.NET MVC, win forms, WPF, windows mmobile etc. or anything else you want.

There's something definitely wrong in your looping logic. Why do you have 2 nested loops? Explain what the loops are for.

Well you can do all that then in an if statement. I understand our logic but I wonder why would you need to do this.

no problem!

This is plagiarism, blatantly copied from http://stackoverflow.com/questions/1913098/what-is-the-difference-between-an-interface-and-abstract-class and claiming to be his own words and code.

Oh not mate, its not free you have to pay. But Viblend has some free controls, go here: http://www.viblend.com/products/net/windows-forms/controls/free-winforms-controls.aspx

what type of question is this? :S I don't understand the question

in this case you can take the DataTable MyTable and count the rows maybe to see how many rows it has like this:
int count = MyTable.Rows.Count();

Or maybe to be extra sure try a for each loop and loop through the items and increment the count:
int count = 0;
foreach(var item in MyTable)
{
count++;
}

Initialize the variables ContinueTime and PauseTime as DateTime. Everytime you subtract two DateTime variables the out is generated in TimeStamp, so you can initialize PauseDuration as Timestamp. A TimeStamp variable can be converted to string if you want to display it. By default it is in this format: "hh:mm:ss:nn" where hh is hour, mm is minute, ss is second and nn is nano second or microsecond (not exactly sure but could be either).

Glad I could help :)

Thanks :D

no problem :)

ok then maybe try using color like this:
string hexValue = "#000000"; // You do need the hash
Color colour = System.Drawing.ColorTranslator.FromHtml(hexValue); // Yippee

You didn't specify so I thought maybe its for winform. Include System.Drawing.Color namespace at the top and you will get some colors.

well a column means that it will be be NEXT to the amount column, so you have to add another column. But I think according to your example in the question you are looking for a Row in the end that is the sum of all rows. So after the loop ends add make a DataGridViewRow object and then add the amount value then in the existing dataGridView just add your row!

Okay your code might work, try it out. Tell me if it returns any new error.