Guestbook Problems

  • Thread starter Thread starter Oded Dror
  • Start date Start date
O

Oded Dror

Please take a look at this code

<%@ Page Language="VB" Debug="true"%>
<%@ Import Namespace="System.Windows.Forms" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace ="System.Web.UI.Page" %>

<html >
<head runat="server">
<title>Guestbook</title>
<script runat="server">
Sub Submit_Click(sender As Object, e As EventArgs)
Call MyInsertMethod()
End Sub
Function MyInsertMethod() As Integer
Dim MyConn As AccessDataSource
MyConn = AccessDataSource1
Dim cmd As AccessDataSource
Dim MySQL As String = "INSERT INTO Guest (FirstName, LastName) VALUES ('" &
FirstName.Text & "','" & LastName.Text & "')"
MyConn.Open() ************ Error 1 'MyConn' is not a member of
'System.Web.UI.WebControls.AccessDataSource'.
cmd.ExecuteNonQuery(MyConn, MySQL) ******** is not a member of
'System.Web.UI.WebControls.AccessDataSource'
MyConn.Close() *************is not a member of
'System.Web.UI.WebControls.AccessDataSource'
Response.Redirect("Guestlog.aspx")
End Function
</script>

Whats wrong with this lines?
I'm trying to insert FirstName LastName into Access table

Thanks
Oded Dror
 
Questions :

1. why are you importing Windows.Forms for use in a web page ?
2. why are you importing System.Drawing ?
3. why are you importing System.Web.UI.Page ?



Juan T. Llibre
ASP.NET MVP
ASPNETFAQ.COM : http://www.aspnetfaq.com
==================================
 
Back
Top