Downloaded and installed the MySQL Connector/Net from the MySQL official website :

Download Connector/Net

Open Visual Studio and click on the new project and give the project a name; it will open the new project, then click on the solution explorer (F4); right-click on "Reference" to add a new reference into the project. Add a reference for those two .dll files to the project (MySql.dll (Win apps), MySql.web.dll (Web apps)).

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Mysql_login_page._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head id="Head1" runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:Label ID="lb1" runat="server" Font-Bold="True" ForeColor="#FF3300"></asp:Label><br />

<asp:Label ID="Label2" runat="server" Text="Name" Font-Bold="True"

Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"></asp:Label>

<asp:TextBox ID="TextBox_user_name" runat="server" ForeColor="#993300" Width="100px"></asp:TextBox><br />

<asp:Label ID="Label3" runat="server" Text="Password" Font-Bold="True"

Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"></asp:Label>

<asp:TextBox ID="TextBox_password" runat="server" ForeColor="#CC6600"

TextMode="Password" Width="100px"></asp:TextBox><br />

<asp:Button ID="btn_login" runat="server" Text="Login" Font-Bold="True"

BackColor="#CCFF99" onclick="btn_login_Click" /><br />

</div>

</form>

</body>

</html>

.CS File code

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using MySql.Data.MySqlClient;

namespace Mysql_login_page

{

public partial class _Default : System.Web.UI.Page

{

string strcon = "Server=localhost;Database=test;Uid=root;Pwd=;";

string str;

MySqlCommand com ;

object obj;

protected void btn_login_Click(object sender, EventArgs e)

{

MySqlConnection con = new MySqlConnection(strcon);

con.Open();

str = "select count(*) from login where UserName=@UserName and Password =@Password";

com = new MySqlCommand(str, con);

com.CommandType = CommandType.Text;

com.Parameters.AddWithValue("@UserName", TextBox_user_name.Text);

com.Parameters.AddWithValue("@Password", TextBox_password.Text);

obj = com.ExecuteScalar();

if (Convert.ToInt32(obj) != 0)

{

Response.Redirect("Welcome.aspx");

}

else

{

lb1.Text = "invalid user name and password";

}

con.Close();

}

}

}