Data Compar Thread RSS

• • Reply
  

  puneet.ktl

  Member

  8 Points

  8 Posts

  Data Compar Thread

  Mar 03, 2012 05:06 PM|LINK

  Hi ALL

  I have a table in my database and  it has a column name 'date' of 'varchar' type, and some some columns name product order name. Now i want to retrieve data to gridview between two Dates. As my database table defination os 'date' column(varchar),I am unable to do that. Please Suggest how to fill gridview for data between two dates...

    Thanks & Regaards

  Punet Goel

  PTSPL

  dates varchar datacompare

• • Reply
  

  ignatandrei

  All-Star

  134903 Points

  21619 Posts

  Moderator

  MVP

  Re: Data Compar Thread

  Mar 03, 2012 06:58 PM|LINK

  if the varchar is stocked  as

  20120330

  you can simply do a between .

  dates varchar datacompare

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
• • Reply
  

  puneet.ktl

  Member

  8 Points

  8 Posts

  Re: Data Compar Thread

  Mar 08, 2012 11:04 AM|LINK

  No i have stored date data as MM-DD-YYYY format.

  ignatandrei

  if the varchar is stocked  as

  20120330

  you can simply do a between .

  • Marked as answer by puneet.ktl on Jul 17, 2012 06:13 AM
• • Reply
  

  ignatandrei

  All-Star

  134903 Points

  21619 Posts

  Moderator

  MVP

  Re: Data Compar Thread

  Mar 08, 2012 12:15 PM|LINK

  use 111 to convert to date

  http://msdn.microsoft.com/en-us/library/ms187928.aspx

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
  • Marked as answer by Dino He - MSFT on Mar 09, 2012 09:54 AM
• • Reply
  

  puneet.ktl

  Member

  8 Points

  8 Posts

  Re: Data Compar Thread

  Jul 17, 2012 06:13 AM|LINK

  Thanks I resolved My Issue :)