Question

Membership login with mysql

ASP.NET, MySQL, C

hi, i doing a login program which will be using mysql. I would like to how do i do that, I have done a little but i am stuck half way can anyone help?
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
MySqlConnection conDatabase = new MySqlConnection("Server=localhost;Persist Security Info=no;User ID=Administrator");
MySqlConnection cnnVideos = new MySqlConnection("Network Address=localhost;" +
"Initial Catalog='login';" +
"Persist Security Info=no;" +
"User Name='root';" +
"Password=''");

}

Create a stored procedure in the MySQL database (if you have a version which supports procedures) which has input parameters for the username and password. Pass it the username and password and within the procedure have it check a table and see if the username and password exist in a single row. Something like this.

CREATE PROCEDURE MyProcedure
     @UserName nvarchar(50),
     @Password nvarchar(50)
 AS
 SELECT 1
 FROM YourTable
 WHERE UserName = @UserName
    and Password = @Password
 GO

Then if there is no record it's not a valid account. If there is a record it is a valid account.

This page has come good info about using stored procedures.