C# Using ActiveDir To Get Names Under A Managers Org Chart?
Nov 30, 2010
i am using ODBC to pull data from active directory to get the email for a particular username using the code below.
how can i use AD to pull all the usernames of peolel who report into a prticular manager?
i can transverse the org chart in outlook so im thinking i can do the same using AD...
System.Data.OleDb.OleDbConnection con;
System.Data.OleDb.OleDbCommand cmd;
con = new System.Data.OleDb.OleDbConnection("Provider=ADsDSOObject;dsn=Active Directory Provider");
con.Open();
//Create a command object on this connection
string strSQL = "SELECT mail FROM 'LDAP://DC=amrs,DC=win,DC=ml,dc=COM' WHERE samaccountname = '" + UserName.Replace(@"AMRS", "") + "'";
cmd = new System.Data.OleDb.OleDbCommand(strSQL, con);
try
{
return Convert.ToString ( cmd.ExecuteScalar() );
}
catch (System.Data.OleDb.OleDbException exc)
{
return "ERROR: " + exc.ToString();
}
finally
{
con.Close();
}
View 1 Replies
Similar Messages:
Nov 17, 2010
Iīve got a chart control (column type) and must show many elements at y axis, but when system generates the chart draw, itīs shows only odd elements: For example: My chart must show a colunm containing systems (x) and error incidences (y):
1. SIEMP
2. SISOUT
3. SIGTI
4. SISFIN
5. SISPL
6. SISTER
But itīs only shows:
1. SIEMP
2.
3. SIGTI
4.
5. SISPL
6.
I must set a parameter that forces "all" series to be showed.
View 2 Replies
Jun 10, 2010
Using two ScriptManagers(ASP.Net and Telerik) will effect the page performance ?I have both ASP.Net and Telerik Controls on the same page and I'm using both ASP.Net and Telerik Script managers. Can I avoid using one script manager ? How will the page performance is varried if I use two script managers ?andRefering Source/SCript files in one Script manager can be used accross the other controls ?
View 1 Replies
Jun 1, 2010
I have been working with this database for some time. Here is the situation...
I inherited a MS SQL database that has hundreds of tables with similar data. For instance:
FordTampa_customer is a table,
ChevyAtlanta_customer is a table, etc....
All of the columns are the same...just different tables with their own ID field. All I have done...Inside of another database id is created a table called 'Customer' and added an 'Dealer ID' column along with the rest of the other columns in the other tables...
So the combination of the 'Dealer ID' and the 'ID' field are unique.....I know...its not the best way to do things...but I cannot change the old data structure because I cannot have access to it. I am give back-ups on a weekly basis, so this is all I have to work with.
All right, on to the real point of my post...
Currently, I have an application that I use to select all of the data from the 'Ford_customers','Chevy_customers',etc... and inserts them into my new main 'Customer' table. I do this by selecting the table names, bind it to an arraylist, loop through the list and execute an insert statement.
I do this in VB.NET, but I would prefer to do it in a Stored procedure of some kind....I just am not sure how to accomplish it. I use this syntax to get my list of tables:
[Code]....
I am not sure how to take those names from the table and do another select based on that list of names.
View 1 Replies
Jan 26, 2011
Can anyone point me in the right direction to how I would handle capturing bounced email info. I'm looking into writing an email campaign manager and would like the ability to report that data.
View 2 Replies
Apr 28, 2010
I have the following generic lifetime manager
[code]...
causes the following error
Cannot create an instance of UI.Common.Unity.RequestLifetimeManager`1[T] because Type.ContainsGenericParameters is true.How do you reference generic lifetime managers?
View 1 Replies
Jan 26, 2011
I'm creating an LDAP class that contains a function that returns the managers username of the current user.
I know that I can use the "manager" attribute to return CN="name", OU="group", DC="company" etc.I specifically want the managers username, does anyone know if there is an attribute string that I can send to LDAP that specifically gets the managers username only? If not, is there an alternative method to do so?
View 2 Replies
Apr 23, 2010
When I run my app locally I get no errors. No error from Global.asax, no redirection to an error page. Everythings works fine.
When I deploy my app to a test server, my app run there with no errors. No error from Global.asax, no redirection to an error page. Everythings works fine on the test server.
But when I deploy my app to production server, the app runs fine but I keep getting errors (emailed to me) from Global.asax. On production server we have these security apps that run and keep hitting all URLs of the app on the server. Just to make sure they are working fine. When these security app hit URL of my app, my application runs fine but it gives out this global.asax error. The funny thing is that error is empty. The error are emailed to me and the email is empty. Nothing there.
There are several other apps running on the same server. My app has its own app pool and is configured correctly.
View 4 Replies
Jul 9, 2010
I have an issue in using dot net chart control. In chart last column is not completely shown which give bad appearance and on right side of chart it looks like TickMark are enabled. I set MajorTickMark of AxisY2 disabled but still tick marks on right side.
View 2 Replies
Feb 24, 2010
how to freeze the x axis of the chart control in ms chart? need to use because data displayed at large amount that is scrollable.
View 1 Replies
Jan 28, 2011
I have a drop downlist,and next to it there is an MS bar chart.i want to change the datate of the MS chart ,once the user selects another year from the dropdownlist.
When the page loads ,the chart displays the default year(2011) and it works.The problem is that is does not change the data when you select another year from the dropdownlist.
View 1 Replies
Apr 28, 2010
Am I going mad/blind? Probably a combination of the two.
How does one go about removing the data labels from a pie chart with the new chart control in .net 4?
I can get these to display as tooltips absolutely fine, but ultiamtely I'd like the labels not to be present as it looks rather busy.
I've searched previous answers and seen code behind resolutions but surely there must be some sort of code infront option to turn these labels off?
View 2 Replies
Aug 12, 2010
I am using MS Chart control (3.5), and have a requirement where I need to display 2 pie charts. The datapoints for the pie charts is set programatically. My doubts are as follows:
1. Can I display both the pie charts in a single chart control and area, or do I have to use two controls? (Currently I am using two controls)
2. How can I maintain the same size for both the pie charts? This is my main concern, since the pie sizes keep changing, depending on the number of datapoints. I tried using custom properties like "MinimumRelativePieSize", but it's not working.
View 1 Replies
Nov 17, 2010
i'm trying to create a stacked bar chart on a vb web form using vs2010.My data source returns:
Error in Functionality Awaiting on Supplier
1IMT IssuesmActive6
IMT Issues,Awaiting on Supplier
2,IMT Issues,Awaiting on User 4
IMT Issues Closed 120
Login / Password Active
But I can't get this into a stacked chart. I know I must have to do quite a bit of work declaring what the series are and soforth, or having a different dataset but can't find any documentation on it.A link to some documentation or an example of a stacked chart from an sql datasource would be much appreciated.
View 1 Replies
May 21, 2010
I started using the awesome chart controls with my asp.net apps recently and so far they've been nothing short of breath taking. Right now I have a weird problem, on the first load of my page, the chart control appears correctly and the tooltip is correct, however, when I update it with new data, the chart displays correctly, but the tooltips are for the previous set of data.
I hope this makes sense. The first time I load the chart, the pie chart segments and tooltips are correct, after a partial postback (to get the new data), the pie chart segments are correct but the tooltips are for the previous data set.
Basically once the tooltips are set the first time, they can't be updated after that without a full page postback.
Here's how I set the tooltip:
[Code]....
Anyone else noticed this behaviour and have a work around?
Currently my only workaround is to check for a partial postback and not render the tooltip, which I'd rather not do as the tooltip display actual statistical data as opposed to the pie itself (which uses percentages).
View 2 Replies
Jul 19, 2010
I have X and Y data columns coming from database.
I have to show scatter plot chart with Linear, Exponential, Log, power using asp.net chart control.
How to do that?
View 2 Replies
Apr 21, 2010
Does anyone know how to explode a certain section of the piechart, which is part of microsoft chart controls?
View 5 Replies
Jan 16, 2014
I referred this link [URL] ...
In order to add pie chart into my website, but i want to remove black border and add % sign to the numbers showing graph and also want to set colours in pie chart based on my website theme.
View 1 Replies
Jun 7, 2010
im trying to create simple pie chart using the MS Chart controls. When my pie chart gets rendered in the browser i get padding around the pie chart that i cant get rid of. i would like the pie chart to sit up against the edge of the image with no padding or margin. in my code below the padding is highlighted in blue. i.e Chart1.BackColor = System.Drawing.Color.Blue;
<script type="text/C#" runat="server">
protected void Page_Load(object sender, EventArgs e)
{
//Set the chart type
Chart1.Series["Series1"].ChartType = SeriesChartType.Pie;
//add points
Chart1.Series["Series1"].Points.AddY(12);
Chart1.Series["Series1"].Points.AddY(45);
Chart1.Series["Series1"].Points.AddY(67);
//set back color of chart object
Chart1.BackColor = System.Drawing.Color.Blue;
//set back color of chart area
Chart1.ChartAreas["ChartArea1"].BackColor = System.Drawing.Color.Green;
}
</script>
<asp:Chart ID="Chart1" runat="server">
<Series>
<asp:Series Name="Series1" ChartType="Pie">
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea1">
</asp:ChartArea>
</ChartAreas>
</asp:Chart>
View 1 Replies
Dec 22, 2010
I'm trying to put Google's BarChart and PieChart both the client side version, and i'm experiencing some problems with the labels over the pie and the labels on the left of the vertical axis (of the bar chart).
I checked the code a lot of times and it seems to be like that you can see in the examples.I've tried the same page on Firefox and Chrome and it shows the labels without problems.If i try the examples on IE8 the labels are shown but not in my page.Sincerely I've not any idea where to start to fix this thing.
View 1 Replies
Jan 28, 2011
Is it possible to specify what color each section of the pie looks like? Also, is it possible to display the legend on the side?
For ex: in the chart below, can I some specify that , "Pass" shows up as green, Fail as red and unknown as grey?
public ActionResult GetRainfallChart()
{
var key = new Chart(width: 600, height: 400).AddSeries(
chartType: "pie",
legend: "Test pass",
xValue: new[] { "Pass", "Fail", "Unknown" },
yValues: new[] { "50", "30", "20" })
.Write();
return null;
}
If its not possible with the "chart" control that comes in System.Web.Helpers assembly, then can someone point me how to do this with asp.net control for webforms in a MVC project
View 3 Replies
Jul 27, 2010
I am having a problem with my visual studio and crystal report. It's my first time using it.
When I add a new crystal report to my project, and try to add a chart, the chart menu is greyed out. Do I need to download any addin or I have missed out some .dll.
View 1 Replies
Jan 5, 2011
I am a novice programmer using ms chart control for my dashboard, I have a problem displaying chart series.
Here is my sample query & result
Sample Query: "SELECT Brand, sales, Manufacturer From TABLE"
Sample Result:
[code]....
How can I display BrandA for XValueMember & Salesvalue(10000) for YValueMembers as Series1 having a column chart type.
And to display BrandY & BrandZ for XValueMember ; Salesvalue for YValueMembers as Series2 having a line chart type.
I want my chart to have 2 Y-axis; Series1 for primary Y-axis & series2 for secondary Y-axis.
My problem here is how can I display BrandA in Series1 and BrandY,BrandZ in Series2 where the values are in the same field?
Or is it possible to set more than one data source for the chart control?
I've been working on this for two days but I wasn't able to get the desired result.
View 1 Replies
May 13, 2010
I am having a requirement, where I need to have a pie-chart, i need text around pie-chart , the text should be a hyperlink. Ex: we have 3 three fields A,B,C. A's ratio is 30%, B's ratio is 40%, c's ratio is 30% So pie chart gets divided into 3 parts, outside the graph , we should get the label A(in A's area only), when we point on , tool tip should say "A's ratio is 30 %'. I am working in .Net 3.5, VS 2008, using MS chart control(added explicitly by executing MSChart.exe.
View 1 Replies
Mar 12, 2010
I'm having problem with MS Chart chart type column. If there are only 9 bar in the chart like the following picture, then the axis-x label show up properly.
However, there are more than 9 bars bar the chart, the axis-x label wont show up properly, some of them just dissappear.
Here's my mark-up for the chart:
[code]....
I don't know it works with only 9 bars? Is there any way to make the chart work properly? Also, if possible, how to make each bar have different color.
View 5 Replies