Ayuda con Formview VB 2005 = Data type mismatch in criteria expression

19/04/2010 - 21:15 por SamUdjat | Informe spam
Hola,

estoy utilizando un foamview para escribir en una base de datos de Access y
me regresa el siguiente error: (incluyo error mas el source code)

Gracias adelantadas...


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.ExecuteCommandTextErrorHandling(OleDbHResult
hr) +1003520

System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +255
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
+188
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult) +58
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) +161
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand
command, DataSourceOperation operation) +386
System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary
values) +227
System.Web.UI.DataSourceView.Insert(IDictionary values,
DataSourceViewOperationCallback callback) +86
System.Web.UI.WebControls.FormView.HandleInsert(String commandArg,
Boolean causesValidation) +272
System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean
causesValidation, String validationGroup) +676
System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs
e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source,
EventArgs e) +113
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
eventArgument) +135

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.Rai
sePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565



<asp:Panel ID="Panel2" runat="server">
&nbsp;
<asp:FormView ID="FormView2" runat="server"
DataKeyNames="encounter_id" DataSourceID="AccessDataSource3"
DefaultMode="Insert">
<EditItemTemplate>
encounter_id:
<asp:Label ID="encounter_idLabel1" runat="server"
Text='<%# Eval("encounter_id") %>'>
</asp:Label><br />
med_rec_num:
<asp:TextBox ID="med_rec_numTextBox" runat="server"
Text='<%# Bind("med_rec_num") %>'>
</asp:TextBox><br />
encounter_date:
<asp:TextBox ID="encounter_dateTextBox" runat="server"
Text='<%# Bind("encounter_date") %>'>
</asp:TextBox><br />
type_visit:
<asp:TextBox ID="type_visitTextBox" runat="server"
Text='<%# Bind("type_visit") %>'>
</asp:TextBox><br />
attended_by:
<asp:TextBox ID="attended_byTextBox" runat="server"
Text='<%# Bind("attended_by") %>'>
</asp:TextBox><br />
received_amt:
<asp:TextBox ID="received_amtTextBox" runat="server"
Text='<%# Bind("received_amt") %>'>
</asp:TextBox><br />
details:
<asp:TextBox ID="detailsTextBox" runat="server"
Text='<%# Bind("details") %>'>
</asp:TextBox><br />
payment_type:
<asp:TextBox ID="payment_typeTextBox" runat="server"
Text='<%# Bind("payment_type") %>'>
</asp:TextBox><br />
billing_not_req:
<asp:TextBox ID="billing_not_reqTextBox" runat="server"
Text='<%# Bind("billing_not_req") %>'>
</asp:TextBox><br />
note_for_biller:
<asp:TextBox ID="note_for_billerTextBox" runat="server"
Text='<%# Bind("note_for_biller") %>'>
</asp:TextBox><br />
chief_complaint:
<asp:TextBox ID="chief_complaintTextBox" runat="server"
Text='<%# Bind("chief_complaint") %>'>
</asp:TextBox><br />
present_illness:
<asp:TextBox ID="present_illnessTextBox" runat="server"
Text='<%# Bind("present_illness") %>'>
</asp:TextBox><br />
location:
<asp:TextBox ID="locationTextBox" runat="server"
Text='<%# Bind("location") %>'>
</asp:TextBox><br />
quantity:
<asp:TextBox ID="quantityTextBox" runat="server"
Text='<%# Bind("quantity") %>'>
</asp:TextBox><br />
severity:
<asp:TextBox ID="severityTextBox" runat="server"
Text='<%# Bind("severity") %>'>
</asp:TextBox><br />
duration:
<asp:TextBox ID="durationTextBox" runat="server"
Text='<%# Bind("duration") %>'>
</asp:TextBox><br />
onset_timing:
<asp:TextBox ID="onset_timingTextBox" runat="server"
Text='<%# Bind("onset_timing") %>'>
</asp:TextBox><br />
context:
<asp:TextBox ID="contextTextBox" runat="server"
Text='<%# Bind("context") %>'>
</asp:TextBox><br />
modifying_factor:
<asp:TextBox ID="modifying_factorTextBox" runat="server"
Text='<%# Bind("modifying_factor") %>'>
</asp:TextBox><br />
signs_symtoms:
<asp:TextBox ID="signs_symtomsTextBox" runat="server"
Text='<%# Bind("signs_symtoms") %>'>
</asp:TextBox><br />
blood_press:
<asp:TextBox ID="blood_pressTextBox" runat="server"
Text='<%# Bind("blood_press") %>'>
</asp:TextBox><br />
pulse_rate:
<asp:TextBox ID="pulse_rateTextBox" runat="server"
Text='<%# Bind("pulse_rate") %>'>
</asp:TextBox><br />
resp_rate:
<asp:TextBox ID="resp_rateTextBox" runat="server"
Text='<%# Bind("resp_rate") %>'>
</asp:TextBox><br />
temp:
<asp:TextBox ID="tempTextBox" runat="server" Text='<%#
Bind("temp") %>'>
</asp:TextBox><br />
weight:
<asp:TextBox ID="weightTextBox" runat="server" Text='<%#
Bind("weight") %>'>
</asp:TextBox><br />
heart_rate:
<asp:TextBox ID="heart_rateTextBox" runat="server"
Text='<%# Bind("heart_rate") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server"
CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
med_rec_num:
<asp:TextBox ID="med_rec_numTextBox" runat="server"
Text='<%# Bind("med_rec_num") %>'>
</asp:TextBox><br />
encounter_date:
<asp:TextBox ID="encounter_dateTextBox" runat="server"
Text='<%# Bind("encounter_date") %>'>
</asp:TextBox><br />
type_visit:
<asp:TextBox ID="type_visitTextBox" runat="server"
Text='<%# Bind("type_visit") %>'>
</asp:TextBox><br />
attended_by:
<asp:TextBox ID="attended_byTextBox" runat="server"
Text='<%# Bind("attended_by") %>'>
</asp:TextBox><br />
received_amt:
<asp:TextBox ID="received_amtTextBox" runat="server"
Text='<%# Bind("received_amt") %>'>
</asp:TextBox><br />
details:
<asp:TextBox ID="detailsTextBox" runat="server"
Text='<%# Bind("details") %>'>
</asp:TextBox><br />
payment_type:
<asp:TextBox ID="payment_typeTextBox" runat="server"
Text='<%# Bind("payment_type") %>'>
</asp:TextBox><br />
billing_not_req:
<asp:TextBox ID="billing_not_reqTextBox" runat="server"
Text='<%# Bind("billing_not_req") %>'>
</asp:TextBox><br />
note_for_biller:
<asp:TextBox ID="note_for_billerTextBox" runat="server"
Text='<%# Bind("note_for_biller") %>'>
</asp:TextBox><br />
chief_complaint:
<asp:TextBox ID="chief_complaintTextBox" runat="server"
Text='<%# Bind("chief_complaint") %>'>
</asp:TextBox><br />
present_illness:
<asp:TextBox ID="present_illnessTextBox" runat="server"
Text='<%# Bind("present_illness") %>'>
</asp:TextBox><br />
location:
<asp:TextBox ID="locationTextBox" runat="server"
Text='<%# Bind("location") %>'>
</asp:TextBox><br />
quantity:
<asp:TextBox ID="quantityTextBox" runat="server"
Text='<%# Bind("quantity") %>'>
</asp:TextBox><br />
severity:
<asp:TextBox ID="severityTextBox" runat="server"
Text='<%# Bind("severity") %>'>
</asp:TextBox><br />
duration:
<asp:TextBox ID="durationTextBox" runat="server"
Text='<%# Bind("duration") %>'>
</asp:TextBox><br />
onset_timing:
<asp:TextBox ID="onset_timingTextBox" runat="server"
Text='<%# Bind("onset_timing") %>'>
</asp:TextBox><br />
context:
<asp:TextBox ID="contextTextBox" runat="server"
Text='<%# Bind("context") %>'>
</asp:TextBox><br />
modifying_factor:
<asp:TextBox ID="modifying_factorTextBox" runat="server"
Text='<%# Bind("modifying_factor") %>'>
</asp:TextBox><br />
signs_symtoms:
<asp:TextBox ID="signs_symtomsTextBox" runat="server"
Text='<%# Bind("signs_symtoms") %>'>
</asp:TextBox><br />
blood_press:
<asp:TextBox ID="blood_pressTextBox" runat="server"
Text='<%# Bind("blood_press") %>'>
</asp:TextBox><br />
pulse_rate:
<asp:TextBox ID="pulse_rateTextBox" runat="server"
Text='<%# Bind("pulse_rate") %>'>
</asp:TextBox><br />
resp_rate:
<asp:TextBox ID="resp_rateTextBox" runat="server"
Text='<%# Bind("resp_rate") %>'>
</asp:TextBox><br />
temp:
<asp:TextBox ID="tempTextBox" runat="server" Text='<%#
Bind("temp") %>'>
</asp:TextBox><br />
weight:
<asp:TextBox ID="weightTextBox" runat="server" Text='<%#
Bind("weight") %>'>
</asp:TextBox><br />
heart_rate:
<asp:TextBox ID="heart_rateTextBox" runat="server"
Text='<%# Bind("heart_rate") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server"
CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
encounter_id:
<asp:Label ID="encounter_idLabel" runat="server"
Text='<%# Eval("encounter_id") %>'>
</asp:Label><br />
med_rec_num:
<asp:Label ID="med_rec_numLabel" runat="server"
Text='<%# Bind("med_rec_num") %>'>
</asp:Label><br />
encounter_date:
<asp:Label ID="encounter_dateLabel" runat="server"
Text='<%# Bind("encounter_date") %>'>
</asp:Label><br />
type_visit:
<asp:Label ID="type_visitLabel" runat="server" Text='<%#
Bind("type_visit") %>'>
</asp:Label><br />
attended_by:
<asp:Label ID="attended_byLabel" runat="server"
Text='<%# Bind("attended_by") %>'>
</asp:Label><br />
received_amt:
<asp:Label ID="received_amtLabel" runat="server"
Text='<%# Bind("received_amt") %>'>
</asp:Label><br />
details:
<asp:Label ID="detailsLabel" runat="server" Text='<%#
Bind("details") %>'></asp:Label><br />
payment_type:
<asp:Label ID="payment_typeLabel" runat="server"
Text='<%# Bind("payment_type") %>'>
</asp:Label><br />
billing_not_req:
<asp:Label ID="billing_not_reqLabel" runat="server"
Text='<%# Bind("billing_not_req") %>'>
</asp:Label><br />
note_for_biller:
<asp:Label ID="note_for_billerLabel" runat="server"
Text='<%# Bind("note_for_biller") %>'>
</asp:Label><br />
chief_complaint:
<asp:Label ID="chief_complaintLabel" runat="server"
Text='<%# Bind("chief_complaint") %>'>
</asp:Label><br />
present_illness:
<asp:Label ID="present_illnessLabel" runat="server"
Text='<%# Bind("present_illness") %>'>
</asp:Label><br />
location:
<asp:Label ID="locationLabel" runat="server" Text='<%#
Bind("location") %>'></asp:Label><br />
quantity:
<asp:Label ID="quantityLabel" runat="server" Text='<%#
Bind("quantity") %>'></asp:Label><br />
severity:
<asp:Label ID="severityLabel" runat="server" Text='<%#
Bind("severity") %>'></asp:Label><br />
duration:
<asp:Label ID="durationLabel" runat="server" Text='<%#
Bind("duration") %>'></asp:Label><br />
onset_timing:
<asp:Label ID="onset_timingLabel" runat="server"
Text='<%# Bind("onset_timing") %>'>
</asp:Label><br />
context:
<asp:Label ID="contextLabel" runat="server" Text='<%#
Bind("context") %>'></asp:Label><br />
modifying_factor:
<asp:Label ID="modifying_factorLabel" runat="server"
Text='<%# Bind("modifying_factor") %>'>
</asp:Label><br />
signs_symtoms:
<asp:Label ID="signs_symtomsLabel" runat="server"
Text='<%# Bind("signs_symtoms") %>'>
</asp:Label><br />
blood_press:
<asp:Label ID="blood_pressLabel" runat="server"
Text='<%# Bind("blood_press") %>'>
</asp:Label><br />
pulse_rate:
<asp:Label ID="pulse_rateLabel" runat="server" Text='<%#
Bind("pulse_rate") %>'>
</asp:Label><br />
resp_rate:
<asp:Label ID="resp_rateLabel" runat="server" Text='<%#
Bind("resp_rate") %>'></asp:Label><br />
temp:
<asp:Label ID="tempLabel" runat="server" Text='<%#
Bind("temp") %>'></asp:Label><br />
weight:
<asp:Label ID="weightLabel" runat="server" Text='<%#
Bind("weight") %>'></asp:Label><br />
heart_rate:
<asp:Label ID="heart_rateLabel" runat="server" Text='<%#
Bind("heart_rate") %>'>
</asp:Label><br />
<asp:LinkButton ID="EditButton" runat="server"
CausesValidation="False" CommandName="Edit"
Text="Edit">
</asp:LinkButton>
<asp:LinkButton ID="DeleteButton" runat="server"
CausesValidation="False" CommandName="Delete"
Text="Delete">
</asp:LinkButton>
<asp:LinkButton ID="NewButton" runat="server"
CausesValidation="False" CommandName="New"
Text="New">
</asp:LinkButton>
</ItemTemplate>
</asp:FormView>
</asp:Panel>

</div>
<asp:AccessDataSource ID="AccessDataSource3" runat="server"
DataFile="~/App_Data/EMR.mdb"
SelectCommand="SELECT * FROM [Encounters]" DeleteCommand="DELETE
FROM [Encounters] WHERE [encounter_id] = ?" InsertCommand="INSERT INTO
[Encounters] ( [med_rec_num], [encounter_date], [type_visit], [attended_by],
[received_amt], [details], [payment_type], [billing_not_req],
[note_for_biller], [chief_complaint], [present_illness], [location],
[quantity], [severity], [duration], [onset_timing], [context],
[modifying_factor], [signs_symtoms], [blood_press], [pulse_rate],
[resp_rate], [temp], [weight], [heart_rate]) VALUES ( ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" UpdateCommand="UPDATE
[Encounters] SET [med_rec_num] = ?, [encounter_date] = ?, [type_visit] = ?,
[attended_by] = ?, [received_amt] = ?, [details] = ?, [payment_type] = ?,
[billing_not_req] = ?, [note_for_biller] = ?, [chief_complaint] = ?,
[present_illness] = ?, [location] = ?, [quantity] = ?, [severity] = ?,
[duration] = ?, [onset_timing] = ?, [context] = ?, [modifying_factor] = ?,
[signs_symtoms] = ?, [blood_press] = ?, [pulse_rate] = ?, [resp_rate] = ?,
[temp] = ?, [weight] = ?, [heart_rate] = ? WHERE [encounter_id] = ?">
<DeleteParameters>
<asp:Parameter Name="encounter_id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="med_rec_num" Type="Int32" />
<asp:Parameter Name="encounter_date" Type="DateTime" />
<asp:Parameter Name="type_visit" Type="String" />
<asp:Parameter Name="attended_by" Type="String" />
<asp:Parameter Name="received_amt" Type=Decimal />
<asp:Parameter Name="details" Type="String" />
<asp:Parameter Name="payment_type" Type="String" />
<asp:Parameter Name="billing_not_req" Type="String" />
<asp:Parameter Name="note_for_biller" Type="String" />
<asp:Parameter Name="chief_complaint" Type="String" />
<asp:Parameter Name="present_illness" Type="String" />
<asp:Parameter Name="location" Type="String" />
<asp:Parameter Name="quantity" Type="String" />
<asp:Parameter Name="severity" Type="String" />
<asp:Parameter Name="duration" Type="String" />
<asp:Parameter Name="onset_timing" Type="String" />
<asp:Parameter Name="context" Type="String" />
<asp:Parameter Name="modifying_factor" Type="String" />
<asp:Parameter Name="signs_symtoms" Type="String" />
<asp:Parameter Name="blood_press" Type="String" />
<asp:Parameter Name="pulse_rate" Type="String" />
<asp:Parameter Name="resp_rate" Type="String" />
<asp:Parameter Name="temp" Type="String" />
<asp:Parameter Name="weight" Type="String" />
<asp:Parameter Name="heart_rate" Type="String" />
<asp:Parameter Name="encounter_id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="encounter_id" Type="Int32" />
<asp:Parameter Name="med_rec_num" Type="Int32" />
<asp:Parameter Name="encounter_date" Type="DateTime" />
<asp:Parameter Name="type_visit" Type="String" />
<asp:Parameter Name="attended_by" Type="String" />
<asp:Parameter Name="received_amt" Type=Decimal />
<asp:Parameter Name="details" Type="String" />
<asp:Parameter Name="payment_type" Type="String" />
<asp:Parameter Name="billing_not_req" Type="String" />
<asp:Parameter Name="note_for_biller" Type="String" />
<asp:Parameter Name="chief_complaint" Type="String" />
<asp:Parameter Name="present_illness" Type="String" />
<asp:Parameter Name="location" Type="String" />
<asp:Parameter Name="quantity" Type="String" />
<asp:Parameter Name="severity" Type="String" />
<asp:Parameter Name="duration" Type="String" />
<asp:Parameter Name="onset_timing" Type="String" />
<asp:Parameter Name="context" Type="String" />
<asp:Parameter Name="modifying_factor" Type="String" />
<asp:Parameter Name="signs_symtoms" Type="String" />
<asp:Parameter Name="blood_press" Type="String" />
<asp:Parameter Name="pulse_rate" Type="String" />
<asp:Parameter Name="resp_rate" Type="String" />
<asp:Parameter Name="temp" Type="String" />
<asp:Parameter Name="weight" Type="String" />
<asp:Parameter Name="heart_rate" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</form>
</body>
</html>
 

Leer las respuestas

#1 Victor B.
20/04/2010 - 11:55 | Informe spam
El error puede estar en que alguno de los parámetros que le pasas a INSERT
no se corresponde con el tipo de datos que espera la tabla. Averigua si
coinciden los String, Integer, Decimal o DateTime. Me inclino, ya que usas
Access, que sea encounter_date o received_amt

Saludos.


Víctor B.
Desarrollador independiente
"SamUdjat" escribió en el mensaje
news:O52zeR$
Hola,

estoy utilizando un foamview para escribir en una base de datos de Access
y
me regresa el siguiente error: (incluyo error mas el source code)

Gracias adelantadas...


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.ExecuteCommandTextErrorHandling(OleDbHResult
hr) +1003520

System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +255
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
+188
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult) +58
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) +161
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand
command, DataSourceOperation operation) +386
System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary
values) +227
System.Web.UI.DataSourceView.Insert(IDictionary values,
DataSourceViewOperationCallback callback) +86
System.Web.UI.WebControls.FormView.HandleInsert(String commandArg,
Boolean causesValidation) +272
System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean
causesValidation, String validationGroup) +676
System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source,
EventArgs
e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
+37
System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source,
EventArgs e) +113
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
+37
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
eventArgument) +135

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.Rai
sePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565



<asp:Panel ID="Panel2" runat="server">
&nbsp;
<asp:FormView ID="FormView2" runat="server"
DataKeyNames="encounter_id" DataSourceID="AccessDataSource3"
DefaultMode="Insert">
<EditItemTemplate>
encounter_id:
<asp:Label ID="encounter_idLabel1" runat="server"
Text='<%# Eval("encounter_id") %>'>
</asp:Label><br />
med_rec_num:
<asp:TextBox ID="med_rec_numTextBox" runat="server"
Text='<%# Bind("med_rec_num") %>'>
</asp:TextBox><br />
encounter_date:
<asp:TextBox ID="encounter_dateTextBox" runat="server"
Text='<%# Bind("encounter_date") %>'>
</asp:TextBox><br />
type_visit:
<asp:TextBox ID="type_visitTextBox" runat="server"
Text='<%# Bind("type_visit") %>'>
</asp:TextBox><br />
attended_by:
<asp:TextBox ID="attended_byTextBox" runat="server"
Text='<%# Bind("attended_by") %>'>
</asp:TextBox><br />
received_amt:
<asp:TextBox ID="received_amtTextBox" runat="server"
Text='<%# Bind("received_amt") %>'>
</asp:TextBox><br />
details:
<asp:TextBox ID="detailsTextBox" runat="server"
Text='<%# Bind("details") %>'>
</asp:TextBox><br />
payment_type:
<asp:TextBox ID="payment_typeTextBox" runat="server"
Text='<%# Bind("payment_type") %>'>
</asp:TextBox><br />
billing_not_req:
<asp:TextBox ID="billing_not_reqTextBox" runat="server"
Text='<%# Bind("billing_not_req") %>'>
</asp:TextBox><br />
note_for_biller:
<asp:TextBox ID="note_for_billerTextBox" runat="server"
Text='<%# Bind("note_for_biller") %>'>
</asp:TextBox><br />
chief_complaint:
<asp:TextBox ID="chief_complaintTextBox" runat="server"
Text='<%# Bind("chief_complaint") %>'>
</asp:TextBox><br />
present_illness:
<asp:TextBox ID="present_illnessTextBox" runat="server"
Text='<%# Bind("present_illness") %>'>
</asp:TextBox><br />
location:
<asp:TextBox ID="locationTextBox" runat="server"
Text='<%# Bind("location") %>'>
</asp:TextBox><br />
quantity:
<asp:TextBox ID="quantityTextBox" runat="server"
Text='<%# Bind("quantity") %>'>
</asp:TextBox><br />
severity:
<asp:TextBox ID="severityTextBox" runat="server"
Text='<%# Bind("severity") %>'>
</asp:TextBox><br />
duration:
<asp:TextBox ID="durationTextBox" runat="server"
Text='<%# Bind("duration") %>'>
</asp:TextBox><br />
onset_timing:
<asp:TextBox ID="onset_timingTextBox" runat="server"
Text='<%# Bind("onset_timing") %>'>
</asp:TextBox><br />
context:
<asp:TextBox ID="contextTextBox" runat="server"
Text='<%# Bind("context") %>'>
</asp:TextBox><br />
modifying_factor:
<asp:TextBox ID="modifying_factorTextBox"
runat="server"
Text='<%# Bind("modifying_factor") %>'>
</asp:TextBox><br />
signs_symtoms:
<asp:TextBox ID="signs_symtomsTextBox" runat="server"
Text='<%# Bind("signs_symtoms") %>'>
</asp:TextBox><br />
blood_press:
<asp:TextBox ID="blood_pressTextBox" runat="server"
Text='<%# Bind("blood_press") %>'>
</asp:TextBox><br />
pulse_rate:
<asp:TextBox ID="pulse_rateTextBox" runat="server"
Text='<%# Bind("pulse_rate") %>'>
</asp:TextBox><br />
resp_rate:
<asp:TextBox ID="resp_rateTextBox" runat="server"
Text='<%# Bind("resp_rate") %>'>
</asp:TextBox><br />
temp:
<asp:TextBox ID="tempTextBox" runat="server" Text='<%#
Bind("temp") %>'>
</asp:TextBox><br />
weight:
<asp:TextBox ID="weightTextBox" runat="server"
Text='<%#
Bind("weight") %>'>
</asp:TextBox><br />
heart_rate:
<asp:TextBox ID="heart_rateTextBox" runat="server"
Text='<%# Bind("heart_rate") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server"
CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
med_rec_num:
<asp:TextBox ID="med_rec_numTextBox" runat="server"
Text='<%# Bind("med_rec_num") %>'>
</asp:TextBox><br />
encounter_date:
<asp:TextBox ID="encounter_dateTextBox" runat="server"
Text='<%# Bind("encounter_date") %>'>
</asp:TextBox><br />
type_visit:
<asp:TextBox ID="type_visitTextBox" runat="server"
Text='<%# Bind("type_visit") %>'>
</asp:TextBox><br />
attended_by:
<asp:TextBox ID="attended_byTextBox" runat="server"
Text='<%# Bind("attended_by") %>'>
</asp:TextBox><br />
received_amt:
<asp:TextBox ID="received_amtTextBox" runat="server"
Text='<%# Bind("received_amt") %>'>
</asp:TextBox><br />
details:
<asp:TextBox ID="detailsTextBox" runat="server"
Text='<%# Bind("details") %>'>
</asp:TextBox><br />
payment_type:
<asp:TextBox ID="payment_typeTextBox" runat="server"
Text='<%# Bind("payment_type") %>'>
</asp:TextBox><br />
billing_not_req:
<asp:TextBox ID="billing_not_reqTextBox" runat="server"
Text='<%# Bind("billing_not_req") %>'>
</asp:TextBox><br />
note_for_biller:
<asp:TextBox ID="note_for_billerTextBox" runat="server"
Text='<%# Bind("note_for_biller") %>'>
</asp:TextBox><br />
chief_complaint:
<asp:TextBox ID="chief_complaintTextBox" runat="server"
Text='<%# Bind("chief_complaint") %>'>
</asp:TextBox><br />
present_illness:
<asp:TextBox ID="present_illnessTextBox" runat="server"
Text='<%# Bind("present_illness") %>'>
</asp:TextBox><br />
location:
<asp:TextBox ID="locationTextBox" runat="server"
Text='<%# Bind("location") %>'>
</asp:TextBox><br />
quantity:
<asp:TextBox ID="quantityTextBox" runat="server"
Text='<%# Bind("quantity") %>'>
</asp:TextBox><br />
severity:
<asp:TextBox ID="severityTextBox" runat="server"
Text='<%# Bind("severity") %>'>
</asp:TextBox><br />
duration:
<asp:TextBox ID="durationTextBox" runat="server"
Text='<%# Bind("duration") %>'>
</asp:TextBox><br />
onset_timing:
<asp:TextBox ID="onset_timingTextBox" runat="server"
Text='<%# Bind("onset_timing") %>'>
</asp:TextBox><br />
context:
<asp:TextBox ID="contextTextBox" runat="server"
Text='<%# Bind("context") %>'>
</asp:TextBox><br />
modifying_factor:
<asp:TextBox ID="modifying_factorTextBox"
runat="server"
Text='<%# Bind("modifying_factor") %>'>
</asp:TextBox><br />
signs_symtoms:
<asp:TextBox ID="signs_symtomsTextBox" runat="server"
Text='<%# Bind("signs_symtoms") %>'>
</asp:TextBox><br />
blood_press:
<asp:TextBox ID="blood_pressTextBox" runat="server"
Text='<%# Bind("blood_press") %>'>
</asp:TextBox><br />
pulse_rate:
<asp:TextBox ID="pulse_rateTextBox" runat="server"
Text='<%# Bind("pulse_rate") %>'>
</asp:TextBox><br />
resp_rate:
<asp:TextBox ID="resp_rateTextBox" runat="server"
Text='<%# Bind("resp_rate") %>'>
</asp:TextBox><br />
temp:
<asp:TextBox ID="tempTextBox" runat="server" Text='<%#
Bind("temp") %>'>
</asp:TextBox><br />
weight:
<asp:TextBox ID="weightTextBox" runat="server"
Text='<%#
Bind("weight") %>'>
</asp:TextBox><br />
heart_rate:
<asp:TextBox ID="heart_rateTextBox" runat="server"
Text='<%# Bind("heart_rate") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server"
CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
encounter_id:
<asp:Label ID="encounter_idLabel" runat="server"
Text='<%# Eval("encounter_id") %>'>
</asp:Label><br />
med_rec_num:
<asp:Label ID="med_rec_numLabel" runat="server"
Text='<%# Bind("med_rec_num") %>'>
</asp:Label><br />
encounter_date:
<asp:Label ID="encounter_dateLabel" runat="server"
Text='<%# Bind("encounter_date") %>'>
</asp:Label><br />
type_visit:
<asp:Label ID="type_visitLabel" runat="server"
Text='<%#
Bind("type_visit") %>'>
</asp:Label><br />
attended_by:
<asp:Label ID="attended_byLabel" runat="server"
Text='<%# Bind("attended_by") %>'>
</asp:Label><br />
received_amt:
<asp:Label ID="received_amtLabel" runat="server"
Text='<%# Bind("received_amt") %>'>
</asp:Label><br />
details:
<asp:Label ID="detailsLabel" runat="server" Text='<%#
Bind("details") %>'></asp:Label><br />
payment_type:
<asp:Label ID="payment_typeLabel" runat="server"
Text='<%# Bind("payment_type") %>'>
</asp:Label><br />
billing_not_req:
<asp:Label ID="billing_not_reqLabel" runat="server"
Text='<%# Bind("billing_not_req") %>'>
</asp:Label><br />
note_for_biller:
<asp:Label ID="note_for_billerLabel" runat="server"
Text='<%# Bind("note_for_biller") %>'>
</asp:Label><br />
chief_complaint:
<asp:Label ID="chief_complaintLabel" runat="server"
Text='<%# Bind("chief_complaint") %>'>
</asp:Label><br />
present_illness:
<asp:Label ID="present_illnessLabel" runat="server"
Text='<%# Bind("present_illness") %>'>
</asp:Label><br />
location:
<asp:Label ID="locationLabel" runat="server" Text='<%#
Bind("location") %>'></asp:Label><br />
quantity:
<asp:Label ID="quantityLabel" runat="server" Text='<%#
Bind("quantity") %>'></asp:Label><br />
severity:
<asp:Label ID="severityLabel" runat="server" Text='<%#
Bind("severity") %>'></asp:Label><br />
duration:
<asp:Label ID="durationLabel" runat="server" Text='<%#
Bind("duration") %>'></asp:Label><br />
onset_timing:
<asp:Label ID="onset_timingLabel" runat="server"
Text='<%# Bind("onset_timing") %>'>
</asp:Label><br />
context:
<asp:Label ID="contextLabel" runat="server" Text='<%#
Bind("context") %>'></asp:Label><br />
modifying_factor:
<asp:Label ID="modifying_factorLabel" runat="server"
Text='<%# Bind("modifying_factor") %>'>
</asp:Label><br />
signs_symtoms:
<asp:Label ID="signs_symtomsLabel" runat="server"
Text='<%# Bind("signs_symtoms") %>'>
</asp:Label><br />
blood_press:
<asp:Label ID="blood_pressLabel" runat="server"
Text='<%# Bind("blood_press") %>'>
</asp:Label><br />
pulse_rate:
<asp:Label ID="pulse_rateLabel" runat="server"
Text='<%#
Bind("pulse_rate") %>'>
</asp:Label><br />
resp_rate:
<asp:Label ID="resp_rateLabel" runat="server" Text='<%#
Bind("resp_rate") %>'></asp:Label><br />
temp:
<asp:Label ID="tempLabel" runat="server" Text='<%#
Bind("temp") %>'></asp:Label><br />
weight:
<asp:Label ID="weightLabel" runat="server" Text='<%#
Bind("weight") %>'></asp:Label><br />
heart_rate:
<asp:Label ID="heart_rateLabel" runat="server"
Text='<%#
Bind("heart_rate") %>'>
</asp:Label><br />
<asp:LinkButton ID="EditButton" runat="server"
CausesValidation="False" CommandName="Edit"
Text="Edit">
</asp:LinkButton>
<asp:LinkButton ID="DeleteButton" runat="server"
CausesValidation="False" CommandName="Delete"
Text="Delete">
</asp:LinkButton>
<asp:LinkButton ID="NewButton" runat="server"
CausesValidation="False" CommandName="New"
Text="New">
</asp:LinkButton>
</ItemTemplate>
</asp:FormView>
</asp:Panel>

</div>
<asp:AccessDataSource ID="AccessDataSource3" runat="server"
DataFile="~/App_Data/EMR.mdb"
SelectCommand="SELECT * FROM [Encounters]"
DeleteCommand="DELETE
FROM [Encounters] WHERE [encounter_id] = ?" InsertCommand="INSERT INTO
[Encounters] ( [med_rec_num], [encounter_date], [type_visit],
[attended_by],
[received_amt], [details], [payment_type], [billing_not_req],
[note_for_biller], [chief_complaint], [present_illness], [location],
[quantity], [severity], [duration], [onset_timing], [context],
[modifying_factor], [signs_symtoms], [blood_press], [pulse_rate],
[resp_rate], [temp], [weight], [heart_rate]) VALUES ( ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
UpdateCommand="UPDATE
[Encounters] SET [med_rec_num] = ?, [encounter_date] = ?, [type_visit] =
?,
[attended_by] = ?, [received_amt] = ?, [details] = ?, [payment_type] = ?,
[billing_not_req] = ?, [note_for_biller] = ?, [chief_complaint] = ?,
[present_illness] = ?, [location] = ?, [quantity] = ?, [severity] = ?,
[duration] = ?, [onset_timing] = ?, [context] = ?, [modifying_factor] = ?,
[signs_symtoms] = ?, [blood_press] = ?, [pulse_rate] = ?, [resp_rate] = ?,
[temp] = ?, [weight] = ?, [heart_rate] = ? WHERE [encounter_id] = ?">
<DeleteParameters>
<asp:Parameter Name="encounter_id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="med_rec_num" Type="Int32" />
<asp:Parameter Name="encounter_date" Type="DateTime" />
<asp:Parameter Name="type_visit" Type="String" />
<asp:Parameter Name="attended_by" Type="String" />
<asp:Parameter Name="received_amt" Type=Decimal />
<asp:Parameter Name="details" Type="String" />
<asp:Parameter Name="payment_type" Type="String" />
<asp:Parameter Name="billing_not_req" Type="String" />
<asp:Parameter Name="note_for_biller" Type="String" />
<asp:Parameter Name="chief_complaint" Type="String" />
<asp:Parameter Name="present_illness" Type="String" />
<asp:Parameter Name="location" Type="String" />
<asp:Parameter Name="quantity" Type="String" />
<asp:Parameter Name="severity" Type="String" />
<asp:Parameter Name="duration" Type="String" />
<asp:Parameter Name="onset_timing" Type="String" />
<asp:Parameter Name="context" Type="String" />
<asp:Parameter Name="modifying_factor" Type="String" />
<asp:Parameter Name="signs_symtoms" Type="String" />
<asp:Parameter Name="blood_press" Type="String" />
<asp:Parameter Name="pulse_rate" Type="String" />
<asp:Parameter Name="resp_rate" Type="String" />
<asp:Parameter Name="temp" Type="String" />
<asp:Parameter Name="weight" Type="String" />
<asp:Parameter Name="heart_rate" Type="String" />
<asp:Parameter Name="encounter_id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="encounter_id" Type="Int32" />
<asp:Parameter Name="med_rec_num" Type="Int32" />
<asp:Parameter Name="encounter_date" Type="DateTime" />
<asp:Parameter Name="type_visit" Type="String" />
<asp:Parameter Name="attended_by" Type="String" />
<asp:Parameter Name="received_amt" Type=Decimal />
<asp:Parameter Name="details" Type="String" />
<asp:Parameter Name="payment_type" Type="String" />
<asp:Parameter Name="billing_not_req" Type="String" />
<asp:Parameter Name="note_for_biller" Type="String" />
<asp:Parameter Name="chief_complaint" Type="String" />
<asp:Parameter Name="present_illness" Type="String" />
<asp:Parameter Name="location" Type="String" />
<asp:Parameter Name="quantity" Type="String" />
<asp:Parameter Name="severity" Type="String" />
<asp:Parameter Name="duration" Type="String" />
<asp:Parameter Name="onset_timing" Type="String" />
<asp:Parameter Name="context" Type="String" />
<asp:Parameter Name="modifying_factor" Type="String" />
<asp:Parameter Name="signs_symtoms" Type="String" />
<asp:Parameter Name="blood_press" Type="String" />
<asp:Parameter Name="pulse_rate" Type="String" />
<asp:Parameter Name="resp_rate" Type="String" />
<asp:Parameter Name="temp" Type="String" />
<asp:Parameter Name="weight" Type="String" />
<asp:Parameter Name="heart_rate" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</form>
</body>
</html>


Preguntas similares