Exemplos de EDSNCalendar_ProjectBlue.SQLData SQLDataAdapter.Query4DataTableUser em C# (CSharp)

Exemplo n.º 1

        public static List <String> GetUserList()
        {
            DataTable dtUsers = new DataTable();
            string    sQuery  = "SELECT UserName FROM aspnetusers";

            dtUsers = SQLDataAdapter.Query4DataTableUser(sQuery);
            List <String> list = new List <String>();

            foreach (DataRow row in dtUsers.Rows)
            {
                list.Add(row["UserName"].ToString());
            }
            return(list);
        }