Using ASP.net 1.1
2 QUESTIONS:
1. Why do my write commands not work?
2. This file successfully makes changes in the database record. There
surely is some simple code I could add that would *add* records to this
database. Who can tell me?
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="Syst em.Data.Oledb" %>
<script runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArg s)
Dim DBConnection As OledbConnection
DBConnection = New OledbConnection ("Provider=Micr osoft.Jet.Oledb .4.0;" & _
"Data Source=C:\Inetp ub\wwwroot\app_ data\Acc.mdb" )
DBConnection.Op en()
Dim DBCommand As OledbCommand
DBCommand = New OledbCommand("S ELECT * FROM table1, Acc")
Dim SQLString AS String
SQLString = "UPDATE Table1 SET TheEmpName='POO OOO' WHERE TheDate='6/14/07'"
DBCommand = New OleDBCommand(SQ LString, DBConnection)
DBCommand.Execu teNonquery()
Dim DBReader AS OledbDatareader
DBReader = DBCommand.Execu teReader()
While DBReader.Read()
Response.Write( DBReader("TheDa te"))
Response.Write( DBReader("TheEm pName"))
End while
' MyDataGrid.Data Source = DBReader
'MyDataGrid.Dat aBind()
DBReader.Close( )
DBConnection.Cl ose()
End Sub
</script>
</head>
<body>
<form id="form1" runat="server">
<asp:DataGrid id="MyDataGrid " runat="server"/>
</form>
</body>
</html>
