Monday, August 2, 2010

C # dbparameter few areas need attention



1. Even if the database fields that can have parameters for the air to perform the insert or change, we need to ensure that the non-parameter value for the null, as null when prompted not all aviariables bound, but can be "" (empty string string)

Such as Oracle, there is a table t, t, there is a field varchar2 (10) field c1

Take the value of a text box TextBox1 Insert Field

For example insert into t values (: p1)

OracleParameter op = new OracleParameter ("p1", TextBox1.text); this can not go wrong because the textbox will get an empty string instead of null

But if taking null value as parameter value will be wrong (in fact, the program will reference the variable does not exist error) an error message is not all aviariables bound ~ (many cases of this error, not initialized ah)

As a reference to a class of property is not initialized

銆??OracleParameter op=new OracleParameter("p1",SomeClass.XX)鍏朵腑 XX鏈鍒濆鍖?br />
2. The wrong variable name: sql statement in the declaration of variable argument list is not found in the appropriate bindings

3.not all aviariables bound for this error is because there are redundant variables are not binding. sql statement does not, or spelling errors, and bind the variables in







相关链接:



Host address changes by MALICIOUS shielding PPS



Mp4 Converter



The happiest nine career professional



Free convert mp4 to 3gp



Wizard Java And JavaScript



MTS format



Own use a MVC Pager



Graphical Modeling AutoCAD2000 Football



Guide Teaching And Training Tools



Specialist Calculators And Converters



How leaders "like contradicting the" get Along with subordinates



Some LIVE for BI to! But Mo take BI as "the Bible"



Tips to download lovers to support the market



mpg to wmv Converter



CSS color and background PROPERTIES



Media Relations Public RELATIONS Manager, how to protect journalists



No comments:

Post a Comment