如何在c#中的datatime字段中插入null值 [英] How to insert null value in datatime field in c#
问题描述
如何在sql / access数据库的datetime字段中插入空值???
数据库:Db_Xyz
表:Tb_Abc
Col1(Varchar)
Col2(Int)
Col3(日期时间)
查询: - 插入Tb_Abc(Col1,Col2,Col3)值('+ txtvalue1 +','+ txtvalue2 +','+ txtvalue3 +'
注意: - 不使用参数...
帮助我...
How to insert null value in datetime field in sql/access database???
DataBase : Db_Xyz
Table: Tb_Abc
Col1(Varchar)
Col2(Int)
Col3(datetime)
Query:- insert into Tb_Abc(Col1,Col2,Col3)values('" + txtvalue1 + "','" + txtvalue2 + "','" + txtvalue3 + "'
Note:- Without using Parameter...
Help me...
推荐答案
尝试:
Try:
INSERT INTO Tb_Abc(Col1,Col2,Col3) VALUES ('" + txtvalue1 + "','" + txtvalue2 + "',NULL)
但请不要这样做!不要连接字符串构建SQL comm它使您对意外或故意的SQL注入攻击持开放态度,这可能会破坏您的整个数据库。请改用参数化查询。
But please, don't do it like that! Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.
这篇关于如何在c#中的datatime字段中插入null值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!