c# 读取数据库数据方法

1. lambda表达式

例如：

var list = LocationInfoProvider.GetLocations().Where(x => x.ParentId == 0).Select(x => new LocationInfo
{
LocationID = x.LocationID,
LocationName = x.LocationName
}).ToList();

 

 

2.通过QueryParameters方法获取数据

DataTable dt = null;
using (GeneralConnection gc = ConnectionHelper.GetConnection())
{
QueryDataParameters qd = new QueryDataParameters();
QueryParameters qp = new QueryParameters(sqlstr, qd, QueryTypeEnum.SQLQuery, true);
dt = gc.ExecuteQuery(qp).Tables[0];

for (int i = 0; i < dt.Rows.Count; i++)

{

//获取 字段数据

var a = dt.Rows[i]["字段名"].ToString();

}
}

sqlstr : sql表达式