Min and Max In and out time Employee

See more:

C#

SQL

MS-Access

Hello ,

i am uploading emp.accdb file which is Microsoft Office Access 2007 Database.
then i am reading data .but i canot get min and max logdate for particular user and date


how can i get min and max date particular user and date

my code:

public void oldbconnction()
{
    OleDbConnection conn = new OleDbConnection(oldbconnstring);
    
    string sql = "SELECT Min(LoginDate) as Intime ,Max(LoginDate) as OutTime,UserID FROM tblEmployee group by LoginDate ";
    OleDbCommand cmd = new OleDbCommand(sql, conn);
    conn.Open();
    OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
    adapter.Fill(results);
    
    if (results.Rows.Count > 0)
    {
        for (int insertdata = 0; insertdata < results.Rows.Count; insertdata++)
        {
            //insert into sql server max and min login date userid
            Insertsql(Convert.ToDateTime(results.Rows[insertdata]["Intime"].ToString()), Convert.ToDateTime(results.Rows[insertdata]["OutTime"].ToString()), Convert.ToInt32(results.Rows[insertdata]["UserID"].ToString()));
            SendToZoloUrl(results.Rows[insertdata]["Intime"].ToString(), results.Rows[insertdata]["OutTime"].ToString(),Convert.ToInt32(results.Rows[insertdata]["UserID"].ToString()));
    
        }
    }
}

plz help me how can i get data min and max datetime particular user and date

my emplyeedata is:

LoginDate              UserID
7/17/2014 5:22:04 PM    1
7/17/2014 5:41:59 PM    1
8/12/2014 5:41:59 PM    2
8/12/2014 8:41:59 PM    2
9/17/2014 3:41:59 PM    4