高手进,花费1分钟帮我看看这个问题,十分感谢!
string strSql= "insert into MovieUrl ([no],[Url],[NameID]) values (@no,@Url,@NameID) in (select * from MovieList,MovieUrl where "+title+ "=movielist.title; ";
这里哪里错了呢,改怎么写呢!谢谢!
------解决方案--------------------string strSql= "insert into MovieUrl ([no],[Url],[NameID]) values (@no,@Url,@NameID) 到这块看懂了,后面看不懂。帮顶一下。
up
------解决方案--------------------values (@no,@Url,@NameID)
这里面不能直接用@aa吧
------解决方案--------------------字符串的要加上单引号
(select * from MovieList,MovieUrl where "+title+ "=movielist.title; ";
~~~~~~~~~~~~~~
(select * from MovieList,MovieUrl where ' "+title+ " '=movielist.title; ";
------解决方案--------------------既然用了這個 @no,@Url,@NameID ,是不是要用sqlcommand 給它們賦值呀