PHP -> ASP. Few Questions

Linken

Linken

Linken

Associate
Joined
10 May 2007
Posts
541
Location
Kent
Hey guys,

Q1) I know quite a bit about PHP, but our new website at work is coded in ASP and I decided to learn a bit about it myself. I have downloaded Visual Web Developer 2008 as a friend recommended, but unlike PHP it seems to be tricky to connect to my MYSQL 5.0 Server.

I have connected to it and extracting data, but only from a bit of google'd code I can't do much with, (can't sort/page).

Does anyone know of a way to connect via the options in Visual Web Developer so I can get more functions?

Q2) I am trying to parse data from a XML File, again I have it set up fine with PHP but on VWD2008 it seems like there's no way to connect to a URL, only data XML Data from your local PC.
 
I used VWD2005 a a while ago.

You can actually page/sort data easily by using the drag and drop built in components - its a good place to start tbh as you can customise these components using built in menus.

Can't remember the exact names, but to connect you need to create a new 'SQLDataSource' and then follow the on screen steps basically. You then drag a new SQLDataSource to the page, drag a component to the page (say a dynamic table) and choose the data source created above (click on the white arrow to get this option).

I found a lot of the simple tasks can be done through the menus, which are very intuitive to use and can all be done through the drag and drop components.
 
You're right suarve, but (don't know how right I am), but does the free version allow creation of the datasets/sqldatasources? I didn't think it did?
 
~J~ said:
You're right suarve, but (don't know how right I am), but does the free version allow creation of the datasets/sqldatasources? I didn't think it did?
Click to expand...

Well I know the free version of the VWD2005 does definitely as that what I used. It's all pretty slick really, as its adding ajax search, sorting etc without any effort at all :)

Can't think of any reason other than MS being tight that they'd disable this in the free version of 2008 (so it's possible :) )
 
I presume you mean ASP.NET and not ASP Classic?

This page lists the most common MySQL connectors including a native .NET driver and a VS plugin.

There is no limitation on connecting to MySQL from the Express products, so if it isn't working you problem lies elsewhere.

Hope this helps..

Chris
 
Ahh no worries mate, I know there's a few things locked out of the free one, just thought this was one of them. O well, all the better then :)
 
You must log in or register to reply here.
Back
Top Bottom