DataSet ds = new DataSet()
DataSet dt= ds.Tables[0]
或
var dt = DbHelperOra.GetTable($"select * from B_CERTIFICATE_SUB where C_GUID={C_IDList[i]}");
DataTable遍历取值:
List<string> SqlList = new List<string>();
for (int j = 0; j < dt.Rows.Count; j++)
{
SqlList .Add(dt.Rows[j]["name"].ToString());
}