SQL Command Using An Arraylist In The IN()
Jun 4, 2010
I have an arraylist of integers and I would like to use it in the IN clause of an sql statement:
Dim arrLInt as New ArrayList
arrLInt.add(1)
arrLInt.add(2)
arrLInt.add(3)
[Code]....
This does not work, and I was wondering if anyone knew how to use an arrayList inside the IN clause of an sql statement.
View 5 Replies
ADVERTISEMENT
Jul 5, 2010
I found that if using ArrayList, all clone/CopyTo/Add command are shadow copy, not separate copy. How can I do such that after an ArrayList A is "copied" to ArrayList B, change in ArrayList A will not reflect to ArrayList B?
View 1 Replies
Dec 1, 2011
What I am doing is iterating through all the groups that belong to the top group (Generic reports). Then I take advantage of the GroupPrincipal.GetMembers(True) which will recurse through a given group name. I test to see if the user exits under that group and if true I put the group name in an arraylist.
I use the for each principal in GroupPrincipal.GetMembers to loop through each returned user to see if they exist.
Is there a way to put all the returned users Principal.Name from a given group in GroupPrincipal.GetMembers into an ArrayList? This would allow me to to use Arraylist1.IndexOf to search for user. Which would be much faster then iterating through a returned list using the for each construct.
Sub RetAllMbrs(strUser As String)
Dim oPC As PrincipalContext = GetPrincipalContext() '<- this is function somewhere else in the code
[Code].....
View 1 Replies
Jan 11, 2012
I have a problem in Treading.I have a code like this;[code].....
I want to change ListBox1 with ArrayList. But I couldn't find how to use adding a string to ArrayList in tread.
View 5 Replies
May 6, 2010
I have an arraylist (arrFirstArry) which I use to populate another arraylist (arrNoDuplicates) preventing any duplicates from being added. This works fine. What I would also like my code to do is prevent adding any partial values which may exist from being added. i.e. my array is like this
[Code]...
View 2 Replies
Sep 22, 2011
I have two structures Public Structure myResearchData
Public batchName As String
Public arraylistRData As ArrayList
End Structure
Public Structure myResearchSubData
Public researchDescription As String
[Code]...
Cleared MyResearchData.arraylistRData for new data to be put in but it also clears the arraylist inside MyResearchDataAList and didn't old the contents of the arraylist
View 1 Replies
Sep 21, 2010
What I need to do is read an ArrayList in My.Settings and add another ArrayList to it. The first think I'm trying to do is load My.Settings.Records into myArrayList. I'm not quite sure on the proper way to do this. I've tried things such as Dim myArrayList As ArrayList = My.Settings.Records, I'm not sure if I need New and I'm not sure if I need .Clone or .CopyTo.
Then I have another ArrayList myArrayList2. To get this into myArrayList I've done: [Code] Then to save it back to My.Settings I've done. My.Settings.Records = myArrayList. The problem is I keep on getting Object reference not set to an instance of an object error on the AddRange line. My.Settings.Records is definitely an ArrayList and it will sometimes = Nothing. The objects will only ever be strings.
View 19 Replies
Mar 20, 2012
I want to create an array of an array (or arraylist of an arraylist) to hold strings.I want to fill an array1 with string values Then add this array to array2. - but only taking up 1 row in array2 e.g something like array2(index)=array1 Then clear array1 then loop through this again with different data, and add it to the array2.so will end up with something like
array2(0)... contains a collection of array1 data
array2(1)... contains a collection of different array1 data
.. and so on
i think i need to make new instances of array1 each loop, but not sure.I dont mind if it uses arrays, or arraylists, or lists, or structure of arrayslists?
View 6 Replies
Apr 30, 2010
First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
View 6 Replies
Apr 12, 2012
s there a difference between the arraylist in visual basic and arraylist in C#? I had to convert some C# code to VB and there is a call I make in a third party api that requires me to pass in an arraylist. When I do this in C# it works just fine, but when I do this in VB, I just get back a vaque exception from the api.
[Code]...
The exception I get is very vague and comes from the API. All i get is, "ARException Occured".
View 14 Replies
Mar 17, 2010
I am currently using psexec.exe from PsTools to send a command to a remote system to fire a command through a command prompt however I am finding that the shell I am doing does not seem to like the spaces in the path.
[Code]...
View 3 Replies
Nov 8, 2007
Any ideas on how I handle the following error thrown in the SqlDataAdapter.Fill as a result of the BeginTrans in the callee?
System.InvalidOperationException = {"ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.The Transaction property of the command has not been initialized."}
[code].....
View 7 Replies
Jun 30, 2010
Public Sub ExecuteTransaction(ByVal connectionString As String) Using connection As New OleDbConnection(connectionString)
Dim command
As New OleDbCommand()
Dim transaction
As OleDbTransaction
[Code]...
View 1 Replies
Feb 24, 2010
I am using the following code to run defrag and to analyze if the C: drive requires defragmentation:
Dim analyze As Process = System.Diagnostics.Process.Start("C:WindowsSystem32defrag.exe", "C: /a /h /u /v")
This process runs through analyzing, runs it in normal mode & prints the progress to the command window.
My problem is that as soon as the process is complete the command window closes. I need it to stay open so that I can read the results.
View 3 Replies
Mar 11, 2010
I am trying to send a command to the external command line (cmd.exe) from the Windows form application that I'm writing in VB.NET (using VS2008).
I can only access the external program thru the command line (its not my program) and I must do so from a form app.
I am trying to use the following code. I am able to call a cmd.exe window, but I can't pass the command line my command.
Using mp As New Process
With mp.StartInfo
.FileName = "cmd.exe"
[Code].....
View 8 Replies
Jan 16, 2010
I want to add a new select command to my dataset. To do that, I have added a new partial class to my project. Because we have to use partial class if we want to extend generated dataset codes. [code]...
View 3 Replies
Feb 4, 2011
I am using a CheckedListBox that is populated with Filenames (full path, i.e. C:TestTest.jpg)When I have the files that I want in the CheckedListBox I wish to click a Start Button which will process the list one at a time using an exe program that runs on the Command Line. There are arguments that need to pass to the command line as well as the file location in order for the program to process.I currently have it working but the issue is the loop finishes quickly and it is left up to the CMD.exe to finish the process. What I would like is for the LOOP to wait until each file completes processing before passing the command for the next file in the CheckedListBox.There some reasons I wish for it to work this way.
1) I would like to have a button that can Pause/Restart the Loop.
2) I would like to have a button that can Stop the Loop so the whole process can end.
3) I would like to have the Loop remove each file one by one from the CheckedListBox after it has been processed.
4) I would like to display a Message once all the files have been processed.
5) And if it were possible I would like to report the status either by text or a progress bar showing where it is at in the process.
6) And the ability to add some error handling if possible.
Since the Loop finishes so quickly as it just passes the command to the command line using the & as a seperator it is the command line that is handling the rest of the process. Because of this there is not control over it in the GUI.The code I am using allows the Command Line text to display in the Form so it won't open up a seperate window to run CMD.exe. This is the desired affect as I would like everything to appear to run from within the Form itself.
[Code]...
View 6 Replies
Aug 21, 2011
User need to select their prefferable data to show in report. What i did is i have a clear command first to delete the temporary table. The temporary table is basically a table to stored user selection parameter data. After the clear command, i have
a insert command to insert user selection data into the temporary table. What happened now is when i run the program exe, first run of the report is work fined, but not the second and the following times of execution. It will return null or blank report. The weird thing is when i execute it from development environment, it seem like the report is able to pick up user selection parameter and run the report for the first times and the subsequent execution.
View 3 Replies
May 18, 2009
i have seen this in many codes, just not sure where to start and how to call the command. what i'm talking about is having code as such (this is for save file dialog):
[Code]...
View 3 Replies
Apr 24, 2011
In the Windows Shell, there is a command that looks like this: copy /b fileA.zip + fileB.jpg fileC.jpg..Is there any equivalent function in VB.NET? I already know this works: [code] But I would much rather have a built-in function to work with. Here is what I am trying to do: url...Also, this doesn't just work for pictures. It works for any binary file. Is there any way in VB.NET to tell if a file is binary or text?
View 3 Replies
Feb 6, 2011
Is there a way to hide the characters of a "set /p password=Enter Password:" command? Or any new strand not using the SET command i could use instead?
View 2 Replies
May 29, 2012
I am struggling to pass a parameter to a VB.NET application via a Windows scheduled task. It works perfectly in Visual Studio (passing a command line arguement via project properties).If I am calling a VB6 application, then I will supply the following parameters and it works:
Run: c:progra~1TestTest.exe TestParameter Start In: c:progra~1Test However, if I supply the same parameters in VB.NET, the program throws an exception when it tries to create an instance of a class in the Form.Load: System.NullReferenceException cannot create instance of object.
I have also tried the following:Run: c:program filesTestTest.exe TestParameter Start In: "c:program filesTest" This time the status of the scheduled task changes to "cannot start".What is the correct way to specify command line parameters in a scheduled task for a VB.NET program?UPDATE I found the solution on this web page:[URL}.. I am still confused as to why the program would not create an instance of an object when I used the 8 bit paths (i.e. progra~1)
View 1 Replies
Apr 23, 2011
I'm running into the following error message when I click the button event: Command text was not set for the command object. [code]
View 1 Replies
Dec 21, 2009
If I comment out MdiUpdate() this run fine. When I run it with MdiUpdate I get the following Error...
da.Fill(ds,
"Mdi") Command text was not set for the command object.
I have also taken the code from the select statement and put it into the other 2 (replace the CliendGroupID = 3) and it works fine
Here is the code:
Public
Class NewFileInput
Dim inc As Integer
[code]....
View 2 Replies
Jun 6, 2012
I have beginner skills using VB (am using the Express edition to learn). I would like to know how to set up a conditional statement in a Windows Form (WF) app that would check if a specific command line has been passed by another separate app that launchesthe Windows Form app using command lines, and if not passed, then the Windows Form app would shut down (exit, close).So far, I can use:
For Each s As String In My.Application.CommandLineArgs
If s <> "xyz" Then
Me.Close()
[code]....
View 14 Replies
Mar 5, 2012
I am trying to make a little program for fun and I don't know OOP that well. Since this part of the program is going to be large in comparison to everything else, I want to make sure I don't half ass it.
I need,
50 states
each state having multiple schools
each school having multiple players
and each school having 1-4 coaches who may or may not have awards
I only posted a couple classes since I should be able to figure the rest out off of these two. The award class properties will be changed later. How do I make a new coach that has x awards? I am confused with this part. If I did not explain something clearly please let me know, I want to make sure I get this program started off the right way.
Public Class Coach
Public Sub Main()
Dim coach As ArrayList = New ArrayList
' coach.Add(New Coach(1, "Billy", "Bob", 0, 50, ???))
End Sub
[CODE]...
View 4 Replies
Feb 10, 2012
In the Windows Shell, there is a command that looks like this:copy /b fileA.zip + fileB.jpg fileC.jpgIs there any equivalent function in VB.NET? I already know this works:Shell("cmd copy /b fileA.zip + fileB.jpg fileC.jpg")
View 5 Replies
Oct 2, 2011
I'm starting to make a program that will run some commands, so i need some code that will open command prompt and run the command "netstat -a".
View 11 Replies
Oct 11, 2011
I'm having some trouble adding an object to an arraylist.
Basically the object has two properties (file id/name), but I can't figure out how to assign those properties. During runtime it errors out with public member on the object not found.
Private QueueList As New ArrayList
Public Sub Queue(ByVal FileName As String, ByVal FileID As Integer)
Dim QueueObj As New Object
[Code]....
I'd also like to know how I can do a loop on the arraylist and access the two properites on each record.
View 3 Replies
Nov 19, 2011
I am trying to create an arrayList of people. The variables, or arrays are; first name, last name, age, DOB. I am wanting to load all that into one arrayList and dataBind it so it would look like [code] Loading it into an ASP DataList. SO Fname + Lname + age + DOB are loaded on the same line/index. Not sure how to go about this. I'm sure it's an index issue..but not sure the thought process to even begin to load these elements into the "0" element, then the "1" and so on. Not puling the information from a database, just preset arrays/arrayList. ANY suggestions? ( I have it so it is dataBound to one arrayList entry as in [code] This works fine. But if I wanted to add the last name to the first name on the same line...that's were I am not seeing the connection.
View 5 Replies