ASP.net with MYSQL

[w209]

HEllo friends i would be glad if u help me wih this problem can u tell me the proper way to connect ASP.net with MYSQL if possible tell me what is the procedure to connect it. nad what is required to connect to it. :)

[Piyush Vardhan Singh]

u Wana database connection code of ASp.net with my ssql

Piyush Vardhan Singh p_vardhan14@rediffmail.com

[Piyush Vardhan Singh]

first u Imports Data.SqlClient Imports System.Data.SqlClient Then u Define the connection variable '' Connection string Private ConnString As String = "server="192.168.8.40";Database="DatabaseName";uid="SQLLoginName";pwd="pASSWORD";" define CONNECTION VARIABLE Private _SqlConnection As SqlConnection inslz connection variable _SqlConnection = New SqlConnection(ConnString) ofter that u use this connection

Piyush Vardhan Singh p_vardhan14@rediffmail.com

[Michael Sync]

He said "MySQL" not "My SQL".. MySQL is the world's most popular open source database[^] :)

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)

[Michael Sync]

Hello, Please check-out this article Using MySQL in ASP.Net[^] more[^]

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)

[N a v a n e e t h]

You can use ODBC[^] or MySQLConnector[^]. ODBC adds an extra layer to the communication which makes your communication slow. So you can use MySQLConnector, which is very efficient. Download the connector from MySQL website. Also when you connect MySQL with ODBC, you will end up with a connection pooling issue which is a known bug for MySQL.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

[w209]

hey thanx but i want to know how do i configure My Sql with asp.net do let me know please my email id is --->sumitpcool@yahoo.co.in plz do inform me :)