我有以下线性代码用于从数据库中检索数据:
DataTable newEquipmentTable = database.Connection.RetrieveData(database.AdapterType, string.Format("SELECT ID FROM Equipment WHERE Name = {0} AND CreatedOn = {1} ", equipment.Name, equipment.CreatedOn.ToString("yyyy-MM-dd HH:mm:ss.fff")));
它留下了一个错误,即“变形数据类型转换为日间数据类型,造成超距离值”。
当我进行直接协商时,利用以下询问,我回去了预期结果。
SELECT ID FROM Equipment WHERE Name = aa AND CreatedOn = 2012-04-17 19:42:49.650
我做了什么错误?
请注意:datetime 类型不能在<代码>1753-01之前持有数值。
在查询数据库以发现问题之前,仅对“宝库”的铺设情况进行检查。
然而,最好的做法是使用一个参数分类的查询(如,例如);否则,你会很容易在SLjection in。
页: 1 因此,您必须首先将其改为:
Convert(datetime, 2012-04-17 19:42:49.650 , 102)
除此以外,您可以开放到SQL-Injection,作为@Mr47提到,使用> /<>/>。SqlParas/
设备的价值如何。 是否建立?
我认为,在保护者或适用者的文化环境中存在问题。 这不能直接掩盖你的日期。 用户文化环境将解决问题。
What is the use of default keyword in C#? Is it introduced in C# 3.0 ?
I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...
I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...
I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...
How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...
Since I cannot order my dictionary, what is the best way of going about taking key value pairs and also maintaing an index?
Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...