List<Ex_User> exUserList = new List<Ex_User>();

Ex_User exUser = new Ex_User();



string strSql="select ID,Name,LOGINNAME,PASSWORD,CGROUP,VALIDSTATUS from UM_User";



string strConn=@"Data Source=.;Initial Catalog=usermanagement;User  Id=sa;Password=111";

            using (SqlConnection conn = new SqlConnection(strConn))

            {

                conn.Open();

                using (SqlCommand cmd = conn.CreateCommand())

                {

                    cmd.CommandText = sbSql.ToString();

                    SqlDataReader reader = cmd.ExecuteReader();

                    if (reader.HasRows)

                    {

                        while (reader.Read())

                        {

                            exUser.ID = Convert.ToInt64(reader["id"]);

                            exUser.NAME = reader["NAME"].ToString();

                            exUser.LOGINNAME = reader["LoginName"].ToString();

                            exUser.CGROUP = (int)reader["cGroup"];

                            exUser.VALIDSTATUS = (int)reader["ValidStatus"];

                            exUser.PASSWORD = reader["Password"].ToString();

                            exUserList.Add(exUser);

                        }

                    }

              &