How to connect database using asp.net

Hello Experst

I am new in asp.net. Please tell me how can i connect Mysql and MS Access using Asp.net and How to insert and retrieve data from a table . Please help me I shall be thank full to you

 

In order to connect to MS ACCESS, you can use OledbConnection and OledbCommand classes. You can get the connection string at connectionstrings.com

In order to connect to MYSQL, you must have MYSQL driver for asp.net installed. You can download MYSQL Connector Net 5.0 from mysql.com website. Then use MySQLConnection and MySQLCommand classes in MySQL.Data.MySqlClient namespace.

 

or to make it simpler, just search for it and copy-paste

 

I have search alot the code for MS Access connection is available but th code to connect My Sql is not working Please give me working code I shall be thank full

 

You may want to check this Using mySQl in ASP.NET

 

Why don't you use sqlDataSource.. go with that and it will do everything

 

You can use OleDbConnection for MySql connectivity .

 

Here is the help as to how to use mysql with asp.net. It is using the mysql client.

http://ask4asp.net/post/using-mysql...anding-database-operations-mysql-asp_net.aspx