Handling updates to a Cached DataTable when the users session holds DataViews based on that DataTabl

Posted by minty on Stack Overflow See other posts from Stack Overflow or by minty
Published on 2008-11-20T00:43:22Z Indexed on 2010/03/24 15:03 UTC
Read the original article Hit count: 213

Filed under:

datatable

|

dataview

|

c#

|

ADO.NET

|

ASP.NET

My website runs on a single server. I am caching a DataTable. Each session has a refernce to it's own DataView referring to that DataTable. What I am worried about is when I need to make changes to the underlying datatable will they propagate to each of the sessions references to it.

Or is there a better way to handle this situation.

© Stack Overflow or respective owner

Related posts about datatable

DataView.RowFilter Vs DataTable.Select() vs DataTable.Rows.Find()

as seen on Stack Overflow - Search for 'Stack Overflow'
Considering the code below: Dataview someView = new DataView(sometable) someView.RowFilter = someFilter; if(someView.count > 0) { …. } Quite a number of articles which say Datatable.Select() is better than using DataViews, but these are prior to VS2008. Solved: The Mystery of DataView's Poor… >>> More
How to correctly filter a datatable (datatable.select)

as seen on Stack Overflow - Search for 'Stack Overflow'
Dim dt As New DataTable Dim da As New SqlDataAdapter(s, c) c.Open() If Not IsNothing(da) Then da.Fill(dt) dt.Select("GroupingID = 0") End If GridView1.DataSource = dt GridView1.DataBind() c.Close() When I call da.fill I am… >>> More
How to obtain a random sub-datatable from another data table

as seen on Developer IT - Search for 'Developer IT'
Introduction In this article, I’ll show how to get a random subset of data from a DataTable. This is useful when you already have queries that are filtered correctly but returns all the rows. Analysis I came across this situation when I wanted to display a random tag cloud. I already had the… >>> More
How can we copy the column data of one datatable to another,even if there is different column names

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two datatables. First is DataTable NameAdressPhones = new DataTable(); with Three columns Name,Adress and PhoneNo.But I want only two columns Name and Adress data so I am copy those columns (with data) to the new datatable DataTable NameAdress = new DataTable(); For that I do … >>> More
Difference between DataTable.Load() and DataTable = dataSet.Tables[];

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All , I have a doubt i use the following piece of code get data from a SQLlite data base and Load it into a data table "SQLiteConnection cnn = new SQLiteConnection("Data Source=" + path); cnn.Open(); SQLiteCommand mycommand = new SQLiteCommand(cnn); string… >>> More

Related posts about dataview

DataView in asp.net2.0

as seen on Stack Overflow - Search for 'Stack Overflow'
i want know that how can i edit delet through dataview control >>> More
How to filter a dataview

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a dataview that contains a list of tables. I am reading in a list of values that I then want to apply as a filter to this dataview. The list of values is actually in the form of "table1, table2, table3". So I thought I would be able to use this as a filter on my dataview. SqlOp.CommandText… >>> More
Sort data using DataView

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a DataGridView with column Remarks (Passed, Failed). For example, I want to show all the records Failed in the column Remarks using DataView, how do I do that? Thank you. Here's the code I'm working on: ds.Tables["Grades"].PrimaryKey = new DataColumn[] { ds.Tables["Grades"].Columns["StudentID"]… >>> More
Asp.net ajax library preview 6 (Ajax toolkits inside a dataview)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I was using the sys.ui.dataview, ado.net data services and a html page to provide an edit page. It was working fine, but when I wanted to apply some ACT features, for instance watermark or autocomplete on a textbox (input) within the dataview div, its not applied. However, when I move that… >>> More
Select TOP 5 * from SomeTable, using Dataview.RowFilter ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to select 5 most recent rows from cached Dataview object, is there any way to do that? I've tried but Indexer DataColumn is empty. : public static DataView getLatestFourActive() { DataTable productDataTable = getAll().ToTable(); DataColumn ExpressionColumn = new DataColumn("Indexer"… >>> More