Re: Is there a way to "step into" the dataadapter.update command?

From: Michael O'Brien (michael_c_obrien_at_no-spam-hotmail.com)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 14:44:55 +0100

Hi,

if you're using SQL server, the SQL Profiler tool will let you trace what
commands are being executed, and the parameters being used.

cheers
Michael

"Big Dave" <david.wade@raymondjames.com> wrote in message
news:bc773cf0.0410010538.626a5730@posting.google.com...
> I'm having trouble using the update command of a dataadapter. It
> would help if I could watch it go through each record in the datatable
> and see what it's doing. Is there a way to do this? Also, is there a
> way to see the actual sql statements it's executing, with the value of
> the parameters, for each update it performs?
>
> Thanks for any help you can offer.

Relevant Pages

  • Re: Millions of Delete Statements
    ... You mention a cursor. ... Others have mentioned batching the commands, ... so I will throw out one that is less good (executing them ... get the whole SQL statement I don't know of another way to do it). ...
    (comp.databases.ms-sqlserver)
  • Re: Mixing select and print statements using DBI, DBD::Sybase
    ... Isql does not have its own commands. ... in the sql batch has the print executing later. ...
    (perl.dbi.users)
  • Re: How I can sysnchronize changes in DataTable with my Database?
    ... Do you mean whether ADO .NET can generate the commands for you? ... Does your question actually mean "I don't want to bother with all that SQL. ... >>> DataTableMapping tableMapping) ... >>> foreach(DataRow myDataRow in myDataTable.Rows) ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Post Revised: A Desperate Plea for Help
    ... I got your point that generated sql is often inadequate. ... generated commands may be inadequate" but "Use the dataadapter's Update ... That's why my advice was to call the data adapter's Update method. ... But the bottom line here is that you need to create the SQL Statements ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DataGrid problem.
    ... (and SQL) ... as well as the Insert and Update commands? ... > dataAdapters sql commands parameters Value field, ... >> to the grid, it is automatically assigned a NULL value when a new row is ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)