存储过程值到列表 [英] Stored procedure value to a list

问题描述

我有一个存储过程可以得到一个表，请告诉我如何将所有值都列入列表。

请帮助您获取示例代码，如果可能的话

Hi,
I have a stored procedure which gets a table, Please tell how can i get all the values to a list.
Please help with a sample code, if possible

推荐答案

您好，



假设以下是您的DataTable返回存储过程..

Hello,

Suppose following is your DataTable which return Stored Procedure..

DataTable dtExample = new DataTable("Example");
dtExample.Columns.Add("EmpID");
dtExample.Columns.Add("Name");

如果你有以下类似

If You have following Class like

public class Employees
{
        public String EmpID { get ;  set ;}
        public String Name{ get ;  set ;}
}

创建将从DataRow返回Employee Class的函数

Create function that will be return Employee Class from DataRow

private Employees GetEmpDataTableRow(DataRow dr)
{
     Employees oEmp = new Employees();
     oEmp.EmpID = dr["EmpID"].ToString();
     oEmp.Name = dr["Name"].ToString(); 
     return oEmp ;
}

最后使用Loop调用它

Finnally call it using Loop like

//Create List of Employees Class
List<employees>  objEmpList=new List<employees>();

//dtExample = Your Stored Procedure Result
  foreach (DataRow row in dtExample.Rows)
           objEmpList.Add(row);


//Finnaly you get List in objEmpList

</employees></employees>

这篇关于存储过程值到列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！