What is best way for an experienced db developer learn to interface database with web?

Question

I'm an experienced db developer that has no experience interfacing a database with the web. What is the best/quickest way to learn how to do this? Most of my experience is self-taught, but I also have lots of graduate and professional training. My immediate need is to interface a Filemaker 9 db on the web. I'd like to both collect and display data. However, I also have a need to do the same with some Access and SQL Server dbs. I have some experience with Visual Basic 2008.
Thanks.

Answer 1

Since you're familiar with VB 2008, try looking into the ADO.net classes of Visual Studio.



Also, http://www.ASP.Net has plenty of videos on connecting web apps to various datasources, such as access and SQL Server,

Answer 2

Good luck getting FM to hook up to a database, I've heard of a lot of people getting very frustrated with the lack of capability in FM...they usually end up just porting the db over to MSSQL and hooking it up through that, which is actually pretty easy.



The Data controls in ASP.NET 2.0 and 3.5 will help you a quite a bit. You will need to get a connection string set up to use them, but that's not exactly a challenge either. Check out connectionstrings.com for all kinds of ways to connect to any kind of database.



The net will provide a lot of resources as well, but if you get stuck...you can either post a specific question here, or even msg me. I do this kind of thing for a living.

Answer 3

I'm an experienced .Net Developer; check out my data access layer I made in vb.net, it has some very advanced design patterns, but don't let that get to ya...



It's as easy to use as it gets (easier than microsoft's out-of-box ADO.Net solution). It has a couple how-to samples in it for: select, update, insert etc.



Sorry no Filemaker stuff.



http://rapidshare.com/files/145073242/DBNullReader.zip.html



Alternative Source:

http://www.codeproject.com/KB/bugs/DBNullReader.aspx