Need help in formating datetime as saved in database

OK, there are 2 issues to discuss with concerning with date formatting:
1) formatting date on MS SQL Server side,
2) formatting date on client side using VB.NET, C# or any other .NET programming language


ad 1)
To format date on server side, see SET DATEFORMAT statement[^]. Note: there are some restrictions.
I would recommend you to use ymd format - see H.Brydon solution/recommendation ;)


ad 2)
Formatting date in VB.NET or C# is simple. See this: Custom Date and Time Format Strings[^].

Summary:
If you can get the date and string-date-format from database, you can do everything what you want to do ;)

To change string-date-format for DateTimePicker, see this: Displaying a Date in a Custom Format with the Windows Forms DateTimePicker Control[^]

Is it enough for start?

check this hope it help :

datetime-format[^]

Use the DateTimePicker.CustomFormat Property[^]. To avoid conversions of the format string, save the format string in the form that is used by the DateTimePicker.

Assumning your problem is only with the date formatting Try this

string usrFormat = "";
// put code to retrieve the format from the database and assign  it to usrFormat variable 
//Assuming you have a datetime picker named dtp 
dtp.Format = DateTimePickerFormat.Custom;
dtp.CustomFormat = usrFormat; 

Hope it helps