Connect Database

Question

hi how to connect the my sql in asp.net

Deepak Sharma · Answer

Just pass following as the connection string : string conString="server=localhost;user id=root;Password=deepak00;database=nrega2"; MySqlConnection con=new MySqlConnection(conString);

Satyapriya Nayak · Answer

Hi Rama, Try this... Ex:- Login form ' Import the ODBC namespace for MySQL Connection Imports System.Data.Odbc Partial Class login Inherits System.Web.UI.Page Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate Dim cn As New OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=mydb; User=root;Password=;") cn.Open() Dim cmd As New OdbcCommand("Select * from login where username=? and password=?", cn) 'Add parameters to get the username and password cmd.Parameters.Add("@username", OdbcType.VarChar) cmd.Parameters("@username").Value = Me.Login1.UserName cmd.Parameters.Add("@password", OdbcType.VarChar) cmd.Parameters("@password").Value = Me.Login1.Password Dim dr As OdbcDataReader ' Initialise a reader to read the rows from the login table. ' If row exists, the login is successful dr = cmd.ExecuteReader If dr.HasRows Then e.Authenticated = True ' Event Authenticate is true End If End Sub End Class Refer the below link for more http://dotnet.tekyt.info/?p=31 http://www.codeguru.com/csharp/.net/net_data/article.php/c19493 Thanks

Mayur Gujrathi · Answer

This site is not to say Hi/Bye or any thing else

Prakash Selladurai · Answer

hai ram