MIN and MAX for date and time in dabase

[xile27]

I want to show on Messagebox the value max and min value in my database. Help guys

        query = " SELECT Emp_ID, MIN(Log_Type) as min , MAX(Log_Type) as max FROM tbl_timelogs"
        mysql_connect(True)
        cmd = New MySqlCommand(query, SQLConnection)
        reader = cmd.ExecuteReader()

[pritaeas]

Help with what exactly?

[xile27]

promt the min and max value of Log_type

[Maligui]

By your sql statement the reader would return two fields in one row.

min, max. Considering that Log_Type is an integer value:

 ' ...
 reader = cmd.ExecuteReader()

 Dim min, max As Integer

 ' There will only be one row.
 While (reader.Read())
     min = Convert.ToInt32(reader.GetValue(0))
     max = Convert.ToInt32(reader.GetValue(1))
 End While

 MsgBox("Min:" & min.ToString() & " Max:" & max.ToString())

[xile27]

[Click Here](http://stackoverflow.com/questions/21476590/min-and-max-for-vb-net)

[xile27]

Sir see the link