Connection string for mysql database and how to write stored procedure in mysql database and use it

Question

To write a stored procedure for login page in MySql database and use that in windows login form.

GAUTAM RAPARTHI · Answer

Hi Rohatash, here you have provided the solution for doing it in SQL server. But i want the solution to be done in MySql Database. When i am trying to execute the procedue in MySql ,its getting error.So,please provide the solution of how to do it by using MySql database as soon as possible.

Rohatash Kumar · Answer

creating a table in SQL server database which has the username, password and email fields. Table looks like this. create table registrationtab ( Username varchar ( 100 ), Email varchar ( 100 ), Password varchar ( 20 ) ) Step-2 Create stored procedure Now Creating stored procedure for login. That means values will be match in table using stored procedure. Stored procedure looks like that for it. create PROCEDURE CheckUser ( @username as varchar ( 50 ), @password as varchar ( 50 ) ) AS SELECT * FROM registrationtab WHERE username = @username AND password = @password Now creating a window form with the username and password field which are defined in the table. And write following code in login button event. Dim strcon As String = "Data Source=.;uid=sa;pwd=Password$2;database=master" Dim con As New SqlConnection (strcon) Dim com As New SqlCommand ( "CheckUser" , con) com.CommandType = CommandType .StoredProcedure Dim p1 As New SqlParameter ( "username" , TextBoxusername.Text) Dim p2 As New SqlParameter ( "password" , TextBoxpassword.Text) com.Parameters.Add(p1) com.Parameters.Add(p2) con.Open() Dim rd As SqlDataReader = com.ExecuteReader() If rd.HasRows Then rd.Read() Labelinfo.Text = "Login successful." Else Labelinfo.Text = "Invalid username or password." End If

Connection string for mysql database and how to write stored procedure in mysql database and use it

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)