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