DataGrid Question


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: DataGrid Question

  1. #1
    Join Date
    Feb 2004
    Posts
    126

    DataGrid Question

    There is a message board application.
    And the DataGird is being used to populate the threads.
    Topic,Startedby replies,views and Date Posted.
    But now i want to add LAST POST if there is any.
    There are 2 tables post and reply
    On the Last Post column i would like to retrieve the Last Reply from the
    reply table
    into that column so for exmaple "1/1/2005 @13:49pm by Name"
    the reply table has the columns replyid,name,subject,dt(date),message and
    postid.
    What would be the best way to do this?

  2. #2
    Join Date
    Jun 2004
    Location
    Pakistan
    Posts
    292
    Add a new field in both tables, DATE, and set its default value to getDate OR Now() depending on the db u r using and then use order by date DESC to get the field.
    new to programming but getting ther

Similar Threads

  1. Subject : Datagrid Cell Control Question
    By Michael in forum .NET
    Replies: 2
    Last Post: 11-02-2005, 10:11 AM
  2. DataGrid question
    By arun99 in forum .NET
    Replies: 0
    Last Post: 08-26-2005, 12:07 PM
  3. Winforms DataGrid question...
    By Jim in forum .NET
    Replies: 0
    Last Post: 04-25-2001, 11:04 AM
  4. Winforms DataGrid question...
    By Jim in forum .NET
    Replies: 0
    Last Post: 04-24-2001, 11:21 PM
  5. DataGrid Web control question
    By Ind- in forum ASP.NET
    Replies: 0
    Last Post: 02-09-2001, 01:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center