Check for syntax - Dev Articles

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

October 1st, 2004, 02:40 AM

mcupryk

Registered User

Join Date: Oct 2004

Posts: 3

Time spent in forums: < 1 sec
Reputation Power: 0

Check for syntax

<%@ Page CompilerOptions='/R:"C:\Program
Files\Microsoft.NET\Odbc.Net\Microsoft.data.odbc.d ll"'%>
<%@ import namespace="System.Web.UI" %>
<%@ import namespace="System.Web.SessionState" %>
<%@ import namespace="System.Web" %>
<%@ import namespace="System.Drawing" %>
<%@ import namespace="System.ComponentModel" %>
<%@ import namespace="System.Collections" %>
<%@ import namespace="System.Text" %>
<%@ import namespace="System.Data" %>
<%@ Import Namespace="Microsoft.Data.Odbc" %>
<%@ Register TagPrefix="mspos" TagName="header"
Src="~/Engine/Controls/header.ascx" %>
<%@ Register TagPrefix="mspos" TagName="footer"
Src="~/Engine/Controls/footer.ascx" %>
<HTML>
<HEAD>
<title></title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
<script language="C#" runat="server">

bool CustomAutenticate (string username, string password)
{
OdbcCommand objcmd;
OdbcConnection oConn;
OdbcDataReader objreader;

string strSQL ="select * from TBUSERS where USERNAME='" + username +
"' and PASSWD='" + password + "'";
string sConnString = "DSN=POS;UID=system;PWD=system";

OdbcConnection myConn = new OdbcConnection(sConnString);
OdbcCommand myCmd = new OdbcCommand(strSQL, myConn);
OdbcDataReader dr = null;
try
{
myConn.Open();
dr = myCmd.ExecuteReader();
if(dr.Read()) {
if(dr.GetString(0).Trim() == username.Trim()) {
FormsAuthentication.RedirectFromLoginPage(username ,
false);
return(true);
}
else
Output.Text = "Sorry! Your login or password is
incorrect. <br>Please log in again.";
}
else
{
Output.Text = "Sorry! Your login or password is incorrect.
<br>Please log in again.";
}
}
catch(Exception myException) {
Response.Write("Oops. The error: " + myException.Message);
}
finally {
myConn.Close();
}
return false;
}

void OnSubmit (Object sender, EventArgs e)
{
bool Check=false;
Check=CustomAutenticate;
if (Check == true)
Response.Redirect("default.aspx");
}
</script>
</HEAD>
<body background="images/bg.gif" leftMargin="0" topMargin="0"
marginheigh="0" marginwidth="0"
bgColor="#fef9e9">
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tbody>
<tr>
<td>
<mspos:header id="Header1" runat="server"></mspos:header>
</td>
</tr>
<tr>
<td> 
</td>
</tr>
<tr>
<td valign="middle" align="center">
<form id="form1" name="form1" action="" method="post"
runat="server">
<table bordercolor="#cccc99" cellspacing="0" cellpadding="0"
width="369" align="center"
border="2" bgColor="#fef9e9" height="176">
<tbody>
<tr>
<td align="center">
<table cellspacing="4" cellpadding="3" width="100%"
background="file:///D|/webprojects/vipdotnet/images/tdback.jpg"
border="0">
<tbody>
<tr>
<td nowrap colspan="2">
<P align="center"><FONT face="Verdana, Arial, Helvetica,
sans-serif" color="#000000" size="2"><STRONG>Please
Enter your Username and Password</STRONG></FONT></P>
</td>
</tr>
<tr>
<td>
<P align="right">
<IMG height="40" src="images/key.gif"
width="36"> </P>
</td>
<td>  <FONT color="#adae7d"><STRONG><FONT
face="Arial">User Login</FONT></STRONG></FONT>
</td>
</tr>
<tr>
<td>
<div align="right"><font face="Verdana, Arial,
Helvetica, sans-serif" size="2">User
Name:</font>
</div>
</td>
<td>
<asp:textbox id="UserName" runat="server"
TextMode="SingleLine" MaxLength="32" Width="150px"></asp:textbox>
</td>
</tr>
<tr>
<td>
<div align="right"><font face="Verdana, Arial,
Helvetica, sans-serif" size="2">Password:</font>
</div>
</td>
<td>
<asp:textbox id="Password" runat="server"
TextMode="Password" MaxLength="40" Width="150px"></asp:textbox>
</td>
</tr>
<tr>
<td> 
</td>
<td><asp:Button Text="Submit" OnClick="OnSubmit"
RunAt="server" ID="Button"></asp:Button> 
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</form>
<asp:Label id="Output" runat="server"></asp:Label><BR>
</td>
</tr>
</tbody>
</table>
</body>
</HTML>

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: