如何在表单中调用以下方法并将数据填充到列表视图中 [英] How do I call the following method in a form and populate data in to list view

问题描述

internal class UserAccount
    {
        public long UserId { get; set; }
        public string FName { get; set; }
        public string MName { get; set; }
        public string LName { get; set; }
        public string UserName { get; set; }
        public string Password { get; set; }
        public long RoleId { get; set; }

        public UserAccount[] GetUserAccount(long[] UserId)
                {
                    SqlConn conn = new SqlConn();
                    conn.openConnection();
                    try
                    {
        
                        string sql = " select * from UserAccount";
                        if (UserId[0] != -1)
                        {
                            int i = 0;
                            sql += " where UserId in ( ";
                            foreach (long UID in UserId)
                            {
                                if (i == UserId.Length - 1)
                                    sql += UID + " ) ";
                                else
                                    sql += UID + ",";
                                i++;
                            }
                        }
                        DataTable dt = null;
        
                        ArrayList arrList = new ArrayList();
                        dt = conn.GetTable(sql);
                        if (dt != null)
                        {
                            foreach (DataRow dr in dt.Rows)
                            {
                                UserAccount ua = new UserAccount();
                                ua.UserId = (long)dr[0];
                                ua.FName = dr[1] as string;
                                ua.MName = dr[2] as string;
                                ua.LName = dr[3] as string;
                                ua.UserName = dr[4] as string;
                                ua.Password = dr[5] as string;
                                ua.RoleId = (long)dr[6];
                            }
        
                        }
                        UserAccount[] user = new UserAccount[arrList.Count];
                        arrList.CopyTo(user);
                        return user;
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                    finally { conn.closeConnection(); }
                }
}

推荐答案

尝试

从DataTable填充列表视图 [< a href =http://social.msdn.microsoft.com/Forums/en-US/eac31f73-58c0-4149-8d9b-ceabc805f001/populate-a-listview-from-datatabletarget =_ blanktitle =新窗口> ^ ]

如何使用SqlDataReader填充Listview [ ^ ]



视频 - http://www.youtube.com/watch?v=LxeM010HLJI [ ^ ]。

Try
Populate List View from a DataTable[^]
How Can I Populate Listview With SqlDataReader[^]

Video - http://www.youtube.com/watch?v=LxeM010HLJI[^].

这篇关于如何在表单中调用以下方法并将数据填充到列表视图中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！