2023年6月21日发(作者：)

C#中SQL语句参数写法OracleConnection oc=new OracleConnection("data source=osserver;User Id=****;password=**");

OracleCommand cmd=new OracleCommand("insert into file (filename,filecontent) values (:filename,:filecontent)",oc);

OracleParameter op1=new OracleParameter("filename",r,256);

OracleParameter op2=new OracleParameter("filecontent",,);

=eName();

(op1);

=filedata;

(op2);

();

eNonQuery();

();

在ORACLE中，SQL语句参数是：+参数名，

insert into file (filename,filecontent) values (:filename,:filecontent)

在定义此参数的参数变量⾥⾯参数名不⽤写：

OracleParameter op1=new OracleParameter("filename",r,256);

SqlConnection conn=new SqlConnection("data source=ccserver;user id=sa;password=****;initial catalog=cym1");

SqlCommand cmd =new SqlCommand("insert into uploadfile (filename) values (@filename)",conn);

SqlParameter sp=new SqlParameter("@filename",r,256);

="";

();

eNonQuery();

();

在SQLSERVER中，SQL语句参数是@+参数名，

insert into uploadfile (filename) values (@filename)

在定义此参数的参数变量⾥⾯参数要写@

SqlParameter sp=new SqlParameter("@filename",r,256);

2023年6月21日发(作者：)

C#中SQL语句参数写法OracleConnection oc=new OracleConnection("data source=osserver;User Id=****;password=**");

OracleCommand cmd=new OracleCommand("insert into file (filename,filecontent) values (:filename,:filecontent)",oc);

OracleParameter op1=new OracleParameter("filename",r,256);

OracleParameter op2=new OracleParameter("filecontent",,);

=eName();

(op1);

=filedata;

(op2);

();

eNonQuery();

();

在ORACLE中，SQL语句参数是：+参数名，

insert into file (filename,filecontent) values (:filename,:filecontent)

在定义此参数的参数变量⾥⾯参数名不⽤写：

OracleParameter op1=new OracleParameter("filename",r,256);

SqlConnection conn=new SqlConnection("data source=ccserver;user id=sa;password=****;initial catalog=cym1");

SqlCommand cmd =new SqlCommand("insert into uploadfile (filename) values (@filename)",conn);

SqlParameter sp=new SqlParameter("@filename",r,256);

="";

();

eNonQuery();

();

在SQLSERVER中，SQL语句参数是@+参数名，

insert into uploadfile (filename) values (@filename)

在定义此参数的参数变量⾥⾯参数要写@

SqlParameter sp=new SqlParameter("@filename",r,256);