public MembersDataset GetMembers() { //Load a list of Member selections MembersDataset ds = new MembersDataset(); MembershipUserCollection members = Membership.GetAllUsers(); foreach (MembershipUser member in members) { MembersDataset.MembershipTableRow row = ds.MembershipTable.NewMembershipTableRow(); row.UserName = member.UserName; row.Password = ""; row.Email = member.Email; row.IsApproved = member.IsApproved; row.IsLockedOut = member.IsLockedOut; row.CreateDate = member.CreationDate; row.LastLoginDate = member.LastLoginDate; row.Comment = member.Comment; row.IsOnline = member.IsOnline; row.LastActivityDate = member.LastActivityDate; row.ClientID = GetMemberProfile(member.UserName).ClientID; ds.MembershipTable.AddMembershipTableRow(row); } ds.AcceptChanges(); return(ds); }
public MembersDataset GetMembers() { //Load a list of Member selections MembersDataset ds = new MembersDataset(); MembershipUserCollection members = Membership.GetAllUsers(); foreach (MembershipUser member in members) { MembersDataset.MembershipTableRow row = ds.MembershipTable.NewMembershipTableRow(); row.Comment = member.Comment; row.CreateDate = member.CreationDate; row.Email = member.Email; row.IsApproved = member.IsApproved; row.IsLockedOut = member.IsLockedOut; row.IsOnline = member.IsOnline; row.LastActivityDate = member.LastActivityDate; row.LastLockoutDate = member.LastLockoutDate; row.LastLoginDate = member.LastLoginDate; row.LastPasswordChangedDate = member.LastPasswordChangedDate; row.PasswordQuestion = member.PasswordQuestion; row.UserName = member.UserName; ProfileCommon profile = new ProfileCommon().GetProfile(member.UserName); row.UserFullName = profile.UserFullName; row.Company = profile.Company; ds.MembershipTable.AddMembershipTableRow(row); } ds.AcceptChanges(); return(ds); }
private void MemberReport_Load(object sender, EventArgs e) { RptMembers Report1 = new RptMembers(); MembersDataset dsMembers = GetData(); Report1.SetDataSource(dsMembers); this.crystalReportViewer1.ReportSource = Report1; this.crystalReportViewer1.RefreshReport(); }
private void ContributionReport_Load(object sender, EventArgs e) { RptContributions Report1 = new RptContributions(); MembersDataset dsContr = GetData(); Report1.SetDataSource(dsContr); this.crystalReportViewer1.ReportSource = Report1; this.crystalReportViewer1.RefreshReport(); }
private MembersDataset GetData() { string constr = @"Data Source=DESKTOP-V5221FL\SQLEXPRESS;Initial Catalog=SACCO;Integrated Security=True"; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand("SELECT TOP 20 * FROM Members")) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (MembersDataset dsCustomers = new MembersDataset()) { sda.Fill(dsCustomers, "Members"); return(dsCustomers); } } } } }