On Fri, Apr 22, 2011 at 5:04 PM, schouw <[email protected]> wrote:
> I am holding a DataSet and would like to update my memcached cache by
> MS SQL database events (insert, updated or delete).
> I know it is easy to get the DataSet to update automatically, but how
> do I handle the extra task of updating my extern cache as well?
> Shall I just hook into the events from DataTable?
>
> Lars
------------------
For my last proj I had to update the datagridview after an edit was
done. I do the edit in textboxes below the grid because of company
rules, no grid editing. I then update the row of data in the TABLE
that was just changed in the textbox(es).
All my textboxes are databound to classes in use. Any change effects
them and the isDirty flag is set as needed. The save button checks
for isDirty = true before I pass it back for update process. I then
call this sub:
Private Sub backFillGrid()
Dim RN As Integer = Me.iRow ' Me.dgvPayers.CurrentCell.RowIndex
upDGrid(False) ' sets all columns in dgv to Boolean passed.
Try
PayerList.Rows(RN).Item("Carr_Addr1") = tbAddr1.Text
PayerList.Rows(RN).Item("Carr_Addr2") = tbAddr2.Text
PayerList.Rows(RN).Item("Carr_City") = tbCity.Text
etc.........
Just refresh the grid and you are ok.
--
Stephen Russell
Unified Health Services
60 Germantown Court
Suite 220
Cordova, TN 38018
Telephone: 888.510.2667
901.246-0159 cell
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
