Hi all,
I believe my below code should make a login page, but can you tell me please why it says the error message "Type 'OleDbConnection' is not defined." when i compile it? I think it's because it needs to import things but I don't know how to do it in Web Matrix...
Can you help please?
<%@ Page Language="VB" %>
<script runat="server">
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
If txtmembername.text = "" and txtpassword.text ="" then
lblname.visible = true
lblpass.visible = true
else if txtmembername.text = "" then
lblname.visible = true
else if txtpassword.text = "" then
lblpass.visible = true
else
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("G:\Documents\1st Semester\EWA\UniDays\Back\UniDaysDB.mdb;"))
DBConn.Open()
Dim CmdStr As String
Dim DBSelect As New OleDbCommand
CmdStr =("Select id from members Where name = _
& @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("id")
Response.Redirect("/success.aspx")
else
lblmessage.text = "Invalid user name or password"
end if
end if
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
<asp:TextBox id="txtMemberName" runat="server" OnTextChanged="TextBox1_TextChanged"></asp:TextBox>
<asp:Label id="lblName" runat="server"></asp:Label>
</p>
<p>
<asp:TextBox id="txtPassword" runat="server"></asp:TextBox>
<asp:Label id="lblPass" runat="server"></asp:Label>
</p>
<p>
<asp:Button id="Button1" runat="server" Text="Button"></asp:Button>
</p>
<!--StartFragment -->
<!-- Insert content here -->
</form>
</body>
</html>
