SQL or MySQL?

[Michaelk]

Hi, i'm currenlty in the process of turning my current web page into an asp.net page using Visual Basic.NET. But i've got a few questions.
1. Someone offered to show me how to integrate a SQL database, my current web host offers mySQL, is this very differant? Would it be hard to change SQL code into mySQL?
2. What is reccomended to write an asp page. I have both Visual Studio.NET and Web Matrix.NET. I've done some programming in Visual Studio.NET and know my way around it. But what is best for a first time attempt at an asp page?

Thanks,

 

[Paszt]

ADO.NET is designed in such a way that the code is easily reusable for almost all types of dataBases. The only thing you should have to change would be the connectionString. There may be some slight differences in SQL statements, although I believe SQLServer and mySQL use the same syntax.

 

[Michaelk]

Great Thanks. Are there any online tutorials or examples that would be good for a first time asp attempt?

 

[levyuk]

You could try www.asp.net , there are some tutorials on there.

 

[Michaelk]

Ok will have a look.
Thanks.