简单问题求助大家

Question

                             sql = "update jkyp set zczh=:p1,yzczh=:p2,cpmcc=:p3,cpmce=:p4,spmc=:p5,spme=:p6,jxc=:p7,ggc=:p8,zczhbz=:p9,bzggc=:p10,sccsc=:p11,sccse=:p12,csdzc=:p13,csdze=:p14,csgjc=:p15,csgje=:p16,fbzpzwh=:p17,fzrq=:p18,yxqjzr=:p19,fbzqymc=:p20,fbzqydz=:p21,fbzwhpzrq=:p22,fbzwhyxqjzr=:p23,cplb=:p24,ypbwm=:p25,ypbwmbz=:p26,gsmcc=:p27,gsmce=:p28,dzc=:p29,dze=:p30,gjc=:p31,gje=:p32 where id=:p";
                             cmd.Parameters.Clear();
                             cmd.Parameters.AddWithValue(":p", i);
                             cmd.Parameters.AddWithValue(":p1", temp1);
                             cmd.Parameters.AddWithValue(":p2", temp2);
                             cmd.Parameters.AddWithValue(":p3", temp3);
                             cmd.Parameters.AddWithValue(":p4", temp4);
                             cmd.Parameters.AddWithValue(":p5", temp5);
                             cmd.Parameters.AddWithValue(":p6", temp6);
                             cmd.Parameters.AddWithValue(":p7", temp7);
                             cmd.Parameters.AddWithValue(":p8", temp8);
                             cmd.Parameters.AddWithValue(":p9", temp9);
                             cmd.Parameters.AddWithValue(":p10", temp10);
                             cmd.Parameters.AddWithValue(":p11", temp11);
                             cmd.Parameters.AddWithValue(":p12", temp12);
                             cmd.Parameters.AddWithValue(":p13", temp13);
                             cmd.Parameters.AddWithValue(":p14", temp14);
                             cmd.Parameters.AddWithValue(":p15", temp15);
                             cmd.Parameters.AddWithValue(":p16", temp16);
                             cmd.Parameters.AddWithValue(":p17", temp17);
                             cmd.Parameters.AddWithValue(":p18", temp18);
                             cmd.Parameters.AddWithValue(":p19", temp19);
                             cmd.Parameters.AddWithValue(":p20", temp20);
                             cmd.Parameters.AddWithValue(":p21", temp21);
                             cmd.Parameters.AddWithValue(":p22", temp22);
                             cmd.Parameters.AddWithValue(":p23", temp23);
                             cmd.Parameters.AddWithValue(":p24", temp24);
                             cmd.Parameters.AddWithValue(":p25", temp25);
                             cmd.Parameters.AddWithValue(":p26", temp26);
                             cmd.Parameters.AddWithValue(":p27", temp27);
                             cmd.Parameters.AddWithValue(":p28", temp28);
                             cmd.Parameters.AddWithValue(":p29", temp29);
                             cmd.Parameters.AddWithValue(":p30", temp30);
                             cmd.Parameters.AddWithValue(":p31", temp31);
                             cmd.Parameters.AddWithValue(":p32", temp32);                             cmd.CommandType = CommandType.Text;
                                                          
                             cmd.ExecuteNonQuery();总是报{"ORA-01036: 非法的变量名/编号\n"} System.Exception {System.Data.OracleClient.OracleException}
大家帮我看看

Answer 1

string temp1="1";
....
sql="update jkyp set zczh=@p1,yzczh=@p2";.....cmd.Parameters.AddWithValue("@p32", temp32);
...
這种也可以

Answer 2

那么多更新的列，我倒 sql = "update jkyp set zczh=@zczh,yzczh=@yzczh where id=@id";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@zczh", i);
cmd.Parameters.AddWithValue("@yzczh", temp1);
...
...
..