Introductions

I never did introduce myself. Well, I’m Philip Miseldine, and its a real pleasure to be blogging for SitePoint.

I’m currently starting a PhD at Liverpool John Moores University researching middleware and grid computing. And whilst it has rained almost continiously since I came to Liverpool, I haven’t got enough praise for the city or the University. OK, plug over :)

So what will I be posting on this blog? Well, one of the great benefits of blogging is that the blog writers save you time. I will bring you snippets and links to exciting .NET developments, articles, and reviews as well as providing my own personal take on some of the issues of the day.

Look out for tomorrows big post on hosting. Where can you get ASP.NET hosting? It’s one of the most common questions I get asked. How much will it cost? What are the pitfalls?

Until then, take it easy :)

Phil

Free book: Jump Start HTML5 Basics

Grab a free copy of one our latest ebooks! Packed with hints and tips on HTML5's most powerful new features.

  • http://www.sitepoint.com Mark Harbottle

    Welcome aboard Phil, we look forward to your insight into .NET It’s an area I don’t think we’ve covered enough on SitePoint.com

  • http://www.totalpda.co.uk dhtmlgod

    I second that.

    :)

  • pavan

    I need some information on how can i use “GROUP BY” as we do in SQL to a Dataset in Vb.Net

  • http://www.totalpda.co.uk dhtmlgod
  • http://www.miseldine.com miseldine

    I’d be happy to help if you could elaborate a little. GROUP BY is used when selecting multiple columns from a table (or tables) and at least one arithematic operator (aggregate function) appears in the SELECT statement.

    As such, the resulting dataset would be of no different format to that of any other 1 level SQL return.

    I’ll take an example of how to return a DataSet from a SQL query in VB.NET (using SQL Server):
    Dim cn As SqlConnection = New SqlConnection (connectionstring)
    Dim da As SqlDataAdapter
    Dim ds As DataSet = New DataSet
    Dim strsql As String

    strsql = “SELECT product, SUM(Sales)
    FROM sales_figures
    GROUP BY product”
    da = New SqlDataAdapter(strsql, cn)
    da.Fill(ds)

    —-

    The DataSet is now ready to query.

    Hope this helps,

    Phil

  • sbdi

    Just curious to where you studies your software engineering degree :)

  • http://www.miseldine.com miseldine

    I got my “BSc (Hons) Software Engineering 1st Class” from UCN (University College Northampton) after not enjoying Stirling University. My time at UCN was a really great… course was great, people were great. I learnt a lot about software design (formal specification, BON) and really I started to get interested in distributed computing which lead me to get to grips with .NET (which was just out of beta around the time my course started) and also I found I could write neural networks quite easily in C#…it’s clarity is good for that kind of coding.

    Anyway, so I wanted really to persue research in computing, and was offered a bursary at Liverpool John Moores, and the rest, well, is history :)

  • http://badice.com/ Hartmann

    Hey Phil! Thanks for taking the time to post this blog. I would really enjoy seeing some Web Service stuff as well as examples of .NET connecting to different databases.