finding the highest version of data in sql server table

Question

Hi all,hi i have small doubt.I have table like this

 column name      datatype
 -----------------    ----------------
    date               date
    version           varchar(50)
     name1           varchar(50)
   
     date       version   name1
  25/5/2013 1.1           A
  25/5/2013 1.2           B
  24/5/2013 2.5           C
  24/5/2013  2.0          D
 
I want to find the max version record of that day.Can u give me any suggestion abt to find the max vesrion of record?

Answer 1

When any rows gets deleted, it still exists in the datatable untill dt.AcceptChanges () was called.

 

You can access the deleted rows by using below snippet

if (dataRow.RowState == DataRowState.Deleted)
    id = (string)dataRow["EmpId", DataRowVersion.Original];