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
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
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
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
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
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
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
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
Dec 5, 2011
make objects from the ToolBox using code instead of changing existing objects invisible then visible later?
View 7 Replies
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
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
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
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
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
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
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
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
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
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
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
Feb 28, 2010
Averaging columns in a table - ignoring certain columns
View 2 Replies
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
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
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
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
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
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
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
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
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