SELECT q.cust_no, earliest_date, item FROM tbl_order as t INNER JOIN ( SELECT cust_no, MIN(date) as earliest_date FROM tbl_order GROUP BY cust_no ) AS q ON t.cust_no = q.cust_no AND t.date = q.earliest_date Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

Stefan R wrote: I'm pretty fluent in VB syntax so i don't mind Yeah, I changed the code becauseif you're caught posting VB code in the C# Forum, ... well, let's just say it makes the movie "Desparado" look like a Sunday Brunch. :-D RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

It can't be explained better than this :). daniero

This is the syntax of the data binding expression, you normally place an expression using the DataBinder.Eval method in there, the expression can be a call to a method defined in code-behind. The result of the expression is bound to the specified property of the element/control, and this binding only happens when you call the DataBind method of either the Page instance or the data-bound control like datagrid, datalist, repeater ....For more information, you can see the documentation in MSDN: Data Binding Expression Syntax[^] ASP.NET Syntax[^] Stefan R wrote: About that java-thing, let's just say that Mr Gates and his cronies know how to make things easier (I'm a veteran, diet-version, at Java). No way I'm going back now. But you'll probably hear from me again - I'm learning by trial and error and a great deal asking/searching/doing Just remind you that CP is your best friend :-D

You may find the solution from the article Process and request identity in ASP.NET[^]

I think you are. In this expression, the numbers 3 and 2 are integers. If you integer divide 3 by 2 you get 1. This 1 is converted to a float implicitly because no data is lost, but it's not the value you are looking for. Try: float number = 3.0 / 2.0; Regards, Rob Philpott.

I had also similar situation. What i did was explicitly declaring the type that it number is casting to. Ex: decimal _test = 6 / 4 - will return 1 However decimal _test = (decimal)6 / (decimal)4 will return 1.5

In DataList Set properties datalist.RepeatColoums = number of coloums; datalist.RepeatDirection = RepeatDirection.Horizontal;