加载带有列表的网格视图

本文关键字：网格 视图 列表 加载 | 更新日期: 2023-09-27 17:58:53

我有一个列表，其中包含我想在网格视图上显示的所有行。我从数据层上的数据读取器获取这些行，一旦我将列表调用到表示层，我就想将列表结果绑定到gridview。有办法做到这一点吗？下面的代码。

数据层查询和数据读取器，以获取行的所有数据

public class SubmissionDatabaseService
{
    public List<Submission> GetAllSubmissions()
    {
        string Searchstring = "SELECT Submission.SubmissionId, Customer.CustName, Customer.CustCity, Customer.CustState, Broker.BroName, Broker.BroState, Broker.EntityType, Submission.Coverage, Status.Status FROM Submission INNER JOIN Broker ON Broker.BroId = Submission.BroId INNER JOIN Customer ON Customer.CustId = Submission.CustId INNER JOIN Status ON Status.StatusId = Submission.StatusId";
        string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
        SqlConnection conn = new SqlConnection(connectionString);
        SqlDataReader dr = null;
        List<Submission> lstSubmission = new List<Submission>();
        conn.Open();
        SqlCommand Searchcmd = new SqlCommand(Searchstring, conn);
        dr = Searchcmd.ExecuteReader();
        Submission tempSubmission;
        while (dr.Read())
        {
            tempSubmission = new Submission();
            tempSubmission.setSubmissionId(dr.GetInt32(0));
            tempSubmission._Cust.setCustName(dr.GetString(1));
            tempSubmission._Cust.setCustCity(dr.GetString(2));
            tempSubmission._Cust.setCustState(dr.GetString(3));
            tempSubmission._Bro.setBroName(dr.GetString(4));
            tempSubmission._Bro.setBroState(dr.GetString(5));
            tempSubmission._Bro.setEntity(dr.GetString(6));
            tempSubmission._SubCov.setCoverage(dr.GetInt32(7));
            tempSubmission.setStatus(dr.GetString(8));
            lstSubmission.Add(tempSubmission);
        }
        return lstSubmission;
    }
}

业务逻辑层

public class SubmissionService
{
    public SubmissionService() { }
    private Array _getllsubservice;
    public Array Getallsubservice
    {
        get { return _getllsubservice; }
        set { _getllsubservice = value; }
    }
    public List<Submission> getAllSubmission()
    {
        SubmissionDatabaseService sds = new SubmissionDatabaseService();
        return sds.GetAllSubmissions();
    }
}

表示层

SubmissionService ss = new SubmissionService();
List<Submission> SubmissionsList = ss.getAllSubmission();`

加载带有列表的网格视图

要将数据加载到网格视图中，只需尝试：

yourgrid.DataSource=SubmissionsList;
yourgrid.DataBind();

这里有用的东西：

如何绑定列表<myclass>数据与gridview？

或此处：

将列表绑定到GridView

相关文章：