什么是code用最小号线将生成一个数据表
此SQL查询?
SELECT *
FROM [表1]
WHERE([日] @之间date1和@ DATE2)和
([字段1]为空或[字段2] IS NULL)
解决方案
使用 SqlDataAdapter的填写的DataTable。
DataTable的DT =新的DataTable();
使用(SqlConnection的yourConnection =新的SqlConnection(ConnectionString的))
{
的SqlCommand CMD =新的SqlCommand(......你的SQL语句,yourConnection);
SqlDataAdapter的DA =新的SqlDataAdapter(CMD);
da.Fill(DT);
}
使用使用 块以您的SqlConnection。还可以使用参数查询
What is the code with the smallest number of lines that will generate a DataTable
from this SQL query?
SELECT *
FROM [Table1]
WHERE ([Date] BETWEEN @Date1 AND @Date2) AND
([Field1] IS NULL OR [Field2] IS NULL)
解决方案
Use SqlDataAdapter to fill a DataTable.
DataTable dt = new DataTable();
using (SqlConnection yourConnection = new SqlConnection("connectionstring"))
{
SqlCommand cmd = new SqlCommand("....your sql statement", yourConnection);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
use using block with your SqlConnection. Also use Parameterized query