table size

Hot Topic

how to compare 2 files using two RichTxtBox
Default Text property in User Control
Implicit operator and Generic classes
.Parent
propelm with connection
Exception Assistant not showing
creating a COM object with c# and using it in VB6
How to change the font color...
How to set the AutoscrollPosition of a ScrollPanel Control?
MS Outlook-esque control

Visual C#

How to calculate the mailbox hash to construct URL path
Random Division
Future C# string optimization directions
disabling and/or hiding Windows taskbar
combo box display tables
Accessing object in form (newbie question)
I use the print class of FotoVision to make a image print program, why doesn't it work?
Lines between methods
DataAdapter+DataTable [multiple tables]
Get ALL the forms into a collection

table size

I'm a newbie.

in C#

If I add and delete, to and from my table, how can I detemine the number of records in my table at any given time.

What I want to do is to read only the last 50 records of my tabel so I will only see the latest entries.

Any help is greatly appreciated.

Jim Diamond

Answer this question

table size

  • Eric J. Smith

    I'm assuming here that you have a SQL Server backend or something like that. The easiest way would be something like

    SELECT TOP 50 * FROM Table1 ORDER BY anIDField DESC

    Where anIDField is either an autoincrement field or a datetime field [I'd prefer a datetime field just because you know WHEN the record was added].

  • urw

    I have resolved my problem.

    the code I was looking for is:

    oleDbDataAdapter1.Fill(words1DataSet1, "Words17");

    bm1 = this.BindingContext[words1DataSet1, "Words17"];

    if (words1DataSet1.Words17.Count > 50)

    bm1.Position = words1DataSet1.Words17.Count - 50;

    else

    bm1.Position = 0;

    The keyword I needed was Count.

    Thank you for trying to help me.

    Jdiamond
  • table size
Answer this question