我有一个数据集,我试图将默认值设置为当前日期和时间.我认为 value 需要是文字.有什么方法可以做到这一点吗?因为我似乎无法使用 System.DateTime 来做到这一点.任何建议都会有很大帮助.
I have a dataset that i am trying to set the default value as the current date and time. I believe that value needs to be a literal. Is there a certain way to do this? Because I am not able to do this using System.DateTime it seems.Any advice would be a great deal of help.
可以将相关列的默认值设置为
You can set the default value of relevant column as
dataTable1.Columns["dateTimeColumn"].DefaultValue = System.DateTime.Now;
如果您从 SQL Server 数据库中获取数据,则可以使用 GETDATE
函数设置默认值:
If you fetch data from a SQL Server database, then you can set the default value using the GETDATE
function:
ALTER TABLE MyTable
ADD CONSTRAINT DF_MyTable_MyColumn
DEFAULT GETDATE() FOR MyColumn
使用此代码:
UploadHistory.Columns["FileUploadDate"].DefaultValue = System.DateTime.Now;
当表格写成XML
时:
<xs:element name="FileUploadDate"
type="xs:dateTime"
default="2017-03-13T11:39:26.7980069-05:00"
minOccurs="0" />
上一篇:上传的Android应用程序的照片到谷歌云存储/应用程序引擎 - 非法字符“_”应用程序、字符、上传、引擎
下一篇:genymotion:&QUOT; PLAYER.EXE sttoped工作&QUOT;工作、QUOT、genymotion、PLAYER