internal SqlBrowserTreeView(ConnectionCollection connCol) : this() { this.BeginUpdate(); try { RainstormStudios.Collections.StringCollection colDatasource = new StringCollection(); for (int i = 0; i < connCol.Count; i++) { colDatasource.AddUnique(rsData.GetDataSource(connCol[i].ConnectionString), i.ToString()); } for (int i = 0; i < colDatasource.Count; i++) { Connection cn = connCol[int.Parse(colDatasource.GetKey(i))]; if (rsDb.IsSQL(cn.ConnectionString, cn.DatabaseProvider)) { TreeNode ndDb = new TreeNode(colDatasource[i]); ndDb.Tag = new rsDbSql(cn.ConnectionString); //ndDb.Name = cn.Name + "-" + cn.DatabaseProvider.ToString(); ndDb.Name = colDatasource[i]; ndDb.Nodes.Add("<EMPTY>"); ndDb.ImageIndex = 1; ndDb.SelectedImageIndex = 1; ndDb.ContextMenuStrip = this.mnuNdGroup; this.Nodes.Add(ndDb); } } } catch (Exception ex) { this.Nodes.Clear(); this.Nodes.Add("An Error Occured:"); this.Nodes.Add(ex.Message); } finally { this.EndUpdate(); } }
public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords) { MembershipUserCollection users = new MembershipUserCollection(); try { using (DataSet ds = this.OpenXml()) { DataRow[] dr = this.SearchByFieldValue(ds, "Users", "Username", usernameToMatch, pageIndex, pageSize); StringCollection usrNms = new StringCollection(); for (int i = 0; i < dr.Length; i++) usrNms.Add(dr[i]["LoweredUserName"].ToString(), i.ToString()); usrNms.Sort(Collections.SortDirection.Ascending); for (int i = 0; i < usrNms.Count; i++) { DataRow drUsr = dr[int.Parse(usrNms.GetKey(i))]; users.Add(this.PopulateMembershipUser(drUsr, this.GetMembershipEntry(drUsr["UserId"], ds))); } //for (int i = 0; i < dr.Length; i++) // users.Add(this.PopulateMembershipUser(dr[i], this.GetMembershipEntry(dr[i]["UserId"], ds))); totalRecords = ds.Tables["Users"].Rows.Count; } } catch { throw; } return users; }
public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords) { try { MembershipUserCollection users = new MembershipUserCollection(); using (DataSet ds = this.OpenXml()) { StringCollection usrNms = new StringCollection(); for (int i = 0; i < ds.Tables["Users"].Rows.Count; i++) usrNms.Add(ds.Tables["Users"].Rows[i]["LoweredUserName"].ToString(), i.ToString()); usrNms.Sort(Collections.SortDirection.Ascending); for (int i = 0; i < usrNms.Count; i++) { DataRow drUsr = ds.Tables["Users"].Rows[int.Parse(usrNms.GetKey(i))]; users.Add(this.PopulateMembershipUser(drUsr, this.GetMembershipEntry(drUsr["UserId"], ds))); } //for (int i = 0; i < ds.Tables["Users"].Rows.Count; i++) // users.Add(this.PopulateMembershipUser(ds.Tables["Users"].Rows[i], this.GetMembershipEntry(ds.Tables["Users"].Rows[i]["UserId"], ds))); totalRecords = ds.Tables["Users"].Rows.Count; } return users; } catch { throw; } }