Groups | Blog | Home
all groups > sql server clients > december 2004 >

sql server clients : No data in datagrid


David Gugick
12/15/2004 7:37:57 PM
ASP.net.

--
David Gugick
Imceda Software
Paul Evans
12/15/2004 11:25:29 PM
Hi,

Could anyone help me?

I'm trying to create a datagrid using ASP.NET. It works fine
except the coloum that is supposed to display the entrydate is blank. All
the other information displays correctly.



I used the following code to create the table on the SQL server.

CREATE TABLE ManuscriptList
(
u_id INT NOT NULL IDENTITY,
u_manuscripttitle VARCHAR( 100 ),
u_manuscriptauthor VARCHAR( 100 ),
u_genre VARCHAR( 100 ),
u_wordcount VARCHAR( 100 ),
u_critiquecount VARCHAR( 100 ),
u_entrydate DATETIME Default getDate()
)


Is the problem something to do with the last line [i.e. u_entrydate DATETIME
Default getDate()] or is it something to do with the ASP.NET code?

Thanks for your time

Paul Evans

AddThis Social Bookmark Button