如何显示列表<>在gridview ASP.NET C＃中 [英] How to display list<> in gridview ASP.NET C#

问题描述

大家好。我在asp.net c＃中有DAL代码，用于选择DB sql server中我table_users的所有用户。



我的DAL：

hi all. I have DAL code in asp.net c# for select all user of my table_users in DB sql server.

my DAL :

public string UserName
    {
        get { return _UserName; }
        set { _UserName = value; }
    }
    private string _Pass;

    public string Pass
    {
        get { return _Pass; }
        set { _Pass = value; }
    }
    private string _Name;

    public string Name
    {
        get { return _Name; }
        set { _Name = value; }
    }
    private string _Family;

    public string Family
    {
        get { return _Family; }
        set { _Family = value; }
    }

    private string _Mobile;

    public string Mobile
    {
        get { return _Mobile; }
        set { _Mobile = value; }
    }

public List<Users> GetAllUsers()
        {
            List<Users> usersList = null;

            using (DataTable table = SqlDBHelper.ExecuteSelectCommand("GetAllUsers", CommandType.StoredProcedure))
            {
                if (table.Rows.Count > 0)
                {
                    usersList = new List<Users>();

                    foreach (DataRow row in table.Rows)
                    {
                        Users user = new Users();

                        user.UserName = table.Rows[0]["UserName"].ToString();
                        user.Pass = table.Rows[0]["Pass"].ToString();
                        user.Name = table.Rows[0]["Name"].ToString();
                        user.Family = table.Rows[0]["Family"].ToString();
                        user.Mobile = table.Rows[0]["Mobile"].ToString();

                        usersList.Add(user);
                    }
                }
            }
            return usersList;
        }

和我的BLL电话代码：

and my BLL code for call:

public List<Users> GetAllUsers()
      {
          return userDB.GetAllUsers();
      }

现在我想在网格视图中调用显示数据的方法。

and now I want to call method for display data in grid view .

public List<Users> usersList = null;
            UsersHadler userDB = new UsersHadler();
            usersList = userDB.GetAllUsers();
            foreach (Users user1 in usersList)
            {
                GridView1.DataSource = usersList;
                GridView1.DataBind();
            }

我有3个用户，数据为base.uer1，user2和user3为

< b>问题是我在gridview 3中看到一个user1。

user1

user1

user1

有什么不对。？

感谢您的回复



我的尝试：



我更改代码：

I have 3 user in data base.uer1 and user2 and user3
the problem is that I see in gridview 3 row for one user1.
user1
user1
user1
what is wrong.?
thanks for reply

What I have tried:

I change code:

GridView1.DataSource = userDB.GetAllUsers();
GridView1.DataBind();

我有同样的问题

but I have the same problem

推荐答案

无需使用循环来绑定数据，但是它会一次又一次地绑定相同的数据

No need to use the loop to bind the data, however it will bind the same data again and again

foreach (Users user1 in usersList)
           {
               GridView1.DataSource = usersList;
               GridView1.DataBind();
           }

查看此存储过程 GetAllUsers 是否返回重复记录。除了你的代码看起来很好

Check this Stored Procedure GetAllUsers whether it is returning duplicate records or not. other than that your code looks fine

你好。



我看到你的代码你到目前为止所尝试的，没有什么错误但我不确定 GetAllUsers 的存储过程为 Karthik 告诉你，你能在这里分享你的存储过程吗？我们可以帮助您找到解决方案。



您可以从列表中调用此代码来绑定数据

Hi.

I saw your code what you have tried so far, there is nothing wrong in that but I am not sure stored procedure of GetAllUsers as Karthik told, Can you share your stored procedure here. so that we can help you find the solution.

You can call this code for binding data from List

List<Users> usersList=userDB.GetAllUsers();
GridView1.DataSource = usersList;
GridView1.DataBind();

这篇关于如何显示列表&lt;&gt;在gridview ASP.NET C＃中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！