dataAdapter.Upd ate(data, "TableName" ) won’t work!

[hch]

dataAdapter.Upd ate(data, "TableName" ) won’t work!
I was about to deploy my first website on the Internet only to discover that
the dataAdapter.Upd ate() throws the Server Error in the third underline. It
was working fine before.
ConnectionStrin g in Web.config:
-----------------------------------------
<?xml version="1.0" encoding="utf-8" ?>
<configuratio n>
<appSettings>
<add key="Connection String" value="Provider =Microsoft.Jet. OLEDB.4.0;Ole DB
Services=-4;Data Source=C:\datab ases\Resume1.md b" />

Code in LogOut.aspx.vb
-----------------------------------------
Dim queryString As String
Dim data As New DataSet
Dim dbConnection As OleDbConnection
Dim dataAdapter As OleDbDataAdapte r
Dim connectionStrin g As String =
ConfigurationSe ttings.AppSetti ngs("Connection String")
queryString = "SELECT * FROM tblApplicLog"
dbConnection = New OleDbConnection (connectionStri ng)
dataAdapter = New OleDbDataAdapte r(queryString, dbConnection)
dataAdapter.Fil l(data, "tblApplicL og")
Dim table As DataTable
table = data.Tables("tb lApplicLog")
Dim selectedRows() As DataRow
Dim i As Integer = Application("iL astVisitTot")
selectedRows = table.Select("A plTotVisits = " & i)
If selectedRows.Le ngth > 0 Then
selectedRows(0) .Item("AplTotVi sits") = Application("iV isitTot")
+ 1
End If

Dim commandBuilder As OleDbCommandBui lder
commandBuilder = New OleDbCommandBui lder(dataAdapte r)
dataAdapter.Upd ateCommand = commandBuilder. GetUpdateComman d
dataAdapter.Upd ate(data, "tblApplicL og")
dbConnection.Cl ose()

Server Error in '/Resume2' Application.
--------------------------------------------------------------------------------

Operation must use an updateable query.
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.Ole Db.OleDbExcepti on: Operation must use an
updateable query.

Source Error:
Line 214: commandBuilder = New OleDbCommandBui lder(dataAdapte r)
Line 215: dataAdapter.Upd ateCommand = commandBuilder. GetUpdateComman d
Line 216: dataAdapter.Upd ate(data, "tblApplicL og")
Line 217: dbConnection.Cl ose()
Line 218:
Source File: c:\inetpub\wwwr oot\Resume2\Log Out.aspx.vb Line: 216

Stack Trace:
[OleDbException (0x80004005): Operation must use an updateable query.]
System.Data.Com mon.DbDataAdapt er.Update(DataR ow[] dataRows,
DataTableMappin g tableMapping)
System.Data.Com mon.DbDataAdapt er.Update(DataS et dataSet, String srcTable)
Resume2.LogOut. lbtClose_Click( Object sender, EventArgs e) in
c:\inetpub\wwwr oot\Resume2\Log Out.aspx.vb:216
System.Web.UI.W ebControls.Link Button.OnClick( EventArgs e)

System.Web.UI.W ebControls.Link Button.System.W eb.UI.IPostBack EventHandler.Ra isePostBackEven t(String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain()
Please help – Henry

[Cor Ligthert]

hch,

Although this one is not needed, is my question what data is there in
"data"?
(In other words how did you fill or save that during the post and postback?)

dataAdapter.Upd ateCommand = commandBuilder. GetUpdateComman d

This one is not needed the command is already there because of the way you
do it.

Cor

[W.G. Ryan eMVP]

The typical problmes are that 1) You don't have a Primary Key on the table
(not likely based on the current symptoms) 2) You don't have write
permissions (most likely). Verify that you can modify items in the db and
that you have write permissions, in an ASP.NET app, 98% of the time this
symptom is the result of permissions.

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"hch" <hc*@discussion s.microsoft.com > wrote in message
news:2B******** *************** ***********@mic rosoft.com...

dataAdapter.Upd ate(data, "TableName" ) won't work!
I was about to deploy my first website on the Internet only to discover
that
the dataAdapter.Upd ate() throws the Server Error in the third underline.
It
was working fine before.
ConnectionStrin g in Web.config:
-----------------------------------------
<?xml version="1.0" encoding="utf-8" ?>
<configuratio n>
<appSettings>
<add key="Connection String" value="Provider =Microsoft.Jet. OLEDB.4.0;Ole DB
Services=-4;Data Source=C:\datab ases\Resume1.md b" />

Code in LogOut.aspx.vb
-----------------------------------------
Dim queryString As String
Dim data As New DataSet
Dim dbConnection As OleDbConnection
Dim dataAdapter As OleDbDataAdapte r
Dim connectionStrin g As String =
ConfigurationSe ttings.AppSetti ngs("Connection String")
queryString = "SELECT * FROM tblApplicLog"
dbConnection = New OleDbConnection (connectionStri ng)
dataAdapter = New OleDbDataAdapte r(queryString, dbConnection)
dataAdapter.Fil l(data, "tblApplicL og")
Dim table As DataTable
table = data.Tables("tb lApplicLog")
Dim selectedRows() As DataRow
Dim i As Integer = Application("iL astVisitTot")
selectedRows = table.Select("A plTotVisits = " & i)
If selectedRows.Le ngth > 0 Then
selectedRows(0) .Item("AplTotVi sits") = Application("iV isitTot")
+ 1
End If

Dim commandBuilder As OleDbCommandBui lder
commandBuilder = New OleDbCommandBui lder(dataAdapte r)
dataAdapter.Upd ateCommand = commandBuilder. GetUpdateComman d
dataAdapter.Upd ate(data, "tblApplicL og")
dbConnection.Cl ose()

Server Error in '/Resume2' Application.
--------------------------------------------------------------------------------

Operation must use an updateable query.
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.Ole Db.OleDbExcepti on: Operation must use an
updateable query.

Source Error:
Line 214: commandBuilder = New OleDbCommandBui lder(dataAdapte r)
Line 215: dataAdapter.Upd ateCommand =
commandBuilder. GetUpdateComman d
Line 216: dataAdapter.Upd ate(data, "tblApplicL og")
Line 217: dbConnection.Cl ose()
Line 218:
Source File: c:\inetpub\wwwr oot\Resume2\Log Out.aspx.vb Line: 216

Stack Trace:
[OleDbException (0x80004005): Operation must use an updateable query.]
System.Data.Com mon.DbDataAdapt er.Update(DataR ow[] dataRows,
DataTableMappin g tableMapping)
System.Data.Com mon.DbDataAdapt er.Update(DataS et dataSet, String
srcTable)
Resume2.LogOut. lbtClose_Click( Object sender, EventArgs e) in
c:\inetpub\wwwr oot\Resume2\Log Out.aspx.vb:216
System.Web.UI.W ebControls.Link Button.OnClick( EventArgs e)

System.Web.UI.W ebControls.Link Button.System.W eb.UI.IPostBack EventHandler.Ra isePostBackEven t(String
eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain()
Please help - Henry