Hi Amit1992,
Refer below sample.
HTML
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript" src='https://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.3.min.js'></script>
<script type="text/javascript" src='https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/js/bootstrap.min.js'></script>
<link rel="stylesheet" href='https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.0.3/css/bootstrap.min.css'
media="screen" />
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<!-- Bootstrap -->
<!-- Bootstrap -->
<center>
<button type="button" class="btn btn-info btn-lg" data-toggle="modal" data-target="#DivRegister">
Register</button>
<button type="button" class="btn btn-info btn-lg" data-toggle="modal" data-target="#DivLogin">
Login</button>
</center>
<div id="DivLogin" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">
×</button>
<h4 class="modal-title">
</h4>
</div>
<div class="modal-body">
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<ContentTemplate>
<h3>
Login</h3>
UserName :
<asp:TextBox ID="txtloginusername" placeholder="Username" runat="server" required="required"></asp:TextBox><br />
Password :
<asp:TextBox ID="txtloginpasswd" placeholder="Password" TextMode="Password" runat="server"></asp:TextBox><br />
</ContentTemplate>
</asp:UpdatePanel>
</div>
<div class="modal-footer">
<asp:Button ID="btnLogin" Text="Submit" runat="server" OnClick="Login" CssClass="btn btn-success" />
</div>
</div>
</div>
</div>
<!-- Modal Popup -->
<div id="DivRegister" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">
×</button>
<h4 class="modal-title">
</h4>
</div>
<div class="modal-body">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<h3>
Sign up</h3>
UserName :
<asp:TextBox ID="txtusername" placeholder="Username" runat="server" required="required"></asp:TextBox><br />
Email :
<asp:TextBox ID="txtemail" placeholder="Email" runat="server" required="required"></asp:TextBox><br />
Password :
<asp:TextBox ID="txtpasswd" placeholder="Password" TextMode="Password" runat="server"></asp:TextBox><br />
Confirm Password :
<asp:TextBox ID="txtconfirmpass" placeholder="Confirm Password" TextMode="Password"
runat="server"></asp:TextBox>
</ContentTemplate>
</asp:UpdatePanel>
</div>
<div class="modal-footer">
<asp:Button ID="btnRegister" Text="Submit" runat="server" OnClick="Register" CssClass="btn btn-success" />
</div>
</div>
</div>
</div>
</form>
</body>
</html>
Namespaces
C#
using System.Data.SqlClient;
using System.Configuration;
VB.Net
Imports System.Data.SqlClient
Code
C#
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
protected void Login(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT UserName FROM User_Registration WHERE UserName = @UserName AND Password = @Pwd", con))
{
cmd.Parameters.AddWithValue("@UserName", txtloginusername.Text);
cmd.Parameters.AddWithValue("@Pwd", txtloginpasswd.Text);
con.Open();
string result = Convert.ToString(cmd.ExecuteScalar());
con.Close();
if (!string.IsNullOrEmpty(result))
{
Response.Write("<script>alert('Successfully Login');</script>");
Server.Transfer("index.aspx", true);
}
else
{
Response.Write("<script>alert('Invalid username or password');</script>");
}
}
}
}
protected void Register(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO User_Registration(UserName,Email,Password,ConfirmPassword) VALUES(@Name,@Email,@Pwd,@cnfpwd)", con))
{
cmd.Parameters.AddWithValue("@Name", txtusername.Text);
cmd.Parameters.AddWithValue("@Email", txtemail.Text);
cmd.Parameters.AddWithValue("@Pwd", txtpasswd.Text);
cmd.Parameters.AddWithValue("@cnfpwd", txtconfirmpass.Text);
con.Open();
int i = Convert.ToInt16(cmd.ExecuteNonQuery());
con.Close();
if (i == 1)
{
Response.Write("<script>alert('Thank you for Registration');</script>");
}
}
}
}
VB.Net
Private constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
divLogin.Visible = False
End Sub
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As EventArgs)
Using con As SqlConnection = New SqlConnection(constr)
Using cmd As SqlCommand = New SqlCommand("SELECT UserName FROM User_Registration WHERE UserName = @UserName AND Password = @Pwd", con)
cmd.Parameters.AddWithValue("@UserName", txtloginusername.Text)
cmd.Parameters.AddWithValue("@Pwd", txtloginpasswd.Text)
con.Open()
Dim result As String = Convert.ToString(cmd.ExecuteScalar())
con.Close()
If Not String.IsNullOrEmpty(result) Then
Response.Write("<script>alert('Successfully Login');</script>")
Server.Transfer("index.aspx", True)
Else
Response.Write("<script>alert('Invalid username or password');</script>")
End If
End Using
End Using
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)
Using con As SqlConnection = New SqlConnection(constr)
Using cmd As SqlCommand = New SqlCommand("INSERT INTO User_Registration(UserName,Email,Password,ConfirmPassword) VALUES(@Name,@Email,@Pwd,@cnfpwd)", con)
cmd.Parameters.AddWithValue("@Name", txtusername.Text)
cmd.Parameters.AddWithValue("@Email", txtemail.Text)
cmd.Parameters.AddWithValue("@Pwd", txtpasswd.Text)
cmd.Parameters.AddWithValue("@cnfpwd", txtconfirmpass.Text)
con.Open()
Dim i As Integer = Convert.ToInt16(cmd.ExecuteNonQuery())
con.Close()
If i = 1 Then
Response.Write("<script>alert('Thank you for Registration');</script>")
divLogin.Visible = True
divRegistration.Visible = False
End If
End Using
End Using
End Sub
Screenshot