cmd="insert into mail (xm,dz,yb,lxdh,dzyj,bxm,bdw,xflx,jjjcdx,nr,crtime,ipadress) values ("+xm+","+dz+","+yb+","+lxdh+","+dzyj+","+bxm+","+bdw+","+xflx+","+jjjcdx+","+nr+","+crtime+","+ipadress+")";这么做行么?
这种方法是通用的,就是拼凑,但是不推荐! 毛病多了!还是用参数 dim cnn as new sqlconnection("server=localhost;....") dim cmd as new sqlcommand("select * from table where id=@id",cnn) cmd.parameters.add("@id",txtID.text)
毛病多了!还是用参数
dim cnn as new sqlconnection("server=localhost;....")
dim cmd as new sqlcommand("select * from table where id=@id",cnn)
cmd.parameters.add("@id",txtID.text)