English 中文(简体)
通过指挥参数处理Sql服务器数据库中的“”问题
原标题:Issue when handling the "" in Sql Server Database via Command Parameters

When I am making a query for a data from a MS SQL Server database via C# [.Net 4] Code and adding a parameter to the query with a value of "", the datareader is obtained without any exception and when i read the data from the datareader, i get the exception.

为测试目的,除了在投入结束时外,还使用了“<代码>>>>>>代替“GUID”。

问题回答

I think you are confusing several flavours of Null (.NET Clr null references, Database NULL values and ASCII 0 character literals).

如果你想通过C#通行证中的空座,

string emptyString = String.Empty

通过无效值通行证:代码>null;

string nullString = null;

但是,通过<代码>NUL,通过DBNull

dbParam.Value = string.IsNullOrEmpty(str)? DBNull.Value : str;

另见。 SqlPara amount with Nullable Value give mis while ExecuteNon Query?





相关问题
Anyone feel like passing it forward?

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. ...

NSArray s, Primitive types and Boxing Oh My!

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 ...

C# Marshal / Pinvoke CBitmap?

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 ...

How to Use Ghostscript DLL to convert PDF to PDF/A

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, ...

Linqy no matchy

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. ...