Hello to anyone who can help.
I am working on a project and I have been stumped for over two weeks. If anyone can provide insight or could help I would really appreciate it, because I am at a complete lost.
I created a gridview in asp.net 2.0. giving the user the option to edit the table within the database. Onrowupdating, I check to see if the user selected an option (approval) to be true. If it is true, than I update three fields within the table. The problem is that I am using the updatecommand and it passes parameters. During the onrowupdating, I am clearing out the parameters first and then I add the values that need to pass to the data source control. The database updates correctly, however, I receive the following error. I do not know which parameter it is referring to. I have tried serveral things, none of my options are working.
Thanks in advance
JT
Data type mismatch in criteria expression.
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.Data.OleDb.OleDbException: Data type mismatch in criteria expression.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80040e07): Data type mismatch in criteria expression.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +267
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +192
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +48
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +106
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +108
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +401
System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +721
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +78
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1215
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +858
System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +117
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Here is my code
***********************************************************
Sub ReportGrid_Update(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs)
Dim checkValueApproved As RadioButtonList = CType(GridView1.Rows(e.RowIndex).Cells(19).FindControl("ApprovalChoice"), RadioButtonList)
Dim ID_Value As Int32 = GridView1.Rows(e.RowIndex).Cells(1).Text
Dim GetContactEmail As TextBox = CType(GridView1.Rows(e.RowIndex).Cells(13).FindControl("ContactEmail"), TextBox)
Dim Contact_Email As String = GetContactEmail.Text
If checkValueApproved.SelectedValue = "True" Then
Dim dbConn As OleDbConnection
Dim dbInsert As New OleDbCommand
Dim dbCommand As OleDbDataAdapter
Dim dsCheckApproval As New DataSet
Dim DateOfPosting As DateTime = DateTime.Now
dbConn = New OleDbConnection("Provider=" _
& "Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("../App_Data/NAAAHR_Chicago.mdb;"))
dbCommand = New OleDbDataAdapter _
("Select NeedApproving, Approval, EmailSent, EmailSentDate, ContactEmail from " _
& "Jobs Where NeedApproving = True AND Approval = True AND EmailSent= False AND ID = " & ID_Value, dbConn)
dbCommand.Fill(dsCheckApproval, "Jobs")
If dsCheckApproval.Tables("Jobs").Rows.Count = 1 Then
'Contact_Email = dsCheckApproval.Tables("Jobs").Rows(0).Item("ContactEmail").ToString()
dbInsert.CommandText = "Update Jobs" & _
" SET NeedApproving = False, EmailSent = True, EmailSentDate = '" & DateOfPosting.ToShortDateString & "'" & _
" WHERE ID = " & ID_Value
dbInsert.Connection = dbConn
dbInsert.Connection.Open()
dbInsert.ExecuteNonQuery()
' Create Parameter objects to represent the fields to update and
' add the Parameter objects to the UpdateParameters collection.
Dim NeedApprovingParameter As New Parameter("NeedApproving", TypeCode.Boolean, False)
Dim EmailSentParameter As New Parameter("EmailSent", TypeCode.Boolean, True)
AccessDataSource1.UpdateParameters.Clear()
AccessDataSource1.UpdateParameters.Add(NeedApprovingParameter)
AccessDataSource1.UpdateParameters.Add(EmailSentParameter)
end sud
********************************************************
Here is the Grid and accessdatasource
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
OnRowUpdating="ReportGrid_Update" DataSourceID="AccessDataSource1" Font-Size="Small"
AllowPaging="True" AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="None">
<Columns>
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="Edit" Text="Edit" />
<asp:LinkButton ID="LinkButton2" runat="server" CommandName="Delete" Text="Delete" OnClientClick="return confirm('Are you certain you want to delete thisrod record?');" />
</ItemTemplate>
<EditItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="Server" CommandName="Update" Text="Update" />
<asp:LinkButton ID="LinkButton2" runat="server" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="JobTitle" HeaderText="JobTitle" SortExpression="JobTitle" />
<asp:BoundField DataField="JobDescription" HeaderText="JobDescription" SortExpression="JobDescription" />
<asp:BoundField DataField="JobCategory" HeaderText="JobCategory" SortExpression="JobCategory" />
<asp:BoundField DataField="Location" HeaderText="Location" SortExpression="Location" />
<asp:BoundField DataField="Education" HeaderText="Education" SortExpression="Education" />
<asp:BoundField DataField="Skills" HeaderText="Skills" SortExpression="Skills" />
<asp:BoundField DataField="Salary" HeaderText="Salary" SortExpression="Salary" />
<asp:BoundField DataField="EmploymentType" HeaderText="EmploymentType" SortExpression="EmploymentType" />
<asp:BoundField DataField="Travel" HeaderText="Travel" SortExpression="Travel" />
<asp:BoundField DataField="Company" HeaderText="Company" SortExpression="Company" />
<asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />
<asp:TemplateField HeaderText="ContactEmail" SortExpression="ContactEmail">
<EditItemTemplate>
<asp:TextBox ID="ContactEmail" runat="server" Text='<%# Bind("ContactEmail") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("ContactEmail") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ContactAddress" HeaderText="ContactAddress" SortExpression="ContactAddress" />
<asp:BoundField DataField="ContactPhone" HeaderText="ContactPhone" SortExpression="ContactPhone" />
<asp:BoundField DataField="DatePosted" HeaderText="DatePosted" SortExpression="DatePosted" />
<asp:BoundField DataField="Expires" HeaderText="Expires" SortExpression="Expires" />
<asp:TemplateField HeaderText="NeedApproving" SortExpression="NeedApproving">
<EditItemTemplate>
<asp:CheckBox ID="NeedApproving" runat="server" Checked='<%# Bind("NeedApproving") %>' />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="NeedApproving" runat="server" Checked='<%# Bind("NeedApproving") %>'
Enabled="false" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Approval" SortExpression="Approval">
<ItemTemplate>
<asp:RadioButtonList ID="ApprovalChoice" runat="server" Enabled="false" SelectedValue='<%# Bind("Approval") %>'>
<asp:ListItem Value="True">Approval</asp:ListItem>
<asp:ListItem Value="False">Disapproved</asp:ListItem>
</asp:RadioButtonList>
</ItemTemplate>
<EditItemTemplate>
<asp:RadioButtonList ID="ApprovalChoice" runat="server" SelectedValue='<%# Bind("Approval") %>'>
<asp:ListItem Value="True">Approval</asp:ListItem>
<asp:ListItem Value="False">Disapproved</asp:ListItem>
</asp:RadioButtonList>
</EditItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="URL" HeaderText="URL" SortExpression="URL" />
<asp:CheckBoxField DataField="ContactDisplay" HeaderText="ContactDisplay" SortExpression="ContactDisplay" />
<asp:TemplateField HeaderText="EmailSent" SortExpression="EmailSent">
<EditItemTemplate>
<asp:CheckBox ID="EmailSent" runat="server" Checked='<%# Bind("EmailSent") %>' />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="EmailSent" runat="server" Checked='<%# Bind("EmailSent") %>' Enabled="false" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="EmailSentDate" HeaderText="EmailSentDate" SortExpression="EmailSentDate" />
</Columns>
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#E3EAEB" />
<EditRowStyle BackColor="#7C6F57" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="Gray" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/NAAAHR_Chicago.mdb"
DeleteCommand="DELETE FROM [Jobs] WHERE [ID] = ?"
SelectCommand="SELECT * FROM [Jobs]" UpdateCommand="UPDATE [Jobs] SET [NeedApproving] = ?, [EmailSent] = ?, [JobTitle] = ?, [JobDescription] = ?, [JobCategory] = ?, [Location] = ?, [Education] = ?, [Skills] = ?, [Salary] = ?, [EmploymentType] = ?, [Travel] = ?, [Company] = ?, [ContactName] = ?, [ContactEmail] = ?, [ContactAddress] = ?, [ContactPhone] = ?, [DatePosted] = ?, [Expires] = ?, [Approval] = ?, = ?, [ContactDisplay] = ?, [Email... </asp:AccessDataSource>
I am working on a project and I have been stumped for over two weeks. If anyone can provide insight or could help I would really appreciate it, because I am at a complete lost.
I created a gridview in asp.net 2.0. giving the user the option to edit the table within the database. Onrowupdating, I check to see if the user selected an option (approval) to be true. If it is true, than I update three fields within the table. The problem is that I am using the updatecommand and it passes parameters. During the onrowupdating, I am clearing out the parameters first and then I add the values that need to pass to the data source control. The database updates correctly, however, I receive the following error. I do not know which parameter it is referring to. I have tried serveral things, none of my options are working.
Thanks in advance
JT
Data type mismatch in criteria expression.
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.Data.OleDb.OleDbException: Data type mismatch in criteria expression.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80040e07): Data type mismatch in criteria expression.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +267
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +192
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +48
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +106
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +108
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +401
System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +721
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +78
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1215
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +858
System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +117
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Here is my code
***********************************************************
Sub ReportGrid_Update(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs)
Dim checkValueApproved As RadioButtonList = CType(GridView1.Rows(e.RowIndex).Cells(19).FindControl("ApprovalChoice"), RadioButtonList)
Dim ID_Value As Int32 = GridView1.Rows(e.RowIndex).Cells(1).Text
Dim GetContactEmail As TextBox = CType(GridView1.Rows(e.RowIndex).Cells(13).FindControl("ContactEmail"), TextBox)
Dim Contact_Email As String = GetContactEmail.Text
If checkValueApproved.SelectedValue = "True" Then
Dim dbConn As OleDbConnection
Dim dbInsert As New OleDbCommand
Dim dbCommand As OleDbDataAdapter
Dim dsCheckApproval As New DataSet
Dim DateOfPosting As DateTime = DateTime.Now
dbConn = New OleDbConnection("Provider=" _
& "Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("../App_Data/NAAAHR_Chicago.mdb;"))
dbCommand = New OleDbDataAdapter _
("Select NeedApproving, Approval, EmailSent, EmailSentDate, ContactEmail from " _
& "Jobs Where NeedApproving = True AND Approval = True AND EmailSent= False AND ID = " & ID_Value, dbConn)
dbCommand.Fill(dsCheckApproval, "Jobs")
If dsCheckApproval.Tables("Jobs").Rows.Count = 1 Then
'Contact_Email = dsCheckApproval.Tables("Jobs").Rows(0).Item("ContactEmail").ToString()
dbInsert.CommandText = "Update Jobs" & _
" SET NeedApproving = False, EmailSent = True, EmailSentDate = '" & DateOfPosting.ToShortDateString & "'" & _
" WHERE ID = " & ID_Value
dbInsert.Connection = dbConn
dbInsert.Connection.Open()
dbInsert.ExecuteNonQuery()
' Create Parameter objects to represent the fields to update and
' add the Parameter objects to the UpdateParameters collection.
Dim NeedApprovingParameter As New Parameter("NeedApproving", TypeCode.Boolean, False)
Dim EmailSentParameter As New Parameter("EmailSent", TypeCode.Boolean, True)
AccessDataSource1.UpdateParameters.Clear()
AccessDataSource1.UpdateParameters.Add(NeedApprovingParameter)
AccessDataSource1.UpdateParameters.Add(EmailSentParameter)
end sud
********************************************************
Here is the Grid and accessdatasource
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
OnRowUpdating="ReportGrid_Update" DataSourceID="AccessDataSource1" Font-Size="Small"
AllowPaging="True" AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="None">
<Columns>
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="Edit" Text="Edit" />
<asp:LinkButton ID="LinkButton2" runat="server" CommandName="Delete" Text="Delete" OnClientClick="return confirm('Are you certain you want to delete thisrod record?');" />
</ItemTemplate>
<EditItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="Server" CommandName="Update" Text="Update" />
<asp:LinkButton ID="LinkButton2" runat="server" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="JobTitle" HeaderText="JobTitle" SortExpression="JobTitle" />
<asp:BoundField DataField="JobDescription" HeaderText="JobDescription" SortExpression="JobDescription" />
<asp:BoundField DataField="JobCategory" HeaderText="JobCategory" SortExpression="JobCategory" />
<asp:BoundField DataField="Location" HeaderText="Location" SortExpression="Location" />
<asp:BoundField DataField="Education" HeaderText="Education" SortExpression="Education" />
<asp:BoundField DataField="Skills" HeaderText="Skills" SortExpression="Skills" />
<asp:BoundField DataField="Salary" HeaderText="Salary" SortExpression="Salary" />
<asp:BoundField DataField="EmploymentType" HeaderText="EmploymentType" SortExpression="EmploymentType" />
<asp:BoundField DataField="Travel" HeaderText="Travel" SortExpression="Travel" />
<asp:BoundField DataField="Company" HeaderText="Company" SortExpression="Company" />
<asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />
<asp:TemplateField HeaderText="ContactEmail" SortExpression="ContactEmail">
<EditItemTemplate>
<asp:TextBox ID="ContactEmail" runat="server" Text='<%# Bind("ContactEmail") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("ContactEmail") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ContactAddress" HeaderText="ContactAddress" SortExpression="ContactAddress" />
<asp:BoundField DataField="ContactPhone" HeaderText="ContactPhone" SortExpression="ContactPhone" />
<asp:BoundField DataField="DatePosted" HeaderText="DatePosted" SortExpression="DatePosted" />
<asp:BoundField DataField="Expires" HeaderText="Expires" SortExpression="Expires" />
<asp:TemplateField HeaderText="NeedApproving" SortExpression="NeedApproving">
<EditItemTemplate>
<asp:CheckBox ID="NeedApproving" runat="server" Checked='<%# Bind("NeedApproving") %>' />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="NeedApproving" runat="server" Checked='<%# Bind("NeedApproving") %>'
Enabled="false" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Approval" SortExpression="Approval">
<ItemTemplate>
<asp:RadioButtonList ID="ApprovalChoice" runat="server" Enabled="false" SelectedValue='<%# Bind("Approval") %>'>
<asp:ListItem Value="True">Approval</asp:ListItem>
<asp:ListItem Value="False">Disapproved</asp:ListItem>
</asp:RadioButtonList>
</ItemTemplate>
<EditItemTemplate>
<asp:RadioButtonList ID="ApprovalChoice" runat="server" SelectedValue='<%# Bind("Approval") %>'>
<asp:ListItem Value="True">Approval</asp:ListItem>
<asp:ListItem Value="False">Disapproved</asp:ListItem>
</asp:RadioButtonList>
</EditItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="URL" HeaderText="URL" SortExpression="URL" />
<asp:CheckBoxField DataField="ContactDisplay" HeaderText="ContactDisplay" SortExpression="ContactDisplay" />
<asp:TemplateField HeaderText="EmailSent" SortExpression="EmailSent">
<EditItemTemplate>
<asp:CheckBox ID="EmailSent" runat="server" Checked='<%# Bind("EmailSent") %>' />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="EmailSent" runat="server" Checked='<%# Bind("EmailSent") %>' Enabled="false" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="EmailSentDate" HeaderText="EmailSentDate" SortExpression="EmailSentDate" />
</Columns>
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#E3EAEB" />
<EditRowStyle BackColor="#7C6F57" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="Gray" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/NAAAHR_Chicago.mdb"
DeleteCommand="DELETE FROM [Jobs] WHERE [ID] = ?"
SelectCommand="SELECT * FROM [Jobs]" UpdateCommand="UPDATE [Jobs] SET [NeedApproving] = ?, [EmailSent] = ?, [JobTitle] = ?, [JobDescription] = ?, [JobCategory] = ?, [Location] = ?, [Education] = ?, [Skills] = ?, [Salary] = ?, [EmploymentType] = ?, [Travel] = ?, [Company] = ?, [ContactName] = ?, [ContactEmail] = ?, [ContactAddress] = ?, [ContactPhone] = ?, [DatePosted] = ?, [Expires] = ?, [Approval] = ?, = ?, [ContactDisplay] = ?, [Email... </asp:AccessDataSource>