Hi. Would you please post the code that is not working
thanks
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ReportingPage.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>MAINTENANCE REPORT</title>
</head>
<body bgcolor="#ffffcc" text="#0033cc">
<form id="form1" runat="server">
<div>
</div>
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="ID"
DataSourceID="AccessDataSource1" Height="105px" Width="197px" DefaultMode="Insert" BorderColor="White" Caption="MAINTENANCE REPORT">
<Fields>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="Problem Description" HeaderText="Problem Description" SortExpression="Problem Description" />
<asp:BoundField DataField="Equipment Description" HeaderText="Equipment Description" SortExpression="Equipment Description" />
<asp:BoundField DataField="Serial or Equipment Number" HeaderText="Serial or Equipment Number" SortExpression="Serial or Equipment Number" />
<asp:BoundField DataField="Date Reported" HeaderText="Date Reported" SortExpression="Date Reported" />
<asp:BoundField DataField="Person Reporting" HeaderText="Person Reporting" SortExpression="Person Reporting" />
<asp:BoundField DataField="Comments" HeaderText="Comments" SortExpression="Comments" />
<asp:BoundField DataField="Facility" HeaderText="Facility" SortExpression="Facility" />
<asp:CommandField ShowInsertButton="True" />
</Fields>
<EditRowStyle BorderColor="White" />
</asp:DetailsView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="C:\Documents and Settings\Harpreet Narula\My Documents\invivo.mdb" InsertCommand="INSERT INTO [MaintenanceReport] ([ID], [Problem Description], [Equipment Description], [Serial or Equipment Number], [Date Reported], [Comments], [Facility], [Person Reporting]) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
SelectCommand="SELECT [ID], [Problem Description] , [Equipment Description], [Serial or Equipment Number], [Date Reported], [Comments], [Facility], [Person Reporting] FROM [MaintenanceReport]" >
<UpdateParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="Problem_Description" Type="String" />
<asp:Parameter Name="Equipment_Description" Type="String" />
<asp:Parameter Name="Serial_or_Equipment_Number" Type="String" />
<asp:Parameter Name="Date_Reported" Type="DateTime" />
<asp:Parameter Name="Comments" Type="String" />
<asp:Parameter Name="Facility" Type="String" />
<asp:Parameter Name="Person_Reporting" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="Problem_Description" Type="String" />
<asp:Parameter Name="Equipment_Description" Type="String" />
<asp:Parameter Name="Serial_or_Equipment_Number" Type="String" />
<asp:Parameter Name="Date_Reported" Type="DateTime" />
<asp:Parameter Name="Comments" Type="String" />
<asp:Parameter Name="Facility" Type="String" />
<asp:Parameter Name="Person_Reporting" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</form>
</body>
</html>
13
