public ActionResult View(GetUserData getUserData) { List<GetUserData> GetUserData = new List<GetUserData>(); string DefaultConnection = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; string query = "SELECT Email,UserName FROM AspNetUsers"; using (SqlConnection con = new SqlConnection(DefaultConnection)) { using (SqlCommand cmd = new SqlCommand(query)) { cmd.Connection = con; con.Open(); using (SqlDataReader sdr = cmd.ExecuteReader()) { while (sdr.Read()) { GetUserData.Add(new GetUserData { UserName = Convert.ToString(sdr["UserName"]), Email = Convert.ToString(sdr["Email"]) }); } } } con.Close(); } return View(getUserData); }
return View(getUserData);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)