Using stored proceures dates
-
Hi Guys using stroed procedure i try to display some datas in my datagrid, This stored procedure working good in my query analyzer, o/p will be like this: 01/01/2008 101 108 Other Expense 01/01/2008 101 109 Own Vehicle Fuel 01/02/2008 101 100 Air 01/02/2008 101 101 Train 01/02/2008 101 102 Bus 01/02/2008 101 103 Local Conveyance 01/02/2008 101 104 Boarding But when i bind the values in my datagrid, Its showing the datagrid dateplace only, 01/01/1900, i dont know whats the probs, Anyone have idea abt this?,
Thanks & Regards, Mageshh, please don't forget to vote on the post
-
Hi Guys using stroed procedure i try to display some datas in my datagrid, This stored procedure working good in my query analyzer, o/p will be like this: 01/01/2008 101 108 Other Expense 01/01/2008 101 109 Own Vehicle Fuel 01/02/2008 101 100 Air 01/02/2008 101 101 Train 01/02/2008 101 102 Bus 01/02/2008 101 103 Local Conveyance 01/02/2008 101 104 Boarding But when i bind the values in my datagrid, Its showing the datagrid dateplace only, 01/01/1900, i dont know whats the probs, Anyone have idea abt this?,
Thanks & Regards, Mageshh, please don't forget to vote on the post
Hi Mageshh, I think problem is the dateformat you are using.. Please check the date format u r using while binding with the datagrid Happy programming.