Hi friend,

I would like to sort my records by Date and fill then in datagrid. while adding them i am converting the date format to  System.DateTime.Now.ToString("dd/MM/yyyy HH:mm");

but when i am selecting the record with this query

Try out this.

Make order by Convert(Datetime, date)

I have a column in the database 'date' and the values i am stoting in it as 'dd/mm/yyyy hh/mm'

i want the record in order by date column, order should be in month value

indianmaestro:

Hi friend,

I would like to sort my records by Date and fill then in datagrid. while adding them i am converting the date format to  System.DateTime.Now.ToString("dd/MM/yyyy HH:mm");

but when i am selecting the record with this query

strquery = "select * from Clients order by date desc"  the records r sorted by date but notby month , becoze the date is fiest and monthe is second and year is third in the Sql server data base.

how can i get the record sorted by month. I want the latest record first

To Sort by month use this query

select * from Clients order by datepart(month, date) desc

the column name id date but the type is 'varchar' so i ma getting an error

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

indianmaestro:

the column name id date but the type is 'varchar' so i ma getting an error

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

It should be a DateTime datatype So that it can work Since it is not then do this conversion Note it will only work if the date is valid

select * from Clients order by datepart(month, Convert(datetime, Date)) desc

i got this error The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

indianmaestro:

i got this error The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

what is the name of the column which has date stored??

the name in the database column is date.

when i opened in designtable i noticed that there [ ,] to the column name

indianmaestro:

the name in the database column is date.

when i opened in designtable i noticed that there [ ,] to the column name

date is a keyword hence chnage the name to [date] or give some other name