本文介绍了使用SQL查询从特定部门筛选数据，并将查询结果转换为特定格式的过程，包括设置参数、执行查询和数据转换。
var result = new List<MyDataType>();
using (var conn = SqlHelper.OpenConnection())
{
var cmd = SqlHelper.GetCommand(conn, "select * from [table] where depart='技术部' and name<>@name");
SqlHelper.SetParameter(cmd, "name", "张三");
result = (from IDataRecord rd in cmd.ExecuteReader()
select new DataType
{
Name = (string)rd["Name"],
Cost = (decimal)rd["Cost"]
}).ToList();
}
using (var conn = SqlHelper.OpenConnection())
{
var cmd = SqlHelper.GetCommand(conn, "select * from [table] where depart='技术部' and name<>@name");
SqlHelper.SetParameter(cmd, "name", "张三");
result = (from IDataRecord rd in cmd.ExecuteReader()
select new DataType
{
Name = (string)rd["Name"],
Cost = (decimal)rd["Cost"]
}).ToList();
}
扫一扫
164
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
