.NET Framework - newbie: Getting the latest record in a DataTable in DataSet ???
Asked By Jeff
07-Jan-08 08:42 AM
Hey
.NET 2.0
Sql Server 2005
AFIAK when my .NET app starts it fills every DataTable objects in the
DataSet with data
I wonder how to retrieve the latest record from a DataTable in a DataSet?
any suggestions?
DataTable
(1)
DataView
(1)
DataSet
(1)
Vågsæther
(1)
Karlsen
(1)
Lasse
(1)
Datatime
(1)
Mailto
(1)
lass replied...
Define latest record.
Is it the one with the highest primary key value? The highest time stamp
value?
Perhaps it's just a matter of ordering your data accordingly.
--
Lasse Vågsæther Karlsen
mailto:lasse@vkarlsen.no
http://presentationmode.blogspot.com/
Jeff replied...
it is the record with the highest primary key value... each record also
contain a datatime value specifying when the record was created...
Ignacio Machin \( .NET/ C# MVP \) replied...
Hi,
Just create a DataView with the correct sorting and it would be either the
first or the last record in the DataView
--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.
Dataset und .xml Datei .NET Framework Hallo , ich lese eine .xml Datei in ein Dataset DataSet myds = 3D new DataSet(); myds .ReadXml("Punkte.xml"); Ich wil aber so etwa. . . myds .ReadXml("Punkte.xml", "WHERE Jahr 3D 2008"); Danke f = FCr jeder Typ. Gru = DF Nina. C# - German Discussions DataView.Danke (1) DataTable (1) ReadXml (1) FCber (1) FCr (1) Dataset (1) Datei (1) Jahr (1) Hallo, das macht man = FCber DataTable und DataView. Danke, ist schon erledigt. keywords: Dataset, und, .xml, Datei description: Hallo , ich lese
dataviews bound to the same data table? This is the scenario: dvDataView1 is bound to Dataset.DataTable. dvDataView2 is bound to DataSet.DataTable. Both dataview 1 & 2 are bound ot the same datatable in the same dataset. But both of these have their own currency manager (am I right here?) What I can't seem to find an answer. Thanks ADO.NET Discussions ISupportInitialize (1) DataColumn (1) DataTable (1) LoadDataRow (1) EventArgs (1) C# (1) BeginInit (1) EndInit (1) Isn't this just
Exporting from a DataTable or DataView .NET Framework Using only .NET components (rather than 3rd party components), is there a way to export data from a DataTable or DataView directly to an .xls or .csv file? - - Michael Hockstein ADO.NET Discussions ADO.NET (1 Excel (1) DataTable (1) Visual (1) Export (1) ¤ Using only .NET components (rather than 3rd party components), is there a way ¤ to export data from a DataTable or DataView directly to an .xls or .csv file? There is no bulk method to perform the reply. As far as I know, we can use "Excel Automation" to transfer data from dataset to Excel file. http: / / support.microsoft.com / kb / 306023 / en-us [How to transfer data
Dataset and datatable .NET Framework I use in my asp.net code dataset and populate datatable using dataadapter. The problem is that my code demand huge amount of memory and I am looking for way reduce this demand. At this time I keep links to dataset, dataadapter and datatable in session. As I understand datatable is class and specific datatable does not belong directly to dataset and using the same dataadapter I can populate two