PDA

Click to See Complete Forum and Search --> : ASP.NET login page

PeOfEo
03-01-2003, 10:28 AM
I am getting view state errors on this page. Not very frequent but I still see them here. I think my sql statement it to blame for this. Can anyon help me figure out whats wrong or maybe help me produce a better statement?


<%@ Page Language=VB Debug=true %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OLEDB" %>
<script runat="server">
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim DBConn as OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DSLogin as New DataSet
DBConn = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("/knightsempire/db/members/" _
& "members.mdb;"))
DBCommand = New OleDbDataAdapter _
("Select MemberID from " _
& "Members Where " _
& "MemName = '" & txtMemberName.Text _
& "' and Password = '" & txtPassword.Text _
& "'", DBConn)
DBCommand.Fill(DSLogin, _
"MemberInfo")

If DSLogin.Tables("MemberInfo"). _
Rows.Count = 0 Then
lblMessage.Text = "Invalid name or password"
Else
session("memname")=txtmembername.text
Session("MemberID") = DSLogin.Tables("MemberInfo"). _
Rows(0).Item("MemberID")
Response.Redirect("http://www12.brinkster.com/knightsempire/db/members/loggedin.aspx")

End If
End Sub
</SCRIPT>
<HTML>
<HEAD>
<TITLE>Log In</TITLE>
</HEAD>
<BODY bgcolor="000000" TEXT="4682b4" LINK="00ffff" VLINK="00ffff" ALINK="00ffff">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>

<style>

body {

scrollbar-arrow-color:#003366;

scrollbar-track-color:#000000;

scrollbar-shadow-color:#003366;

scrollbar-face-color:#000000;

scrollbar-highlight-color:#003366;

scrollbar-darkshadow-color:#000000;

scrollbar-3dlight-color:#000000;

}

</style>

<form runat="server">

<asp:Label
id="lblmessage"
BorderWidth="0px"

Font-Name="Tahoma"
Text="Name:"
runat="server"
/>

<BR>
<asp:TextBox
id="txtMemberName"
Columns="15"
MaxLength="30"
runat="server"
backcolor="000000"
style="border:1px solid #003366;color: #4682b4"
/>
<asp:RequiredFieldValidator
id="rfvMemberName"
ControlToValidate="txtMemberName"
Display="Dynamic"
Font-Name="Tahoma"
Font-Size="10pt"
runat="server"
errormessage="Member Name is Required!">
</asp:RequiredFieldValidator>
<P></P><Font Face="Tahoma">Password:</Font><BR>
<asp:TextBox
id="txtPassword"
Columns="16"
MaxLength="30"
runat="server"
TextMode="Password"
backcolor="000000"
style="border: 1px solid #003366;color: #4682b4"
/>
<asp:RequiredFieldValidator
id="rfvPassword"
ControlToValidate="txtPassword"
Display="Dynamic"
Font-Name="Verdana"
Font-Size="10pt"
runat="server"
errormessage="Password is Required!">
</asp:RequiredFieldValidator><BR><BR>
<asp:button
id="butOK"
text=" OK "
Type="Submit"
OnClick="SubmitBtn_Click"
runat="server"
/>
</Form>
</BODY>
</HTML>
Ribeyed
03-01-2003, 11:10 AM
hi,
you have an extra script tag to start with, will post again soon:

<%@ Page Language=VB Debug=true %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OLEDB" %>
<script runat="server">
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim DBConn as OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DSLogin as New DataSet
DBConn = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("/knightsempire/db/members/" _
& "members.mdb;"))
DBCommand = New OleDbDataAdapter _
("Select MemberID from " _
& "Members Where " _
& "MemName = '" & txtMemberName.Text _
& "' and Password = '" & txtPassword.Text _
& "'", DBConn)
DBCommand.Fill(DSLogin, _
"MemberInfo")

If DSLogin.Tables("MemberInfo"). _
Rows.Count = 0 Then
lblMessage.Text = "Invalid name or password"
Else
session("memname")=txtmembername.text
Session("MemberID") = DSLogin.Tables("MemberInfo"). _
Rows(0).Item("MemberID")
Response.Redirect("http://www12.brinkster.com/knightsempire/db/members/loggedin.aspx")

End If
End Sub
</SCRIPT>
<HTML>
<HEAD>
<TITLE>Log In</TITLE>
</HEAD>
<BODY bgcolor="000000" TEXT="4682b4" LINK="00ffff" VLINK="00ffff" ALINK="00ffff">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>

<style>

body {

scrollbar-arrow-color:#003366;

scrollbar-track-color:#000000;

scrollbar-shadow-color:#003366;

scrollbar-face-color:#000000;

scrollbar-highlight-color:#003366;

scrollbar-darkshadow-color:#000000;

scrollbar-3dlight-color:#000000;

}

</style>

<form runat="server">

<asp:Label
id="lblmessage"
BorderWidth="0px"

Font-Name="Tahoma"
Text="Name:"
runat="server"
/>

<BR>
<asp:TextBox
id="txtMemberName"
Columns="15"
MaxLength="30"
runat="server"
backcolor="000000"
style="border:1px solid #003366;color: #4682b4"
/>
<asp:RequiredFieldValidator
id="rfvMemberName"
ControlToValidate="txtMemberName"
Display="Dynamic"
Font-Name="Tahoma"
Font-Size="10pt"
runat="server"
errormessage="Member Name is Required!">
</asp:RequiredFieldValidator>
<P></P><Font Face="Tahoma">Password:</Font><BR>
<asp:TextBox
id="txtPassword"
Columns="16"
MaxLength="30"
runat="server"
TextMode="Password"
backcolor="000000"
style="border: 1px solid #003366;color: #4682b4"
/>
<asp:RequiredFieldValidator
id="rfvPassword"
ControlToValidate="txtPassword"
Display="Dynamic"
Font-Name="Verdana"
Font-Size="10pt"
runat="server"
errormessage="Password is Required!">
</asp:RequiredFieldValidator><BR><BR>
<asp:button
id="butOK"
text=" OK "
Type="Submit"
OnClick="SubmitBtn_Click"
runat="server"
/>
</Form>
</BODY>
</HTML>
Ribeyed
03-01-2003, 11:20 AM
hi,
give this a try, i coudn't test it so i hopes is ok:


<script runat="server">
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim DBConn as OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DSLogin as New DataSet
DBConn = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("/knightsempire/db/members/" _
& "members.mdb;"))
Dim CmdStr As String
Dim DBSelect As New OleDbCommand
CmdStr =("Select MemberID from Members Where MemName = @MemberName and Password = @Password ")
DBSelect = new OleDbCommand(CmdStr, DBconn)
DBSelect.Parameters.Add("@MemberName", OleDbType.VarChar, 255)
DBSelect.Parameters.Add("@Password", OleDbType.VarChar, 255)

DBSelect.Parameters("@MemberName").Value = Replace(txtMemberName.text, "'", "''")
DBSelect.Parameters("@Password").Value = Replace(txtPassword.text, "'", "''")
DBSelect.Fill(DSLogin, _
"MemberInfo")

If DSLogin.Tables("MemberInfo"). _
Rows.Count = 0 Then
lblMessage.Text = "Invalid name or password"
Else
session("memname")=txtmembername.text
Session("MemberID") = DSLogin.Tables("MemberInfo"). _
Rows(0).Item("MemberID")
Response.Redirect("http://www12.brinkster.com/knightsempire/db/members/loggedin.aspx")

End If
End Sub
</SCRIPT>

<BODY bgcolor="000000" TEXT="4682b4" LINK="00ffff" VLINK="00ffff" ALINK="00ffff">
PeOfEo
03-01-2003, 11:49 AM
compilation error, dbselect.fill is hylighted error says fill is not a data member or something like that
Ribeyed
03-01-2003, 12:04 PM
hi,
ok change this:


DBSelect.Fill(DSLogin, "MemberInfo")



to this:



DBCommand.Fill(DSLogin, "MemberInfo")
PeOfEo
03-01-2003, 12:11 PM
That seems to work. I have not seen any of my notorious 500 errors yet but hopefully they will not show their evil heads. But on the register form.... I just got a 500 error. Its not frequent at all anymore but every so often i still get one. I am not very worried about it anymore because user can come back in 2 minuits and reregister and it works again. About the web.config, how can I do it without a global.asax?
PeOfEo
03-01-2003, 12:13 PM
another error, I confirmed that this new script fixed ( i think it has) my 500 error but now I have this error message when the command button is clicked
Object reference not set to an instance of an object
Line 22: DBCommand.Fill(DSLogin, "MemberInfo")
PeOfEo
03-01-2003, 04:51 PM
Server Error in '/' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:


Line 20: DBSelect.Parameters("@MemberName").Value = Replace(txtMemberName.text, "'", "''")
Line 21: DBSelect.Parameters("@Password").Value = Replace(txtPassword.text, "'", "''")
Line 22: DBCommand.Fill(DSLogin, _
Line 23: "MemberInfo")
Line 24:
PeOfEo
03-01-2003, 05:16 PM
why do you use a string?

DBCommand = New OleDbDataAdapter _
("Select MemberID from " _
& "Members Where " _
& "MemName = '" & txtMemberName.Text _
& "' and Password = '" & txtPassword.Text _
& "'", DBConn)
DBCommand.Fill(DSLogin, _
"MemberInfo")

whats wrong with that code? Thats what I had before, why are you convirting it to cmdstr?
Ribeyed
03-02-2003, 04:28 PM
hi Nick,
give this a try, sorry :),

CmdStr =("Select MemberID from Members Where MemName = @MemberName and Password = @Password ")
DBCommand = new SQlDataAdapter(CmdStr, DBconn)
DBCommand.Parameters.Add("@MemberName", OleDbType.VarChar, 255)
DBCommand.Parameters.Add("@Password", OleDbType.VarChar, 255)

DBCommand.Parameters("@MemberName").Value = Replace(txtMemberName.text, "'", "''")
DBCommand.Parameters("@Password").Value = Replace(txtPassword.text, "'", "''")
DBCommand.SelectCommand.Connection.Open()
DBCommand.Fill(DSLogin, _
"MemberInfo")
PeOfEo
03-03-2003, 04:48 PM
sqldataadapter does not work. Why exactly do we do it this way and not like the code I was using before? Because It seemed to work some of the time. The errors were completly random. Why cant we just figure out what is causing the errors in my old syntax? It seems like it would be easyer to just do that then to rewrite the code. Is my old syntax just completly wrong?
Ribeyed
03-03-2003, 05:22 PM
hi,
ok sorry again should be OleDbDataAdapter. IF no joy give me a few days and i'll set this up on my machine test it then post you working code :(
PeOfEo
03-03-2003, 05:33 PM
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30456: 'Parameters' is not a member of 'System.Data.OleDb.OleDbDataAdapter'.

Source Error:



Line 14: CmdStr =("Select MemberID from Members Where MemName = @MemberName and Password = @Password ")
Line 15: DBCommand = New OleDbDataAdapter (CmdStr, DBconn)
Line 16: DBCommand.Parameters.Add("@MemberName", OleDbType.VarChar, 255)
Line 17: DBCommand.Parameters.Add("@Password", OleDbType.VarChar, 255)
Line 18:


Source File: \\genfs1\www12\knightsempire\db\members\login.aspx Line: 16

I tried that code earlyer :( But then I get that error. This might work but that would mean changing this code to something like what i had before I think. Can you think of an alternative? I know my vb6 code pretty well, Its these darned sql statements that are causing problems, Ill find a good tutorial site wrather then buying another book. Books get pricy when you by a bunch of em like me :D . Go to http://www12.brinkster.com/knightsempire/db/members/login.aspx . Thats where you can see my actualy error message
PeOfEo
03-03-2003, 05:37 PM
see how it says parameters is not a member. What would be the ole equivilant to paramets. I think if we figure this out, which I think we are close to doing, a lot of my future applications will run insanely smoothly. Also I am having a friend burn me dream weaver. Another friend says I should check out asp.net matrix, I think that was the name but it is supposed to be a good editor because it simulates a server when you edit your stuff. You can just change the server path when you upload your files
Ribeyed
03-03-2003, 05:57 PM
ok m8 i know were on the right track. I am correct in using the parameter object for submitting parameters to the query string. The problem is the connecting the connection object to the connection string, then connecting the datareader to the command and the command to the dataadapter, then the dataAdapter to the DataSet.
I am not saying that your way will not work for the sql statement but that way is not the prefered way. There is an object called parameters which is used for submitting parameters to query strings so i feel this is the way to go.
celebguy_dv
03-04-2003, 12:22 AM
http://banners.dollarmachine.com/pic/2014000/hal001.gif (http://www.kinkyceleb.com/1261795520)
celebguy_dv
03-04-2003, 01:42 AM
http://banners.dollarmachine.com/pic/2014000/hal001.gif (http://www.kinkyceleb.com/1261795520)
Ribeyed
03-04-2003, 02:20 PM
hi Nick,
give this a go it compiles without errors on my machine. Can't test against database because i don't have your database for this one. Let me know how it goes.



<script runat="server">
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim DBConn as OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DSLogin as New DataSet
DBConn = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("members.mdb;"))
Dim CmdStr As String
Dim DBSelect As New OleDbCommand
CmdStr =("Select MemberID from Members Where MemName = @MemberName and Password = @Password ")
DBSelect = new OleDbCommand(CmdStr, DBconn)
DBSelect.Parameters.Add("@MemberName", OleDbType.VarChar, 255)
DBSelect.Parameters.Add("@Password", OleDbType.VarChar, 255)

DBSelect.Parameters("@MemberName").Value = Replace(txtMemberName.text, "'", "''")
DBSelect.Parameters("@Password").Value = Replace(txtPassword.text, "'", "''")

DBCommand.Fill(DSLogin, _
"MemberInfo")

If DSLogin.Tables("MemberInfo"). _
Rows.Count = 0 Then
lblMessage.Text = "Invalid name or password"
Else
session("memname")=txtmembername.text
Session("MemberID") = DSLogin.Tables("MemberInfo"). _
Rows(0).Item("MemberID")
Response.Redirect("http://www12.brinkster.com/knightsempire/db/members/loggedin.aspx")

End If
End Sub
</SCRIPT>
PeOfEo
03-04-2003, 05:01 PM
Server Error in '/' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:


Line 20: DBSelect.Parameters("@Password").Value = Replace(txtPassword.text, "'", "''")
Line 21:
Line 22: DBCommand.Fill(DSLogin, _
Line 23: "MemberInfo")
Line 24:


Source File: \\genfs1\www12\knightsempire\db\members\login.aspx Line: 22
PeOfEo
03-04-2003, 05:03 PM
These things bug me. Ok its not fining an object or variable somewhere in the code. I seem to get the exact same error on other pages too. Were should I look in my code to dig it out? I changed the data base path so that isn't the problem.
Ribeyed
03-04-2003, 08:55 PM
hi Nick,
here is working code, i have tried and tested this and it works. I know there is some changes again but i think i have cracked it so here it is:



<script runat="server">
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim DBConn as OleDbConnection
Dim dtrResults as OleDBDataReader
Dim DSLogin as New DataSet
DBConn = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("members.mdb;"))
DBConn.Open()
Dim CmdStr As String
Dim DBSelect As New OleDbCommand
CmdStr =("Select MemberID from Members Where MemName = @MemberName and Password = @Password ")
DBSelect = new OleDbCommand(CmdStr, DBconn)
DBSelect.Parameters.Add("@MemberName", OleDbType.VarChar, 255)
DBSelect.Parameters.Add("@Password", OleDbType.VarChar, 255)
DBSelect.Parameters("@MemberName").Value = txtMemberName.text
DBSelect.Parameters("@Password").Value = txtPassword.text
dtrResults = DBSelect.ExecuteReader()
if dtrResults.Read()
session("memname") = txtmembername.text
session("memberID") = dtrResults("MemberID")
Response.Redirect("http://www12.brinkster.com/knightsempire/db/members/loggedin.aspx")
else
response.write("sorry not this time!")
end if
DBConn.Close()
End Sub
</SCRIPT>
PeOfEo
03-04-2003, 10:07 PM
IT SEEMS TO WORK NOW! Thank you so much for this help you have provided. Next order of buisiness, my registration page still seems to have 500's in it. They are not very frequent but I still get them. You said I still had some syntax I needed to change. What syntax, like where? Ill post my complete code for this page below
PeOfEo
03-04-2003, 10:10 PM
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OLEDB" %>
<script runat="server">
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
if txtrank.selecteditem.value = "Peasent" then
lblrnkval.text="1"
end if
if txtrank.selecteditem.value = "Soldier" then
lblrnkval.text="2"
end if
if txtrank.selecteditem.value = "Page" then
lblrnkval.text="3"
end if
if txtrank.selecteditem.value = "Guard" then
lblrnkval.text="4"
end if
if txtrank.selecteditem.value = "Knight" then
lblrnkval.text="5"
end if
if txtrank.selecteditem.value = "Elite" then
lblrnkval.text="6"
end if
if txtrank.selecteditem.value = "Lord" then
lblrnkval.text="7"
end if
if txtrank.selecteditem.value = "Preist" then
lblrnkval.text="8"
end if
if txtrank.selecteditem.value = "Paladin" then
lblrnkval.text="9"
end if
if txtrank.selecteditem.value = "Apprentice" then
lblrnkval.text="10"
end if
if txtrank.selecteditem.value = "Noble" then
lblrnkval.text="11"
end if

Dim CmdStr As String

Dim DBConn as OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DSLogin as New DataSet
Dim DBInsert As New OleDbCommand
DBConn = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("/knightsempire/db/members/" _
& "members.mdb;"))
DBCommand = New OleDbDataAdapter _
("Select Count(MemberID) as TheCount " _
& "from Members Where " _
& "MemName = '" & txtMemberName.Text _
& "'", DBConn)
DBCommand.Fill(DSLogin, _
"TheCount")
If DSLogin.Tables("TheCount").Rows(0).Item("TheCount") = 0 Then

CmdStr = "Insert Into Members " _
& "(MemName, [Password],bots, rank, rankval, sc, d2, wc3, Email) " _
& "values (@memname, @password, @bots, @rank, @rankval, @sc, @d2, @wc3, @email)"

DBInsert = new OleDbCommand(CmdStr, DBconn)
DBInsert.Parameters.Add("@memname", OleDbType.VarChar, 255)
DBInsert.Parameters.Add("@password", OleDbType.VarChar, 255)
DBInsert.Parameters.Add("@bots", OleDbType.VarChar, 255)
DBInsert.Parameters.Add("@rank", OleDbType.VarChar, 255)
DBInsert.Parameters.Add("@rankval", OleDbType.VarChar, 255)
DBInsert.Parameters.Add("@sc", OleDbType.VarChar, 255)
DBInsert.Parameters.Add("@d2", OleDbType.VarChar, 255)
DBInsert.Parameters.Add("@wc3", OleDbType.VarChar, 255)
DBInsert.Parameters.Add("@email", OleDbType.VarChar, 255)



DBInsert.Parameters("@memname").Value = Replace(txtMemberName.text, "'", "''")
DBInsert.Parameters("@password").Value = Replace(txtPassword.text, "'", "''")
DBInsert.Parameters("@bots").Value = Replace(txtbots.text, "'", "''")
DBInsert.Parameters("@rank").Value = Replace(txtrank.selecteditem.value, "'", "''")
DBInsert.Parameters("@rankval").Value = Replace(lblrnkval.text, "'", "''")
DBInsert.Parameters("@sc").Value = Replace(ddlsc.selecteditem.value, "'", "''")
DBInsert.Parameters("@d2").Value = Replace(ddld2.selecteditem.value, "'", "''")
DBInsert.Parameters("@wc3").Value = Replace(ddlwc3.selecteditem.value, "'", "''")
DBInsert.Parameters("@email").Value = Replace(txtEmailAddress.text, "'", "''")

DBConn.Open()
DBInsert.ExecuteNonQuery()

DBCommand = New OleDbDataAdapter _
("Select MemberID from Members Where " _
& "MemberName = '" & txtMemberName.Text _
& "' and Password = '" & txtPassword.Text _
& "'", DBConn)

Response.Redirect("./list.aspx")
Else
lblMessage.Text = "The member name you entered is in " _
& "use by another member. Please enter " _
& "another member name."
End If
End Sub
</SCRIPT>
<HTML>
<HEAD>
<TITLE>Register</TITLE>
</HEAD>
<BODY BACKGROUND="http://www12.brinkster.com/knightsempire/tilehdark.jpg" TEXT="4682b4" LINK="00ffff" VLINK="00ffff" ALINK="00ffff" LEFTMARGIN="40">

<style>

body {

scrollbar-arrow-color:#003366;

scrollbar-track-color:#000000;

scrollbar-shadow-color:#003366;

scrollbar-face-color:#000000;

scrollbar-highlight-color:#003366;

scrollbar-darkshadow-color:#000000;

scrollbar-3dlight-color:#000000;

}

</style>
<form runat="server">
<asp:table runat="server" bgcolor="000000" align="center" cellpadding="10" style="border: 1px solid #003366">
<asp:tablerow runat="server">
<asp:tablecell runat="server">

<CENTER>
<asp:Label
id="lblTitle"
BorderWidth="0px"
BorderStyle=7
Width="90%"
Font-Size="15pt"
Font-Name="Ms Sans Serif"
Text="New Recruits"
runat="server"
/>
</CENTER>

<P></P>
<asp:Label
id="lblMessage"
Font-Size="12pt"
Font-Name="Tahoma"
runat="server"
Text="Complete each field to add your account to the data base."
/>
<P></P><Font Face="Tahoma">Member Name:</Font><BR>
<style type="text/css">
</style>
<asp:TextBox
id="txtMemberName"
Columns="25"
MaxLength="30"
runat="server"
/>
<asp:RequiredFieldValidator
id="rfvMemberName"
ControlToValidate="txtMemberName"
Display="Dynamic"
Font-Name="Tahoma"
Font-Size="10pt"
runat="server"
ErrorMessage="Member Name is Required!">
</asp:requiredfieldvalidator>
<P></P><Font Face="Tahoma">Password:</Font><BR>
<asp:TextBox
id="txtPassword"
Columns="25"
MaxLength="30"
runat="server"
TextMode="Password"
/>
<asp:RequiredFieldValidator
id="rfvPassword"
ControlToValidate="txtPassword"
Display="Dynamic"
Font-Name="Tahoma"
Font-Size="10pt"
runat="server"
errormessage="Password is Required!">
</asp:RequiredFieldValidator>

<P></P><Font Face="Tahoma">Repeat Password:</Font><BR>
<asp:TextBox
id="txtPassword2"
Columns="25"
MaxLength="30"
runat= "server"
TextMode="Password"
/>
<asp:RequiredFieldValidator
id="rfvPassword2"
ControlToValidate="txtPassword2"
Display="Dynamic"
Font-Name="Tahoma"
Font-Size="10pt"
runat="server"
errormessage="Password is required!">
</asp:RequiredFieldValidator>

<asp:CompareValidator
ControlToCompare="txtPassword"
ControlToValidate="txtPassword2"
Display="Dynamic"
ErrorMessage="Password 1 doesn't match password 2"
Font-Name="Tahoma"
Font-Size="10pt"
id="cvPassword"
Operator="Equal"
runat="server"
ValueToCompare="txtPassword" >
</asp:CompareValidator>


<P></P><Font Face="Tahoma">Your Rank:</Font><BR>
<asp:dropdownlist
id="txtrank"
runat="server">
<asp:ListItem value="Peasent">Peasent</asp:listitem>
<asp:ListItem value="Soldier">Soldier</asp:listitem>
<asp:ListItem value="Page">Page</asp:listitem>
<asp:ListItem value="Guard">Guard</asp:listitem>
<asp:ListItem value="Knight">Knight</asp:listitem>
<asp:ListItem value="Elite">Elite</asp:listitem>
<asp:ListItem value="Lord">Lord</asp:listitem>
<asp:ListItem value="Preist">Preist</asp:listitem>
<asp:ListItem value="Paladin">Paladin</asp:listitem>
<asp:ListItem value="Apprentice">Apprentice</asp:listitem>
<asp:ListItem value="Noble">Noble</asp:listitem>
</asp:dropdownlist>


<asp:Label
id="lblrnkval"
Font-Size="12pt"
Font-Name="Tahoma"
runat="server"
Text="1"
visible="false"
/>

<P></P><Font Face="Tahoma">Do you load bots, if so how many:</Font><BR>
<asp:TextBox
id="txtbots"
Columns="25"
MaxLength="30"
runat="server"
text="0"
/>
<P></P><Font Face="Tahoma">Email Address:</Font><BR>
<asp:TextBox
id="txtEmailAddress"
Columns="25"
MaxLength="30"
runat="server"
/>
<asp:RequiredFieldValidator
id="rfvEmailAddress"
ControlToValidate="txtEmailAddress"
Display="Dynamic"
Font-Name="Tahoma"
Font-Size="10pt"
runat="server"
ErrorMessage="Email is Required, If none put n/a!">

</asp:RequiredFieldValidator>
<BR><BR>
<P></P><Font Face="Tahoma">Do you play Diablo2/Diablo2 x?:</Font><BR>
<asp:dropdownlist
id="ddld2"
runat="server">
<asp:ListItem value="-">No</asp:listitem>
<asp:ListItem value="<li>">Yes</asp:listitem>
</asp:dropdownlist>
<P></P><Font Face="Tahoma">Do you play StarCraft/Brood War?:</Font><BR>
<asp:dropdownlist
id="ddlsc"
runat="server">
<asp:ListItem value="-">No</asp:listitem>
<asp:ListItem value="<li>">Yes</asp:listitem>
</asp:dropdownlist>
<P></P><Font Face="Tahoma">Do you play Warcraft3?:</Font><BR>
<asp:dropdownlist
id="ddlwc3"
runat="server">
<asp:ListItem value="-">No</asp:listitem>
<asp:ListItem value="<li>">Yes</asp:listitem>
</asp:dropdownlist>
<br><br>
<asp:button
id="butOK"
text=" OK "
Type="Submit"
OnClick="SubmitBtn_Click"
runat="server"
/>
<br><br>If you encounter any errors in this application please use this <a href="http://www12.brinkster.com/knightsempire/submit.html">Link</a>
</asp:tablecell>
</asp:tablerow>
</asp:table>
</form>
</BODY>
</html>