Hi manishvad,
I have created a sample which full fill your requirement you need to modify the code according to your need.
HTML
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/jscript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script type="text/jscript" src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<link type="text/css" rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css" />
<style type="text/css">
.message
{
width: 100%;
position: fixed;
top: 50px;
z-index: 100000;
padding: 0;
font-size: 15px;
}
</style>
<script type="text/javascript">
function ShowMessage(message, messagetype) {
var cssclass;
switch (messagetype) {
case 'Success':
cssclass = 'alert-success'
break;
case 'Error':
cssclass = 'alert-danger'
break;
case 'Warning':
cssclass = 'alert-warning'
break;
default:
cssclass = 'alert-info'
}
$('#alert_container').append('<div id="alert_div" style="margin: 0 10%; -webkit-box-shadow: 3px 4px 6px #999;width:40%" class="alert fade in ' + cssclass + '"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a><strong>' + messagetype + '!</strong> <span>' + message + '</span></div>');
return false;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div class="message" id="alert_container">
</div>
<div align="center">
<div>
UserName
<asp:TextBox ID="txtUserName" CssClass="form-control" Width="200px" runat="server"></asp:TextBox>
</div>
<div>
Password
<asp:TextBox ID="txtPassword" CssClass="form-control" Width="200px" runat="server" />
</div>
<div>
<br />
<asp:Button ID="btnLogin" OnClick="Login" CssClass="btn btn-primary" Text="Log In"
runat="server" />
</div>
</div>
</form>
</body>
</html>
C#
public enum MessageType { Success, Error, Info, Warning };
protected void Login(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
try
{
SqlCommand cmd = new SqlCommand("SELECT UserName FROM Users WHERE UserName = @UserName AND Password = @Password", con);
cmd.Parameters.AddWithValue("@UserName", txtUserName.Text.Trim());
cmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim());
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
sdr.Read();
// Do your task
}
else
{
ShowMessage("Invalid user name / password", MessageType.Error);
}
}
catch (Exception ex)
{
ShowMessage(ex.Message.Replace("'", ""), MessageType.Error);
}
finally
{
con.Close();
}
}
protected void ShowMessage(string Message, MessageType type)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), System.Guid.NewGuid().ToString(), "ShowMessage('" + Message + "','" + type + "');", true);
}
VB.Net
Public Enum MessageType
Success
[Error]
Info
Warning
End Enum
Protected Sub Login(sender As Object, e As EventArgs)
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Dim con As New SqlConnection(constr)
Try
Dim cmd As New SqlCommand("SELECT UserName FROM Users WHERE UserName = @UserName AND Password = @Password", con)
cmd.Parameters.AddWithValue("@UserName", txtUserName.Text.Trim())
cmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim())
con.Open()
Dim sdr As SqlDataReader = cmd.ExecuteReader()
If sdr.HasRows Then
' Do your task
sdr.Read()
Else
ShowMessage("Invalid user name / password", MessageType.[Error])
End If
Catch ex As Exception
ShowMessage(ex.Message.Replace("'", ""), MessageType.[Error])
Finally
con.Close()
End Try
End Sub
Protected Sub ShowMessage(Message As String, type As MessageType)
ScriptManager.RegisterStartupScript(Me, Me.[GetType](), System.Guid.NewGuid().ToString(), (Convert.ToString("ShowMessage('") & Message) + "','" + type + "');", True)
End Sub
Screenshot
