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
