Re: dataadapter update special logic

I guess for the purposes of this, i can probably use a stored procedure (as
the requirements stand), i was just wondering about other options. Like
suppose i wanted to write the id out to a file when it was updated or
something. How would I go about doing that (i guess do somethign that's not
easily done via sql)?

Thanks for your help.

"Nicholas Paldino [.NET/C# MVP]" wrote:

> gl,
>
> Instead of coding the update call, why not create a stored procedure
> that does this, and then have the update command on your data adapter use
> that?
>
> Hope this helps.
>
>
> --
> - Nicholas Paldino [.NET/C# MVP]
> - mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> "gl" <gl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:9F20BE77-F348-45A2-98A1-EA493FA03C05@xxxxxxxxxxxxxxxx
> > I'm currently planning out a project and I wanted to make sure it's easy
> > to
> > do something (or at least possible). Basically we're going to have a grid
> > reporting off of dataset (with a relative dataadapter). My question
> > revolves
> > around the dataadapter's update ability. First of all the dataset will
> > contain multiple tables. Now when the Update method is called, there has
> > to
> > be special logic. Basically, if the user has changed the text of a certain
> > column in the record, that record is not simply updated. It is copied to a
> > new record, it's old xref reference is deleted, and a new one is made to
> > the
> > new record (to keep the old record data in tact). I think that i might be
> > able to pull this off using only sql (will that work in the context of an
> > update), but i'd rather do code. Is it possible to like override the
> > update
> > call and put a bunch of .net code in to work with the records being
> > updated?
> > not sure.
> >
> > Thank for any help.
>
>
>
.

Relevant Pages

  • PostgreSQL database call
    ... Executes a raw SQL statement against MySQL or PostgreSql. ... Executes a stored procedure on PostgreSql. ... I'm not intersted in the SQL itself - I want to see the .NET code ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: dataadapter update special logic
    ... Instead of coding the update call, why not create a stored procedure ... and then have the update command on your data adapter use ... > call and put a bunch of .net code in to work with the records being ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Views vs Stored Procedures, whats the difference?
    ... I hope you are not suggesting you embed SQL queries into the application? ... A stored procedure logic will be exactly as fast as the algorithm you ... I understant that SQL Server supports hints. ... implementations (nestedloop, merge, hash, ..) on decent sized tables, then ...
    (comp.databases.ms-sqlserver)
  • Re: Stored Procedures - Patterns and Practices
    ... >published the reasoning behind its opinions. ... I disagree that the debate in SQL Server related discussion forums ... If the natural key is long or spans too many ... I want to call a stored procedure that adds a customer ...
    (microsoft.public.sqlserver.programming)
  • Re: Issue with retrieving large data over web using Stored Procedu
    ... how do I go about analyzing a stored procedure with selecting ... Is there any tool in the SQL Profiler that analyze each Trace? ... "Active Server Pages error 'ASP 0113' ... This email account is my spam trap ...
    (microsoft.public.inetserver.asp.db)