你能把两个查询放到一个方法中吗？ [英] Can you put two query into one method?

问题描述

string querySStr =SELECT * FROM Food

string queryStr =SELECT * From Item

 SqlCommand cmd = new SqlCommand（queryStr ，queryStr，conn）; 

解决方案

检查出来：针对SQL Server执行多个SQL语句 [ ^ ]

string querySStr =SELECT * FROM Food; SELECT * From Item

试试这个。可能这是有帮助的。

您可以参考： executemultipleSQLstatementsusingaSqlCommandobject [ ^ ]

string querySStr = "SELECT * FROM Food"
string queryStr = "SELECT * From Item"

SqlCommand cmd = new SqlCommand(queryStr, queryStr, conn);

解决方案

Check this out: Executing multiple SQL statements as one against SQL Server[^]

string querySStr = "SELECT * FROM Food;SELECT * From Item"
try this. may be this is helpfull.

You can refer this:executemultipleSQLstatementsusingaSqlCommandobject[^]

这篇关于你能把两个查询放到一个方法中吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！