RE: Datatable Update method not updating

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hello Flomo,

In general, ADO.net will check if the original value exists in the
underlying database, and then update the current value to database.

What does the update SQL statement looks like in your application?
Additionally, have you check the original version value?

I'd like to recommend SQL Profile tool to diagnose such issue, if
underlying database is SQL server.
1, open SQL Profile
2, create a new trace
3, start trace.
4, reproduce the issue (Modify the dataset and update the dataset to
underlying database)
5, stop the trace
6, save the trace log as .trc file

Would you please post the trace log in the newsgroup? Thus, we will perform
further analyze.

Have a great day,
Best regards,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.



Relevant Pages

  • Re: Simple timeout problem
    ... Brian, I haven't found anything specific on this error. ... We'd want to limit the trace to just the BizTalkRuleEngineDB. ... To run a trace go to SQL Profiler (under the SQL Server entry in the start ... | are reporting a timeout condition trying to connect to the SQL database. ...
    (microsoft.public.biztalk.general)
  • Re: Profiler Bug viewing trace flat file?
    ... Kalen Delaney, SQL Server MVP ... Run this code to create a trace capture of the RPC:Complete event: ... declare @error INT ... Now open the trace file in Profiler and you will see that the Textdata ...
    (microsoft.public.sqlserver.tools)
  • Re: How to look at parameter string
    ... I am tracing, but the problem I can't trace (at least, I haven't figured out ... string it is putting together to send to Sql. ... >> The problem is not coming from Sql Server but from my page. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Auditing sql server at runtime
    ... Use SQL Profiler to define your trace, ... User sp_procoption to mark the stored procedure for autoexecution when the SQL Server is restarted. ...
    (microsoft.public.sqlserver.clients)
  • I asked about DBI tracing a while ago
    ... A while ago I asked a question about how do I trace what SQL queries ... (please do not mention setting trace on on DBI, it does not do what I ... to speed it up 3 times by using better SQL and calling SQL less often. ... sub prepare { ...
    (comp.lang.perl.misc)