blocks|key|1139144|text|可变大小输出参数需要参数大小。通常，ADO.NET根据分配给参数的值来决定参数的大小(因此它是可选的)，但在输出参数中，由于未设置任何值，因此需要提供参数所需的大小|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1139145|将参数大小设置为来自数据库的输出变量的大小...比如说50|1139146|outParam.Size+=+50;|code-block|syntax|javascript|1139147|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Parameter Size is required for variable size Output parameters. Generally ADO.NET decides the size of the parameter based on the Value assigned to the parameter (hence it is optional), but in output parameter since no value is Set, you need provide the size required for the parameter

Set the Parameter size to size of the output variable from the DB... Say 50

<pre><code>outParam.Size = 50;
</code></pre>

blocks|key|924660|text|我不确定这是否是我以前遇到过的相同问题，但是使用一个字节作为参数有时会导致这个错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|924661|尝尝这个。将i参数显式声明为变量。然后使用value属性为其赋值。|924662|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I'm not sure if this is the same problem i've had before, but using a byte for a parameter can sometimes lead to this error.

Try this. Explicitly declare the i parameter as a variable.
THEN assign it's value with the Value property.

blocks|key|1139243|text|VarChar和NVarChar是宽度可变的字符字段(因此是var%2Bchar)。您必须设置长度，否则默认值为零。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1139244|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

VarChar and NVarChar are variable width character fields (thus var+char). You have to set the length, otherwise the default is zero.

blocks|key|924759|text|检查MSDN：SqlParameter.Size+Property|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|924760|对于双向和输出参数以及返回值，必须设置Size的值。这对于输入参数不是必需的，如果未显式设置，则在执行参数化语句时，将从指定参数的实际大小推断出该值。|924761|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.size.aspx^0|7|Q|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

Check MSDN : <a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.size.aspx" rel="noreferrer">SqlParameter.Size Property</a>

For bidirectional and output parameters, and return values, you must set the value of Size. This is not required for input parameters, and if not explicitly set, the value is inferred from the actual size of the specified parameter when a parameterized statement is executed.

blocks|key|924797|text|顺便说一句，设置输出参数的size属性是必要的，即使它不是字符串类型的参数。例如，如果您使用的是System.Data.SqlDbType.Int，则应将大小设置为4。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|924798|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Incidentally, setting the size property of an output parameter is necessary even if it isn't a string-type parameter. For example, if you are using a System.Data.SqlDbType.Int, you should set the size to be 4.

blocks|key|924849|text|此外，您还可以通过使用以下小命令检查存储过程来获得参数的实际大小：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|924850|SqlCommandBuilder.DeriveParameters(yourCommand)|code-block|syntax|javascript|924851|然后只需遍历参数集合即可。|924852|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Also, you can get the actual size of the parameters by inspecting the sproc with this little command:

<pre><code>SqlCommandBuilder.DeriveParameters(yourCommand)
</code></pre>

and then just foreach your way through the parameters collection.

blocks|key|924900|text|对我来说，每个人的回答都很清楚。也许这会帮助一些人，因为我找到了有效的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|924901|需要向参数添加大小|924902|++++++++DynamicParameters+Params+=+new+DynamicParameters();
++++++++Params.Add("@ProfileID",+ProfileID);
++++++++Params.Add("@CategoryName",+CategoryName);
++++++++Params.Add("@Added",+dbType:+DbType.String,+direction:+ParameterDirection.Output,size:10);

++++++++db.Execute(sql,+Params,+commandType:+CommandType.StoredProcedure,+commandTimeout:+60);

++++++++var+Added+=+Params.Get<string>("@Added");|code-block|syntax|javascript|924903|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Everyone's answer was about as clear as mud to me. Maybe this will help someone now that I found what worked.

Need to add size to the parameter 

<pre><code> DynamicParameters Params = new DynamicParameters();
 Params.Add("@ProfileID", ProfileID);
 Params.Add("@CategoryName", CategoryName);
 Params.Add("@Added", dbType: DbType.String, direction: ParameterDirection.Output,size:10);

 db.Execute(sql, Params, commandType: CommandType.StoredProcedure, commandTimeout: 60);

 var Added = Params.Get&lt;string&gt;("@Added");
</code></pre>

blocks|key|924974|text|我提供了一个具有非字符串但可以为空的类型的值，从而导致出现此错误。在我的例子中，是一个int?。我通过传入一个不可为空的int修复了这个问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|924975|entityMap^0|17|4|1O|3|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

I had this error occur, supplying a value that had a non-string, but nullable, type. In my case, an <code>int?</code>. I fixed it by passing in a non-nullable <code>int</code> instead.

blocks|key|924995|text|您必须设置参数输出的大小|type|unstyled|depth|inlineStyleRanges|entityRanges|data|924996|using+(var+connection+=+new+SqlConnection(ConnectionString))
{
++++connection.Open();
++++SqlCommand+command+=+new+SqlCommand("pDoSomethingParamsRes",+connection);
++++command.CommandType+=+CommandType.StoredProcedure;
++++command.Parameters.Add("@i",+1);
++++var+outParam+=+new+SqlParameter("@out",+SqlDbType.VarChar);
++++outParam.Direction+=+ParameterDirection.Output;
++++outParam.Size+=+50;+//+this+is+example
++++command.Parameters.Add(outParam);
++++command.ExecuteNonQuery();
++++Console.WriteLine(command.Parameters["@out"].Value.ToString());
}|code-block|syntax|javascript|924997|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

you have to set Size for parameter output 

<pre><code>using (var connection = new SqlConnection(ConnectionString))
{
 connection.Open();
 SqlCommand command = new SqlCommand("pDoSomethingParamsRes", connection);
 command.CommandType = CommandType.StoredProcedure;
 command.Parameters.Add("@i", 1);
 var outParam = new SqlParameter("@out", SqlDbType.VarChar);
 outParam.Direction = ParameterDirection.Output;
 outParam.Size = 50; // this is example
 command.Parameters.Add(outParam);
 command.ExecuteNonQuery();
 Console.WriteLine(command.Parameters["@out"].Value.ToString());
}
</code></pre>

blocks|key|925039|text|我也遇到了同样的错误，下面是我的代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|925040|cmd.Parameters("@ProjectKey").SqlDbType+=+SqlDbType.NVarChar
cmd.Parameters("@ProjectKey").Size+=+150
cmd.Parameters("@ProjectKey").Direction+=+ParameterDirection.InputOutput
cmd.ExecuteNonQuery()|code-block|syntax|javascript|925041|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I had the same error and below is my code that works

<pre><code>cmd.Parameters("@ProjectKey").SqlDbType = SqlDbType.NVarChar
cmd.Parameters("@ProjectKey").Size = 150
cmd.Parameters("@ProjectKey").Direction = ParameterDirection.InputOutput
cmd.ExecuteNonQuery()
</code></pre>

I'm trying to get output value from DB via ADO.NET. There's a client code: 

<pre><code> using (var connection = new SqlConnection(ConnectionString))
 {
 connection.Open();
 SqlCommand command = new SqlCommand("pDoSomethingParamsRes", connection);
 command.CommandType = CommandType.StoredProcedure;
 command.Parameters.Add("@i", 1);
 var outParam = new SqlParameter("@out", SqlDbType.VarChar);
 outParam.Direction = ParameterDirection.Output;
 command.Parameters.Add(outParam);
 command.ExecuteNonQuery();
 Console.WriteLine(command.Parameters["@out"].Value.ToString());
 }
</code></pre>

When I run this I get the following exception:

<pre><code>the Size property has an invalid size of 0
</code></pre>

According to manual <a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.size.aspx" rel="nofollow noreferrer">SqlParameter.Size Property</a> I might omit size. Why do I get this exception?

How to make it work without passing size?

ADO.NET - The Size property has an invalid size of 0

数据库

我正在尝试通过ADO.NET从DB获取输出值。有一个客户端代码：    using (var connection = new SqlConnection(ConnectionString))    {        connection.Open();        SqlCommand command = new ...

问ADO.NET - Size属性的大小无效为0
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ADO.NET - Size属性的大小无效为0EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ADO.NET - Size属性的大小无效为0
EN