DatetimePicker not accepting values from databaseHello,
I am developing a VB.NET project.
During form show, the datetime picker I placed is showing today's date.
I have a bill no search button. While retrieving values from DB, the datetimepicker should show the bill date. Instead of that, Its showing the current date. Plz verify the below code.
_gd = New gbdataDataContext
Dim _billMain = (From p In _gd.POS_TRX_BILLs Where p.billno = _GbillNo).ToList
dtbilldate.Value = _billMain(0).billdate.Value
The above line is executing without any errors. But Instead of showing 1/6/2016(Bill date), its showing current date (20/2/2016).
I tried also this,
dtbilldate.Text = _billMain(0).billdate
but same result.
Can anyone plz help.
I using LINQ to get the values from DB.