i need to get latest created record based on latest created date

[ramsiva]

i need to get record based on maximum created date any body help me
date in mysql database structure is varchar. date is 150921141206

any body help me

[pritaeas]

Just use a WHERE clause comparing to the MAX date, or ORDER BY DESC.

[ramsiva]

very thanks

[Miurei]

here is a sample code:

Private Sub mainform_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        cmd.Connection = conn
        cmd.CommandText = "SELECT MAX(ColumnName)  FROM [db_Name].[dbo].[tbl_Name]"
        conn.Open()
        dr = cmd.ExecuteReader()
        Do While dr.Read()
        'max value showing on the textbox
            x.Text = x.Text & dr.GetValue(0) & vbTab
        Loop
        dr.Close()
        conn.Close()
    End Sub

btw, if this already answered post, kindly mark it as solved.

[daniellemacey]

use where clause