How to get the last record (row) from my SQL table, RSS

• • Reply
  

  Peter Cong

  Member

  527 Points

  681 Posts

  Re: How to get the last record (row) from my SQL table,

  Dec 22, 2012 05:21 PM|LINK

  me_ritz

  Peter Cong

  <div class="comment-left-col">

  488 Points

  453 Posts

  <input id="quote-createdby" value="Peter Cong" type="hidden" /></div> <div class="comment-right-col">

  Re: How to get the last record (row) from my SQL table,

  12/21/2012 5:05:57 PM

  <div id="reference-post-content" class="reply-comment">

  me_ritz

  Peter Cong

  var idkey = (from c in db.Table1

                        orderby c.IDkey descending

                         select c).Take(1);

  IDKeyField.Text = idkey.ToString(); 

  var idKey = (from c in table1 // the table1 here has red line under it.
                         orderby c.IDKey descending
                           select c).First();
    
  IDKeyField.Text = idKey.IDKey.ToString();

  </div> </div>

  var idKey = (from c in db.Table1 
                         orderby c.IDKey descending 
                           select c).First(); 
    
  IDKeyField.Text = idKey.IDKey.ToString();

  me_ritz

  Peter Cong

  <div class="comment-left-col">

  488 Points

  453 Posts

  <input id="quote-createdby" value="Peter Cong" type="hidden" /></div> <div class="comment-right-col">

  Re: How to get the last record (row) from my SQL table,

  12/21/2012 5:05:57 PM

  <div id="reference-post-content" class="reply-comment">

  me_ritz

  Peter Cong

  var idkey = (from c in db.Table1

                        orderby c.IDkey descending

                         select c).Take(1);

  IDKeyField.Text = idkey.ToString(); 

  var idKey = (from c in table1 // the table1 here has red line under it.
                         orderby c.IDKey descending
                           select c).First();
    
  IDKeyField.Text = idKey.IDKey.ToString();

  </div> </div>

  var idKey = (from c in db.Table1 
                         orderby c.IDKey descending 
                           select c).First(); 
    
  IDKeyField.Text = idKey.IDKey.ToString();

  me_ritz

  Peter Cong

  <div class="comment-left-col">

  488 Points

  453 Posts

  <input id="quote-createdby" value="Peter Cong" type="hidden" /></div> <div class="comment-right-col">

  Re: How to get the last record (row) from my SQL table,

  12/21/2012 5:05:57 PM

  <div id="reference-post-content" class="reply-comment">

  me_ritz

  Peter Cong

  var idkey = (from c in db.Table1

                        orderby c.IDkey descending

                         select c).Take(1);

  IDKeyField.Text = idkey.ToString(); 

  var idKey = (from c in table1 // the table1 here has red line under it.
                         orderby c.IDKey descending
                           select c).First();
    
  IDKeyField.Text = idKey.IDKey.ToString();

  </div> </div>

  var idKey = (from c in db.Table1 
                         orderby c.IDKey descending 
                           select c).First(); 
    
  IDKeyField.Text = idKey.IDKey.ToString();

  Thank you so much, Me_ritz,

  Yes, this time, it is working now, cheers!