On the txtCompany.focus() method issue I suspect that this doesn't actually execute immediately but rather when the UI gets some processor time - by which time it's too late to be effective for your purposes (although I'm speaking with a WPF hat on here - this may not hold true for WinForms controls)

Bit I guess you're on the right track with the URL suggestion if you can identify the current DataGridView......
Good Luck,
Viv


>The row is there, just not the value of the current, dirty cell.
>
>I've tried the endedits before and after the Acceptchanges. It laughs a me..
>Seems the problem is that the current cell which is dirty will not commit - even with endedits, until the cell loses focus. Clicking a save button doesn't fire the event to deselect the cell.
>
>http://stackoverflow.com/questions/963601/datagridview-value-does-not-gets-saved-if-selection-is-not-lost-from-a-cell
>
>If I click on another control before clicking the save all works as expected. Oddly, calling txtCompany.focus() in my beforesave handler does no good.
>
>The solution offered on SO for the question above involves knowing the name of the grid that might have a dirty cell. I have 20 of these grids and the user could be in any on one of them when clicking save. Toolstrip click handler does not know the current control ( I don't think ) when it is called. I am now going to investigate finding out from the form what has selection when the save is called ... that may be the answer.
>
>
>>Don't think I can help here - Winforms is pretty much off my radar :-{
>>FWIW, I'd assume that the row is actuallly missing when you call the Serialize() but you coudl check just to narrow it down.
>>
>>Also (completely left-field) you could try doing the EndEdits() before the AcceptChanges().......
>>
>>
>>>Hi Viv -
>>>
>>>Sorry I didn't reply to this sooner but that answer was, at the time, I don't know. i had run off in so many different directions chasing this that I wasn't sure which parts worked and which didn't.
>>>
>>>i think now the answer is that I have solved the serialization, which turned out to be easier than I was making it ( code below for lurkers ) and now have it reduced to a problem with Datagridviews using the dataset member as a datasource. (explained below and my current source of frustration)
>>>
>>>That first :
>>>
>>>I created a small test app with one table, three columns
>>>ikey int pk
>>>company varchar(100)
>>>wideobject varbinary(max)
>>>
>>>I have a dataset (Typedchildset) with two datatables ( Clients, Employees)
>>>
>>>I have 2 dgvs. For simplicity, I am binding them to the dataset member rather than using a binding source
>>>
>>>I enter data the two grids - Clients, then Employees.
>>>
>>>Everything saves when serialized as expected - except the last new row of the last grid.
>>>
>>>I can add five rows to employees and all save the last will be saved.
>>>
>>>NOTE : on further testing - the problem only comes about if the cursor is still in the newly added row when the save is called. If I first click out of the grid to another control, then save, the last row is saved. But of course, the use won't do that, so i must force something so the endedit actually ends the edit for that row.
>>>
>>>In the BeforeSave event of my business object :
>>>
>>>

>>>
>>>'Tried me.txtCompany.focus() before the code below, as actaully clicking the textbox to get out of the grid before clicking the Save button seems to work - no joy
>>>
>>>' I found I needed this before the endedits or I also lost the last new row of the first grid
>>> 
>>>      Me.TypedChildset1.AcceptChanges()
>>>
>>>        Me.dgvClients.EndEdit()
>>>        Me.dgvEmployees.EndEdit()
>>>
>>>' 
>>>
>>>' Here's the serializer - works fine ( note : remotingformat prop of ds instance must be 
>>>' set to binary
>>>
>>>        '-- Copy dataset to property
>>>
>>>        '-- Establish locals
>>>        Dim loFormatter As New BinaryFormatter()
>>>        Dim loStream As New System.IO.MemoryStream()
>>>
>>>        '-- Serialize the business object
>>>        loFormatter.Serialize(loStream, Me.TypedChildset1)
>>>
>>>        '-- Return the created stream
>>>        Me.CompaniesBO1.WideObject = loStream.ToArray()
>>>

>>>
>>>Feel I'm getting very very close, but this last bit is making me crazi(er).
>>>
>>>Thoughts?
>>>
>>>
>>>>Hi,
>>>>Did you solve this?,
>>>>Best,
>>>>Viv
>>>>
>>>>>I have a varchar(max) field in SQL 2008 Dataset_XML. My strongly typed business object is mapped to that column, and returns
>>>>>

>>>>><dsPolicies xmlns="http://tempuri.org/dsPolicies.xsd" /> 
>>>>>

>>>>>for a null. ( this is because I am adding this field to a current app an have to allow nulls, but I could script this as a value for all null values and then not allow nulls if that would help)
>>>>>
>>>>>dsPolicies is dropped on the form and the instance is names dsPolicies1.
>>>>>
>>>>>The dataset is typed with 8 tables. and the XSD file seems to be working as I am using bindingsources for each table and the datagridviews are showing the right columns.
>>>>>
>>>>>In the parentform_loading event of the business object on the Policies form I am trying to deserialize the XML stored in Me.PoliciesBO1.Dataset_XML ( which has the default value shown above) using this code :
>>>>>
>>>>>

>>>>>    Private Sub PoliciesBO1_ParentFormLoading() Handles PoliciesBO1.ParentFormLoading
>>>>>
>>>>>        Me.PoliciesBO1.fillall()
>>>>>
>>>>>        If Me.PoliciesBO1.Count > 0 Then
>>>>>
>>>>>            Me.DsPolicies1 = _ CType(InsurtecPW.Base.Utility.SmartDeSerialize(Me.PoliciesBO1.Dataset_XML), InsurtecPW.dsPolicies)
>>>>>
>>>>>        End If
>>>>>
>>>>>    End Sub
>>>>>

>>>>>
>>>>>and this is the deserialize routine :
>>>>>

>>>>>    Public Shared Function SmartDeSerialize(ByVal serialized As String) As DataSet
>>>>>        Dim __ds As DataSet = New DataSet
>>>>>        ' needed to create an XML TextReader 
>>>>>        Dim nt As NameTable = New NameTable
>>>>>        Dim nsmgr As XmlNamespaceManager = New XmlNamespaceManager(nt)
>>>>>        Dim context As XmlParserContext = New XmlParserContext(Nothing, nsmgr, Nothing, XmlSpace.None)
>>>>>        Dim tr As XmlTextReader = New XmlTextReader(serialized, XmlNodeType.Document, context)
>>>>>        Try
>>>>>
>>>>>            __ds.ReadXml(tr)
>>>>>
>>>>>            Return __ds
>>>>>        Finally
>>>>>            If Not (tr Is Nothing) Then
>>>>>                tr.Close()
>>>>>                tr = Nothing
>>>>>            End If
>>>>>            context = Nothing
>>>>>            nsmgr = Nothing
>>>>>            nt = Nothing
>>>>>
>>>>>        End Try
>>>>>
>>>>>    End Function
>>>>>

>>>>>
>>>>>As you see, this returns a dataset, but I don't seem to be able to cast the return value as the dsPolicies that I need.
>>>>>
>>>>>Unable to cast object of type 'System.Data.DataSet' to type 'InsurtecPW.dsPolicies'.
>>>>>
>>>>>I have also tried a directcast of the returned dataset and got the same result.
>>>>>
>>>>>This approach seemed to work find when I was using an untyped dataset.
>>>>>
>>>>>I'd appreciate any thoughts on this. I'm pretty clueless about possible differences between the dataset class and a typed dataset or if my problem is the value I am returning if the column is empty.
>>>>>
>>>>>I am open to any approach (including serializing to a byte array) which will allow me to write and entire dataset to a sql column and bring it back.
>>>>>
>>>>>Suggestions very much appreciated.
>>>>>
>>>>>TIA