Re: custom insert for databound datagridview

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

There probably is a way to insert your own change tracking logic, but I think using Sync Services, which already provides change tracking logic inside the SQL Compact engine might be easier in the long run. There is a CTP you can download that handles syncing with a mobile device, but again the desktop piece is SQL Server so you'd still need to write a custom sync adapter to use SQL Compact as the desktop server. Here's the link if the CTP interests you:
http://www.microsoft.com/Downloads/details.aspx?familyid=75FEF59F-1B5E-49BC-A21A-9EF4F34DE6FC&displaylang=en

Since you're talking about DataGridView, I assume you want to track the changes on the desktop, but the desktop app doesn't have access to the data on the device. Are you perhaps considering getting the changed data onto the device in some other fashion? But in any case, the usual sequence of events for data bound controls like DataGridView is that moving to a new row in the grid calls EndEdit which in turn calls Update on the bound data adapter. Brian Noyes wrote a very good book called Data Binding with Windows Forms 2.0 that covers this sort of stuff in detail, some of which I've unfortunately forgotten, but the main thing I do remember is tha tthe BindingSource control is the bit that provides the glue between the GUI control and the underlying data, so look at the event handlers for BindingSource such as AddingNew, BindingComplete, CurrentChanged, CurrentItemChanged, PositionChanged, etc., to see which does what you want.

HTH,
Ginny


"apitman" <apitman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E4BA2AFF-EAFD-4F72-952B-686AD0551B41@xxxxxxxxxxxxxxxx
I already have a solution for doing the sync part.

The question I really need answered is the original one that I posted here:

When I have used all of the built in drag and drop tools to build and
application how do I get notified when an SQL statement gets called so that I
can do something at that point?

To recap:

I created a form. I put a DataGridView on it. I dragged a data source onto
the DataGridView. I told it to generate all the templates.

Now when I use the auto generated UI to create a new record or edit a record
or delete a record I can't seem to find anywhere to get notified of this. I
put break points inside the data source and other places and nothing ever
gets called. Everything just happens auto-magically. That is good because I
wanted it to be auto-magic so I didn't have to write a bunch of code. It is
bad because I can't find a place to insert my own logic.

So, is there a way to insert my own logic in this case?


"Ginny Caughey MVP" wrote:

Eventually Sync Services for ADO.NET will support syncing to a variety of
different relational databases, but the current version doesn't support your
scenario, so at this point you'd be looking at writing your own sync
adapter. Here's a sample for syncing with an Oracle database using a custom
sync adapter that you might be able to adapt:
http://www.syncguru.com/projects/SyncServicesDemoOracle.aspx

Ginny

"apitman" <apitman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4590D3AD-DE73-4B9D-848B-FD9DEF034B59@xxxxxxxxxxxxxxxx
> Syncing is exactly what I am doing. I am syncing between a PDA SQLCE
> database
> and a desktop SQLCE database.
>
> Unfortunately ADO.NET will only sync between something and SQL Server. > It
> does not support syncing between a PDA and SQLCE or even SQLCE and > SQLCE
> databases.
>
> I would love to just use something already out there like ADO.NET > syncing.
> If you can tell me there is already something out there, I would LOVE > to
> hear
> about it. I don't want to roll my own solution, I just seem to be stuck
> doing
> it.
>
>
> "Ginny Caughey MVP" wrote:
>
>> You might look at the current changed event handler for the binding
>> source
>> that is bound to the DataGridView. I'm curious what you want to do >> with
>> the
>> changed data after you know what it is. For example would Sync >> Services
>> for
>> ADO.NET (which is designed for change tracking and updating) be a
>> solution
>> for you?
>>
>> Ginny
>>
>>
>> "apitman" <apitman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:950A7F41-3D68-405C-9D54-9E051593E9F7@xxxxxxxxxxxxxxxx
>> >I don't know if this is the right forum to post this in, but I will
>> >start
>> > here....
>> >
>> > I am writing a desktop database application. I created a simple SQL >> > CE
>> > database. I then created a new form and dragged the DataGridView
>> > control
>> > from
>> > the toolbox to the form.
>> >
>> > I then created a new data source and pointed it to my desktop SQLCE
>> > database.
>> >
>> > I then dragged that data source onto the DataGridView.
>> >
>> > At this point I have a running application that can insert record >> > into
>> > the
>> > database.
>> >
>> > Now comes the fun part. The first field is a Guid. I have read many
>> > things
>> > about the pros and cons of using Guids, but in my case I have >> > decided I
>> > want
>> > to use them as I will be sharing data among several devices >> > eventually.
>> >
>> > I made the ID column not visible and then, of course, started >> > getting
>> > errors
>> > when I created a new row because the Guid was null.
>> >
>> > If fixed this by creating my own class that derived from the
>> > DataGridView
>> > and override the OnRowValidating. I did this because that is where I
>> > was
>> > getting the error. I then put in custom logic to check and see if >> > the
>> > row
>> > guid is blank and if it is I create a new guid.
>> >
>> > This all works. I tell you about it in case there is a better way >> > and
>> > it
>> > relates to my second question:
>> >
>> > I now want to keep track of changes in the database. I created a >> > second
>> > table in the database that will contain the Guid of the record that >> > was
>> > added
>> > / changed / deleted and the date / time it happened. I will use this >> > to
>> > track
>> > changes.
>> >
>> > The problem is that I need to have a place somewhere that I do the
>> > insert
>> > /
>> > update of this meta data table when something changes in the main
>> > table.
>> >
>> > SQLCE doesn't support triggers, so that won't work. The benefits of
>> > SQLCE
>> > outweight this, however, and I am hoping there is a solution.
>> >
>> > So the question is in a data bound situation where can I hook into >> > when
>> > the
>> > SQL statements get run? I put break points all over inside my data
>> > source
>> > class that got created and they never get called. I tried places >> > like
>> > the
>> > Insert method and Update method. I can only assume those functions >> > are
>> > for
>> > if
>> > I want to call them in my code, but the data bound stuff doesn't >> > call
>> > them.
>> >
>> > SQLCE also doesn't support multiple statements in a single call so I
>> > can't
>> > just modify the INSERT INTO statement and put another after it.
>> >
>> > Ideas?
>>
>> -- >>
>> Ginny Caughey
>> Device Application Development MVP
>>
>> www.wasteworks.com
>> Software for Waste Management
>>
>>
>>

--

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Software for Waste Management




--

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Software for Waste Management



.

Relevant Pages

  • Re: custom insert for databound datagridview
    ... gets put into the database until you hit the save button on the navigation ... CTP you can download that handles syncing with a mobile device, ... the desktop piece is SQL Server so you'd still need to write a custom sync ... I am syncing between a PDA SQLCE ...
    (microsoft.public.sqlserver.ce)
  • RE: Push Method - overwriting data
    ... If you are deleting records at the SqlCe Database, ... SQL Server and inserting the new records. ...
    (microsoft.public.sqlserver.ce)
  • Re: custom insert for databound datagridview
    ... I already have a solution for doing the sync part. ... Here's a sample for syncing with an Oracle database using a custom ... does not support syncing between a PDA and SQLCE or even SQLCE and SQLCE ... The first field is a Guid. ...
    (microsoft.public.sqlserver.ce)
  • Reconciler Problem
    ... PocketPC device and a SQL 2K database on a desktop. ... I'm trying to get some SQLCE data into the SQL ... If I use the default conflict resolver setting ...
    (microsoft.public.sqlserver.replication)
  • Re: custom insert for databound datagridview
    ... gets put into the database until you hit the save button on the navigation ... Is there a way to get at the actual point where SQL statements are being ... Since you're talking about DataGridView, I assume you want to track the ... and a desktop SQLCE database. ...
    (microsoft.public.sqlserver.ce)