Member Avatar for ursdestiny

Hello,
I did a stupid mistake in which I had my date saved as varchar in the format:
"Tuesday, 25 November 2011".

Now my database was binded with a datagrid and the problem now comes when I am sorting the grid from date as it sorts it with week day.

How can i solve the problem the easiest way? Do i change the datatype of the database :sad:

I am using VS.Net 2008 and the database server is the Sql Server 2008. I have binded the grid using the Visual Studio.

Please help me.
Thanks
Adnan Masood.

  • 1 Contributor
  • 1 Reply
  • 63 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ursdestiny
Member Avatar for ursdestiny

Please give some solution please

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.