I need to develop a page in my applicaiton like the image for the user lists.
I need to get the list of users under a group and need to show likw this.
Given a particular user group id, how can we most quickly retrieve the list of users under that user group id?
View 2 Replies[Code]....
here i include my coding...
when i compile it..it show the data wit the noted data..
my question is...i want use dropdown menu to select the "category"...
how to use it? lets say i choose "Furniture" the output should be the data under Furniture category
I have some duplication that I need to clean up. I wrote a SQL query that is supposed to return duplicate customers who are located in the same city and zipcode.
I have 2 questions regarding it:
1. Is the query syntax correct to find duplicate records by same city and zipcode, data is being returned but it just returns the same customer a few times?
2. I only need to do the GROUP BY clause for Fullname and City however it gives an error when the other columns are left out. The error is Address, State and Zip not being in the aggregate function or in the group by clause.
Adding all the remaining columns to the GROUP BY clause works.
Query is as below:
[code].....
We have many different clients, and each client can have multiple user accounts.Right now, we have user settings set up on the ASP project, and a WinForms application can see these settings, depending on which user logs into the winforms application. They are specific to the user. I want to make them specific to the client, so users can be in "groups" by their client, and all users in the group would see/update the same settings.
View 1 RepliesI need to list a group of users, their group name is (IRS Group) to a list group. how to do this. I'm very new to asp.net and dont have much knowlegde about acctive directory.
View 1 Repliesi have these values in my generic list:
Product Name ItemCount Additional Info
Brioche & Jam 2
Almond Croissant 4
Mixed Salad(v) 20 No Onions
Mixed Salad(v) 5
What i am trying to do is group the duplicates so now the list would look like this:
Product Name ItemCount Additional Info
Brioche & Jam 2
Almond Croissant 4
Mixed Salad(v) 25 No onions
I'd like to gruop data from a table, for example, by DATE or CATEGORY, something like this:
29/01/2010
News 1
News 2
News 3
30/01/2010
News 1
News 2
News 3
or group by CATEGORY, like this:
ASP.NET
News 1
News 2
News 3
PHP
News 1
News 2
News 3
I have a list of ids properly stored in a List<>. I now need to Group list and get a count of the number of occurrences sorted descending.
Example:
List<string> aryIDs = new List<string>;
aryIDs.Add("1234");
aryIDs.Add("4321");
aryIDs.Add("3214");
aryIDs.Add("1234");
aryIDs.Add("4321");
aryIDs.Add("1234");
Would Produce:
"1234", 3
"4321", 2
"3214", 1
This would be easy in TSQL, but I would like to avoid the server roundtrip, unnecessary tables, etc. if possible.
Update: The VB.NET conversion for Ralph Shillington's answer below:
[code]....
Stack-Overflow :3 I've got a kind of hard-case question.
So I'll try clearly explain my idea with my poor english :/ need select to DataTable SOME values from ???_**GetDisplayData **procedure for each day of previos month (GROUP IT) where group rules for different columns is different
I need to select some values in stored procedure from other stored procedure like this :
SELECT X FROM Y_Procedure(@ProcedureParameters)Also I need to select from dynamic SQL Procedure like
Y_Procedure=@Y+'_Procedure'
SELECT X FROM Y_Procedure(@ProcedureParameters)
Also I need to load it to DataTable :-/INSERT INTO @Report (CellHorizontal, CellVertical, CellValue) --to TABLE
SELECT Date,X2,X3 FROM Y_GetDisplayData(@Param)
SET NOCOUNT OFF;
SELECT *
FROM @Report
GetDisplayData works as select with parameters and that doesn't returns SQL DataTable
And there is no way to recode GetDisplayData's procedures, it's just constant procedures for me.Finally I need to Group nodes from this table
INSERT INTO @Report (CellHorizontal, CellVertical, CellValue)
SELECT T1.Date,
IF ((Select grouptype...)=1) T1.X2 + T2.X2
ELSE IF ((Select grouptype...)=2) AVG(T1.X2,T2.X2),
IF ((Select grouptype...)=1) T1.X3 + T2.X3
ELSE IF ((Select grouptype...)=2) AVG(T1.X3,T2.X3),
(SELECT T2.Date,X2,X3 FROM Y_GetDisplayData(@Param) T2
WHERE T2.Date>T1.Date AND T2.Date>=T1.Date)
FROM Y_GetDisplayData(@Param) T1
GROUP BY EVERY DAY ???--and here is epic fail
I can make all stuff on asp server :And C# allows me to use something like SelectCommand = IzmProc + "_GetDisplayData"; And then I will work (select special data) with DataTables on ASP.NET Server but it's better to make all on SQL ... But looking like it's just unrealizable on SQL >_<
I gonna think about C# realization,but my code is very weird , got errors and doesn't works >_<
public static DataTable GetReport(string Param)
{
System.Configuration.ConnectionStringSettings connSetting = ConfigurationManager.ConnectionStrings["FlowServerConnectionString"]; [code].....
We had few distribution groups in our AD for emailing. To provide access to my application i use these groups to generate the license keys.
Microsoft clearly says "Distribution groups play no role in security (you do not assign permissions to distribution groups), and you cannot use them to filter Group Policy settings."
Is there any way to get the token access for the Distribution groups?
Just wondering how to implement a user's list into website ? im using ASP.NET C#. I want to be able to:
add/delete usersadd/remove roles
n a form I have multiple group of controls which are grouped using validation group property. I want to assign validation group to asp.Button dynamically on client side using javascript on the base of item selected in drop down list.
Here is JavaScript which I am using, but it is not working. It shows validation group undefined but actually a default group is defined.
<script type="text/JavaScript">
function NextClicked() {
var _ddlStatus = document.getElementById("<%=ddl.ClientID%>");
var _selectedIndex = _ddlStatus.selectedIndex;
var _btn = document.getElementById("<%=btnNext.ClientID%>");
alert(_btn.ValidationGroup); // here in messge it shows undefiend, yet I have defiend a group in button as default.
if (_selectedIndex == 1) {
_btn.ValidationGroup = "G1";
}
if (_selectedIndex == 2) {
_btn.ValidationGroup = "G2";
}
}
I'm using a linq group by query (with two grouping parameters) and would like to use the resulting data in a nested repeater.
var dateGroups = from row in data.AsEnumerable()
group row by new { StartDate = row["StartDate"], EndDate = row["EndDate"] };
"data" is a DataTable from an SqlDataAdapter-filled DataSet. "dateGroups" is used in the parent repeater, and I can access the group keys using Eval("key.StartDate") and Eval("key.EndDate").
Since dateGroups actually contains all the data rows grouped neatly by Start/End date, I'd like to access those rows to display the data in a child repeater. To what would I set the child repeater's DataSource? I have tried every expression in markup I could think of; I think the problem is that I'm trying to access an anonymous member (and I don't know how.) In case it doesn't turn out to be obvious, what would be the expression to access the elements in each iteration of the child repeater? Is there an expression that would let me set the DataSource in the markup, or will it have to be in the codebehind on some event in the parent repeater?
I created a distribution group in AD and now wish to search for an user and to add the user to that group. I have written the following code to add a group:
Code:
objGroup = root.Children.Add(strGroup, "group");
objGroup.Properties["displayName"].Add(strDisplayName);
objGroup.Properties["description"].Add(strDescription);
objGroup.Properties["groupType"].Value = ActiveDs.ADS_GROUP_TYPE_ENUM.ADS_GROUP_TYPE_GLOBAL_GROUP;
objGroup.CommitChanges();
Now I need to search for an user and to add the user to group if exists.. I have AD user id . Problem is that users are across the OU and I don't know the OU of each and every user. So i need to search for user across the AD and then to add to group... Need a code to do that..
is there a way i could find out how to get all the users in a group on my domain, i have a domain called "cot", within that domain we have multiple groups like "RO,Admin,PM,SPM and 2 or 3 more", i need to get all the users in a particular group, i am using vs2008 and coding on webforms with c#, i have tried various example i could find online but none have worked for me so far.
View 3 RepliesI want to use the Domain Users group to show all the users in a dropdown box. For some or other reason I cannot return all the users when looking for everyone under the domain so instead I was thinking of using the domain users group.This is part of my code:
[Code]....
[Code]....
I'm developing a Asp.Net website and I need to display the four most recent tweets from a group of users (around ten) that will be set in the admin area of the website. I know twitter has an API, but I don't know where to start.
View 3 RepliesI want to populate members of a local computer group on a webpage and allow the user to add / remove users of that remote computer from a group say Administrators or Remote Users Group.
The application pool will be running with a user who is admin on all remove systems.
Technologies involved:
ASP.NET Web-forms
Javascript (jQuery for instance)
Case,To make it clearer let's give the Stackoverflow Users list as an example. This list can be manipulated at client-side. I can search, page and so forth. So obviously we would need to call jQuery.ajax to retrieve the HTML of each page given a search. Alright. Now this leaves me with the first question:
What is the best way to render the response for the jQuery.ajax at server-side? I can't use templates I suppose, so the most obvious solution I think is to create the HTML tags as server-controls and render them as the result of an ASHX request? Nice. That solved we have yet another problem:
When the user first enters the Authors List the first list page should already come from the server completely rendered alright? Of course we could render the first page as well as an ajax call but I don't think it's better. This time I CAN use templates to render the list but this template couldn't be reused in case 1. What do I do?
Now the final question: Now we have 2 rendering strategies: 1) Client and 2) Server. How do I reuse code for the 2 renderings?
how to get the member of property of a active directory group?
I am using .NET 2 framework and c# laungauge.
Im using Visual Web Developer 2010 , ASP.NET and VB
Im using the "ASPNETDB.MDF" database for membership and others ,
1-- i created a gridview in my masterpage
2-- Connected to to " ASPNETDB.MDF" and "asp_Users Table"
3 -- Selected all
4-- My Select the Field "UserName"
Now im trying to get the On-line Users .
Im having a problem , becouse i can't see it when i debug the page, i changed the font , background color , i havent got any erros , what i need to do ?
group my chart which is being bind to a datasource, to be group according to years.
View 1 RepliesMy main file is messages.aspx and i am loading a UC names message_inbox.ascx dynamically as:
SiteUserControls_Message_MessageInbox InboxUC = Page.Load("message_inbox.ascx") as
SiteUserControls_Message_MessageInbox
Now in my user control ("message_inbox.ascx") i have a various events which i am combining in one group event :
public void ForwardLinkButton_OnClick(object sender, EventArgs e)
I've noticed that page load time increases dramatically as you load up a ddlistbox with items. 10,000 or so results in a pretty much unacceptable wait time for my setup. The dropdown I'm trying to load is Airports - like all of them. What are some alternative UI solutions that give the user the ability to easily select any (literally) airport, but without a ginormous page loading time? (Currently the dd is keyed to the airport's 3 letter code, so it's convenient for the prepared user to just type the 3-letter code and have the right airport selected. The display is then set to code, city, country.)
View 7 Replies
