Re: Found Serious Bug!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 03/01/04


Date: Mon, 1 Mar 2004 08:15:39 -0500

Trey:

I just got in and am reading through your posts. let me read through it and
get back to you shortly.

Bill
"Trey" <weaver@nc.rr.com> wrote in message
news:OTWE8Zw$DHA.2056@TK2MSFTNGP11.phx.gbl...
> After spending another day with this problem I think it is related to the
> datagrid doing something to the dataview and then to the datatable which I
> show.
>
> So I think it may be related to the 'reported' problem with the datagrid
> that you mentioned below. Do you know what the solution was to this
> datagrid problem and I will try it?
>
> "William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
> news:%23MUQQLl$DHA.1288@TK2MSFTNGP10.phx.gbl...
> > Trey:
> >
> > The DataView doesn't give a hoot about the DB once you've created it.
For
> > all it knows, the database who's data has populated it may not exist any
> > more. If anything is causing a corruption..it's got to be either your
> > update logic, some other code in the program or a corrupt database file.
> >
> > I've seen this 'reported' before when people had stuff bound to a
datagrid
> > and were using position in the grid as though it matched the underlying
> > datatable. That may or may not be the case based on sorting, but
> Something
> > has to send the update back to a database in order for anything to be
> > changed, and DataView's simply don't have that functionality. They
> > physically can't change a database so it's got to be your update logic..
> > HTH,
> >
> > Bill
> > "Trey" <weaver@nc.rr.com> wrote in message
> > news:OwNPhdh$DHA.2216@TK2MSFTNGP10.phx.gbl...
> > > If you have a datatable connected to a dataview.
> > > And
> > > In that dataview you have a "Sort" property set to a value;
> > > And
> > > You try to modify the "Sort" column in row in such a fashion that it
> gets
> > > moved in the DataView
> > > IT CAN
> > > Corrupt your database.
> > >
> > > A quick fix is to set the "Sort" property of the dataview to "" make
> your
> > > changes and then set it back to it's original value.
> > >
> > > Trey
> > >
> > >
> >
> >
>
>



Relevant Pages

  • Re: Found Serious Bug!
    ... So I think it may be related to the 'reported' problem with the datagrid ... > The DataView doesn't give a hoot about the DB once you've created it. ... some other code in the program or a corrupt database file. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DataTable -> DataView -> Sort -> DataGrid : need related DataTable index
    ... from the database. ... To get datarow from the current datarowview is ... In the UI the user adds rows to the DataGrid and the values are saved ... The DataTable is displayed by using a DataView. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to refresh a datatable??
    ... Hello Bill! ... display all the updated data in the DataGrid (DataGrid is used to display ... > that your update is successful, the database and the local datatable ...
    (microsoft.public.dotnet.framework.adonet)
  • DBConcurrency Exception
    ... I can update and delete rows without having to re-fill the dataset (dataview). ... However, if I add a new row and then delete it after postback, using the datagrid, I get a DBConcurrency exception (there are no other users making changes to the database). ... If I insert the new row and then re-fill the dataset, ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • DBConcurrency Exception
    ... I am populating an ASP.NET datagrid with a dataview object stored in session state. ... However, if I add a new row and then delete it after postback, using the datagrid, I get a DBConcurrency exception (there are no other users making changes to the database). ... If I insert the new row and then re-fill the dataset, ...
    (microsoft.public.dotnet.framework.adonet)