Re: update datagrid

even though i'm not using a typed dataSet and using a datalayer for all my
updates, connection to the database?

do you have an snippet I can see how this is done?


"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx> wrote in
message news:%23bqq4YjvGHA.4512@xxxxxxxxxxxxxxxxxxxxxxx
If you load the changes back into your dataset, they will be flagged
(internally) as changed. You can then connect to the DataAdapter, call
Update(), and only those rows will be sent to the database (new or
changed). This is part of the default behavior of ADO.NET.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
"John" <me@xxxxxx> wrote in message
news:%23n$2OcivGHA.1772@xxxxxxxxxxxxxxxxxxxxxxx
I have an editable datagrid and when the user clicks update how can i
update only the changed rows? Im' not using a typed dataset, so how can i
update only the changed rows to the database?






.

Relevant Pages

  • update datagrid
    ... I have an editable datagrid and when the user clicks update how can i update ... Im' not using a typed dataset, ... only the changed rows to the database? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to insert data from strongly typed dataset into database (jbx01)
    ... I had an XSD ... database based on the XSD schema, ... I'm receiving XML files ... typed dataset instance from the XMLDocument instance created off an XML ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: More advanced examples for the impatient "newby"
    ... but the key to success will be the design of your database. ... Set the bindingsource datasource to the typed dataset and datamember to the ... Bind the datagridview to the the bindingsource (I only do this AFTER I ... The example I want to use in my experiments is a recipe management ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: INSERT Problem
    ... values then calling Update. ... When Update is called, your explicit values ... I have a typed dataset that I created using VS2008. ... It's been a while since I messed with database stuff. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: More advanced examples for the impatient "newby"
    ... after creating my typed dataset, ... Assuming the database is designed correctly, ... Bind the datagridview to the the bindingsource (I only do this AFTER ... The example I want to use in my experiments is a recipe management ...
    (microsoft.public.dotnet.framework.adonet)