| Author: Anil Kumar Pandey 24 Jun 2009 | Member Level: Diamond | Rating:  Points: 1 |
hi,
the connection with my sql is same as the SQL server connection..
you just need to specify the provider in the connection string... and the credentials for that.
Thanks & Regards
Anil Kumar Pandey
|
| Author: Viji RAJKUMAR 24 Jun 2009 | Member Level: Diamond | Rating: Points: 1 |
Hi,
Yes you can connect.
You should know the connection string to be used.
Check the link
https://support.quadrahosting.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=22
http://www.aspdev.org/sql/asp.net-mysql-connect/
Regards
VIJI RAJKUMAR
Pls rate my Answer if it was supportive
http://vijirajkumar.blogspot.com
|
| Author: Miss Meetu Choudhary 24 Jun 2009 | Member Level: Diamond | Rating: Points: 2 |
yes sure you can connect the MySQL database to ASP.Net...
follow the following steps...
1. get the mysqlconnector from :http://dev.mysql.com/downloads/connector/
for dotnet connector you can directly visit: http://dev.mysql.com/downloads/connector/net/6.0.html
2. After installing the connector. Add a reference to the MySql.Data.dll
3. Then use the namespace using MySql.Data.MySqlClient;
4. Now you can explore the
MySqlConnection
E.g.
MySqlConnection con = new MySqlConnection(constr);
MySqlCommand
E.g.
MySqlCommand cmd = new MySqlCommand("SELECT * FROM client_products WHERE client_id =" + Session["userid"].ToString(), con);
MySqlDataReader
E.g.
MySqlDataReader dr = cmd.ExecuteReader();
Rest The method is almost Same as SQLClient except the objects are of the MySQL
Thanks and Regards
Miss Meetu Choudhary (Site Coordinator)
Go Green Save Green
My Profile on Google
|
| Author: ramakrishna 24 Jun 2009 | Member Level: Bronze | Rating: Points: -20 |
It is similar to SQL connection only ,but u have to use MYSql DLL.
Then use the namespace using MySql.Data.MySqlClient;
4. Now you can explore the
MySqlConnection
E.g.
MySqlConnection con = new MySqlConnection(constr);
MySqlCommand
E.g.
MySqlCommand cmd = new MySqlCommand("SELECT * FROM client_products WHERE client_id =" + Session["userid"].ToString(), con);
MySqlDataReader
E.g.
MySqlDataReader dr = cmd.ExecuteReader();
Ramakrishna
|
| Author: Miss Meetu Choudhary 24 Jun 2009 | Member Level: Diamond | Rating: Points: 3 |
I marked the above post of Mr. Ramakrishna as copy right violation because he has copied my answer and posted the screen is attached
Thanks and Regards
Miss Meetu Choudhary (Site Coordinator)
Go Green Save Green
My Profile on Google
 |