473,386 Members | 1,644 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Handling DateTime in DataGrid control

Hi All,

I need some help.

My database is in MS-ACCESS, one of the field type is Date/Time, when I am trying to fill the records into data grid and show to the user by using windows application i am facing problem. My problem is in data grid control it is displaying only date part of the of field not the complete datetime like (28-08-2006 16:10:15) what might be the problem...pl. help me out

Raju
Aug 29 '06 #1
5 2962
sindhu
54
Hi All,

I need some help.

My database is in MS-ACCESS, one of the field type is Date/Time, when I am trying to fill the records into data grid and show to the user by using windows application i am facing problem. My problem is in data grid control it is displaying only date part of the of field not the complete datetime like (28-08-2006 16:10:15) what might be the problem...pl. help me out

Raju
hi can u tel me how to insert and delete record from the database through datagrid, which wil be upadated in dataset aswell as datasource
Oct 7 '06 #2
hi can u tel me how to insert and delete record from the database through datagrid, which wil be upadated in dataset aswell as datasource
Hi,

Can you tell me wheather your need is in ASP.Net (web forms) or VB.Net(windows forms).

Raju
Oct 17 '06 #3
sindhu
54
Hi,

Can you tell me wheather your need is in ASP.Net (web forms) or VB.Net(windows forms).

Raju
THANKS ALOT I NEEDED IN ASP.NET
NOW I'VE GOT IT
DO U KNOW HOW TO GET THE DATETIME VALUE FROM THE CALENDAR WHICH IS DISPLAYED IN THE DATAGRID
THANKS ALOT IN ADVANCE
Dec 12 '06 #4
Hi,

Within ur SQL statement u format the selected field.
For example : SELECT format( PaymentDate,'dd/MM/yyyy') FROM Payment.

Carol,

Hi All,

I need some help.

My database is in MS-ACCESS, one of the field type is Date/Time, when I am trying to fill the records into data grid and show to the user by using windows application i am facing problem. My problem is in data grid control it is displaying only date part of the of field not the complete datetime like (28-08-2006 16:10:15) what might be the problem...pl. help me out

Raju
Dec 19 '06 #5
Hi,

Can you tell me wheather your need is in ASP.Net (web forms) or VB.Net(windows forms).

Raju
Reply
In ASP.Net (web forms)
pls send soln as much as possible
Feb 1 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Qumer Mumtaz Goraya | last post by:
Hi There is a datatime picker control in one column of my datagrid.When the cell of sepecific column get the focus the datetime picker control appeare It shows the current system date.If once I...
3
by: Andrew S. Giles | last post by:
Hello, I am importing a flat text file, and putting it into a datagrid for display on a form. Currently the users have their dates and times seperated. I have two fields, therefore in the...
0
by: Makarand | last post by:
Hi Friends I am having problem in Event handling in ASP.NET. Let me tell you what I am doing, I have having DataGrid for which I am using 'Dynamic addition of Template controls'. For this I...
4
by: The Alchemist | last post by:
I am having a problem with a dynamically-generated Datagrid. It is important to point out that this problem does not exist with a design-time created Datagrid, but only with a dynamically generated...
2
by: Oleg Ogurok | last post by:
Hi all, I have a DatePicker ASP.NET control that allows users to enter date (e.g. a calendar control). The control has the following property public DateTime Value { get; set; } I've placed...
9
by: Sridhar | last post by:
Hi, I have created a web page which includes a place holder. I also have a dropdown list in that webpage. when I select one of the choices in that dropdown list, It will load a user control...
8
by: jcrouse | last post by:
I am using the following code to trap errors in a sub routine: Try Executable code Catch ex As Exception Dim strInputE As String = Application.StartupPath & "\Error.txt" Dim srE As...
0
by: H5N1 | last post by:
Hi there I know that a problem of different datetime strings formatting between asp.net and ms sql has been covered here widely, but what I couldn't find is the 100% safe way of getting datetime...
5
by: AAJ | last post by:
Hi Does anyone know of any good publically available set of standards for managing dates when dealing with a database server (in my case SQL Server 2000 and c# VS2005). At the moment, if I...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.