Hello all... I know this is a question that has been asked thousands of times.... I appologize...

I have finally made up my mind that I am going to focus on asp.net vs php...

I gave up hope about 4 months ago on asp.net when I could not conquer this question... I am quite sure it has come a long way since then...

I am self taught, reading books etc etc... so I am looking for a through way that will show me how to connect to a mysql database using asp.net... this is a project I have decided I am going to learn today!

I have seen some examples on the net but it gets very confusing very quick...

would someone be kind enough to show me / tell me what I need to do...

here would be an example...

MySQl database = mydata
User Name = name
password = password
Table = customers
field = customer name

can someone tell me using asp.net how to connect to the database (Localhost use is fine - I have a dedicated server)

then display the customer name field?

this may be simple to some.. but if I can atleast get the connection started I can figure out the other 95% from there...

If I have read correctly MYSQL has released an OBDC connection that can be used now... or am I incorrect in this assumption?

Thanks in advance!!

Anjari