Extract Only One Of The Columns For All The Department-objects?

Jun 14, 2011

I have a collection of a DTO, Department, and would like to extract only one of the columns for all the Department-objects. I know that in C# you can do like this:

List<Department> departments = corporation.GetDepartments();
List<int> departmentIDs = departments.ConvertAll(dep => dep.ID);

Out from my understanding this is use of LINQ, with the argument to ConvertAll() being a lambda expression.

When trying to achieve the same in VB, it seems that one must define a Converter-method:Dim departmentIDs As List(Of Integer) = coll.ConvertAll(New Converter(Of Department, Integer)(AddressOf ConvertDepartmentToInt))Public Shared Function ConvertDepartmentToInt(ByVal dep As Department) As Integer
Return dep.ID End Function

View 1 Replies


ADVERTISEMENT

Office Automation :: Columns As Objects Part - Removing Duplicates

Nov 28, 2009

I am Tring to Make this work but I do not understand the Colunms as objects Part. Here is what I got

[Code]...

View 3 Replies

Listing Department And SubDepartment?

Jun 5, 2010

I am trying to read infofmation from the database where i list each department and thier subdepartments in the database so i have all departments and subdepartments in one database Called Departments there is also a field called SubDeptID the SubDeptID will have the value 0 if the department is a parent or a top level other wise it will have it's parent DeptID now i used 2 function to try to create this - it seems that the function add only the parents to the listbox but not the childrens?

here are my functions

Code:

Public Shared Sub FillDepartment(ByVal DropName As Telerik.WinControls.UI.RadListBox)
Dim displaymember As String = "DptName"
Dim valuemember As String = "Deptid"

[code]....

View 19 Replies

Make A Mini Browser For IT Department?

May 11, 2009

I want to make a mini browser for my IT department. I want to have buttons that will load internal websites and log in. I understand how to load th epage but have no clue how to pass the log-in information.

View 3 Replies

Get List Of All Users That Belong To Specific Department From Active Directory?

Mar 18, 2010

I want to get a list of all users and groups that belong to a specific department (entered by the user) from Active Directory using VB.Net and DirectoryServices.

View 2 Replies

Active Directory - Change "Department" Property Of AD Users ?

Aug 3, 2010

I urgently need a working routine which cycles thru all users in an AD domain to find those with the "Department" property set to "XXX" and change it to "YYY".

View 12 Replies

DataGridView, Set Up Columns, Populate Data Table, Bind, But Not Using Columns Created In Code?

Oct 26, 2011

I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:

[Code]...

View 6 Replies

Add/subtract/divide/multiply Certain Columns And Place The Information Into Other Columns?

Nov 30, 2010

My goal is to connect to my database either manually or using an sqladapater, and get information from two of my databases on sql server 2005. Then I want to take this information and on run-time begin to add/subtract/divide/multiply certain columns and place the information into other columns. I can do this in queries, however, I want to do it on run-time what is the best way to achieve this.I had some of this working, but I just want to start fresh and see how you would go about doing this.

[Code]...

View 2 Replies

Make Objects From The ToolBox Using Code Instead Of Changing Existing Objects Invisible Then Visible Later?

Dec 5, 2011

make objects from the ToolBox using code instead of changing existing objects invisible then visible later?

View 7 Replies

Sql - Error The SqlParameterCollection Only Accepts Non-null SqlParameter Type Objects, Not Int32 Objects?

Jun 23, 2012

I am getting this error, Not sure why it is happening "Error The SqlParameterCollection only accepts non-null SqlParameter type objects, not Int32 objects."I have tried with all sorts of possibilties, now try to enter default data as dummy data,

Using connection As New SqlConnection
connection.ConnectionString = ConfigurationManager.ConnectionStrings("DentalDeviceConnectionString").ConnectionString
connection.Open()[code].....

View 1 Replies

Modifying Objects Inside For Each Loop Sets Properties Of All Objects With Values Of Last One?

Jan 29, 2011

I have a program like this.

Module Module1

Public Class Mstr
Public Property Prop1 As String
Public Property Prop2 As String[code]....

But it is not working as I expect it to. You can see it from.The DtlsB properties of all three DtlsA objects are having values from last iteration.

View 1 Replies

Random Objects - Let The User Input Objects To A Richtextbox 1 Object On Each Line?

Jan 6, 2011

I want to let the user input objects to a richtextbox 1 object on each line, and somehow use Random.Next to select pseudorandomly a few objects, the number 'few' inputted in a textbox.

View 9 Replies

The SqlParameterCollection Only Accepts Non-null SqlParameter Type Objects Not String Objects?

Jan 18, 2012

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Using conn As New SqlConnection("Database=Clinic_Management_System;Data Source=.SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|Clinic Management System.mdf")
Dim cmdRecord As SqlCommand

[code]....

View 2 Replies

VS 2008 Inherit ListView - Dispose Of Two Objects When The Form's Disposing Of It's Objects

Feb 7, 2010

I have a user control that inherits the FW ListView and I need to dispose of two objects when the form's disposing of it's objects. Here's what I've concluded already, am I on the right track?

[Code]...

View 3 Replies

.net - Aggregate The Columns To Group On The Period And Sum The Count Columns?

Jun 29, 2011

I have the below Linq query that is returning the data but I need to aggregate the columns to group on the Period and Sum the Count columns. How do I go about doing this?

LINQ
from t In tblTimes
join h In tblEngineeringDashboard_CADMachinesCounts on t.ID Equals h.TimeID
Order By t.Period

[code].....

View 1 Replies

Adding Columns And Modifying Columns In Access Database Using NET/SQL?

Oct 15, 2009

I am using the following code to alter an table imported from an Excel spreadsheet

Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1

[code]....

Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?

View 1 Replies

Organize Columns - One Table Which Have Tree Columns (ID, Number, Name)

May 23, 2011

Imagine the following scene: I have one table which have tree columns (ID, Number, Name).

A Select query result on this:

code:

Now, the user deletes the Number 3 and 4. So, now the Select query is going to be:

code:

And I want to have:

code:

How can I organize the column?

View 14 Replies

Child Objects Raising Events In Parent Objects?

May 1, 2009

long story short, I have created a ListView type control, using UserControls for the parent control and the ListViewItems. Most the of the control is written and works fine, right up to the point where I tried to replicate the 'Control.SelectedItems(0).Index' property and the 'SelectedIndexChanged' event.

Each child object knows its index value, and could pass this value via the SelectedIndexChanged event (assuming this is how it works in a normal ListView control -- user clicks on an item, and that item fires an event updating the selected index value in the parent object).

How does the child object raise an event in the parent object? I have a feeling this could be done with Delegates, but I'm still learning about their usage.

View 1 Replies

Parse A Text Looking For The String - [[Extract|xxxxxxx]] And Extract The Xxxxxxx Characters?

May 28, 2010

I need to parse a text looking for the string - [[Extract|xxxxxxx]] and extract the xxxxxxx characters.How would I do this?

View 2 Replies

Asp.net - Averaging Columns In A Table - Ignoring Certain Columns

Feb 21, 2011

I've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.

Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1

[Code]....

View 2 Replies

Averaging Columns In A Table - Ignoring Certain Columns?

Feb 28, 2010

Averaging columns in a table - ignoring certain columns

View 2 Replies

How To Use Something That Functions Like Label Box But Can Handle Several Columns And Columns?

Feb 18, 2010

What should I use and how to use something that functions like a label box but can handle several columns and columns? Something that looks like this. [code] Name | Age | Birthday are headers and the letters are variables

View 5 Replies

ASP.NET Cast ArrayList Of Objects To Custom Objects?

Aug 9, 2011

getting the following error Unable to cast object of type 'System.Object[]' to type 'OrderService.webdirect_WebLinesRow[]'. On the line

webdirect(web_companyID, web_locationCode, web_customerNumber, web_orderNumber, web_orderReference, web_orderDate, webLinesArray.ToArray(), o_Company, o_LocationCode, o_CustomerNumber, o_OrderNumber, o_OrderStatus, o_OrdDescrip, webRespArray)

I created the webLinesArray.ToArray() array as such

Dim webLinesArray As New ArrayList()

Am I missing an additional cast or something ?

View 1 Replies

Compare Two Objects To Check If All The Properites Of Both The Objects Have Same Value Or Not?

Aug 28, 2008

I want to compare two objects to check if all the properites of both the object have same value or not. for this i need to use the reflection to enumarate through all the properties of an object and check the value of the property. To try the code just i have written a Employee Class having Two Properties EmployeeNo and EmployeeName. I am creating an object of the Employee class and need to write a function that can list the values of all the properties in the class.

[Code]...

View 2 Replies

Bind Objects With Nested Objects?

Jul 21, 2009

I am tring to bind a class to a form where the class contains other class variables. For example:

Class Character
Private _name as String
Property Name as String

[code]......

View 5 Replies

Original DataTable Object Has Columns Added When Variable Has Columns Added?

Oct 6, 2011

I have a datatable property called prpParametersTable in a class called clsBatch. I have a procedure that sets a datatable variable called dtP equal to prpParametersTable at the beginning of the procedure. I then add three new columns to dtP.Here is my problem. When I add the three new columns to dtP my original table prpParametersTable also gets those columns added to it, why? I only want to add the three columns to dtP and not prpParametersTable. How can I do that?

Private Function prvfnc_InsertBatchParameters(ByRef cnn As SqlConnection, ByRef trans As SqlTransaction) As String
' set new columns that have BatchID, Insert DateTime, and UserID for the SQLBulkCopy method below
Dim clm As DataColumn
Dim dtP As DataTable = clsBatch.prpParametersTable

[code]....

View 1 Replies

Array Of Child Objects In Nested Classes And Accessing Child Objects In .Net

Jan 3, 2012

I have a nested class, let's call it class1 and it has class2 inside it; VB.Net eg:[code]

1) How can I define X number of Class2 objects[let's call it: Node(x) array]** with NEW() subroutine called?' this raises error: dim cls2(n) as new class2 end sub.

2) How can I return actual number of Node() array? [code]Outside my class in main project I define cls1 object:[code]Now an array of class2 is created inside cls1.

3) Now,How can I access All of them[node(x) array which is created inside cls1] with all properties and methods available?

I remember I wrote a ProcessManager class with this functionality in .net 2003, nearly 4 years age, I don't have the code now.

View 1 Replies

Multithreading - Create Custom Objects/list Of Custom Objects In .NET?

Jan 24, 2010

I need two seperate lists, which every item is Integer, String, Bitmap - and one which every item is Integer, String String. However I don't know how to do this, or even where to look - I've googled for custom objects and custom object lists. What I'm trying to do is this.Custom Object1 is Integer, String, Bitmap Custom Object2 is Integer, String, String

In one thread I'll be adding items to List1(Of Object1), and processing them, and adding the results to List2(Of Object2), however I need to be able from other threads to look at the list and say only give me the items where Integer = (my thread ID), is this possible? Any help, or even links to information that would be relevant to this request would be helpful?

View 2 Replies

Can Objects In Objects Be Persistent

Dec 15, 2009

[Code] I want that once I put something in the BigCollection it stays there, I don't want it to be changeable from outside. I want to be able to clear the SmallCollection but it should not be cleared in the BigCollection. Any Ideas?

View 1 Replies

Casting Objects To Other Objects?

Feb 6, 2012

Firstly I need somebody to explain a bit of code to me, I'm a massive newbie at programming so I need an in depth explanation.

Private Sub Box_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs)
Dim C As PictureBox = CType(sender, PictureBox)

[code].....

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved