I need to create a VBA script that can be used to input a list of workstation names and display the memberOf, Home Server and OU for that workstation?
View 9 RepliesI'm trying to create a form that accepts names (or any strings) as input and stores them in a object. See attached form sample.Form Image:
Operations: ï Initially the NumericUpDown object on the form should be disabled.The user enters a value (string) in the textbox and clicks the Add button or presses the Enter key to activate that button.The application then stores that name in a List object, and displays the last entry in the Label underneath.The NumericUpDown should become enable after the first entry. The user should be able to move between all the values entered using NumericUpDown.
I am trying to input a very long list of dog breed names into a DB via phpmyadmin, this will take me for ever manualy and I was thinking if I could work out how to write something quick and nasty to create the sql string for each dog breed it would save me so much time. The sql query for each added forum is in the following format:
[Code]...
I am trying to come up with a good way to enumerate hard disks on remote workstations, possibly including administrative shares, so I can audit key files on them without having to access them via sneakernet.I have domain administrator rights. Security policy prohibits using WMI which would be a great solution.I can retrieve a list of computers using Active Directory, but I need some way to determine what drives are available on each system. Is such a thing feasible? A fellow developer offered some VB6 code from years ago that used WNetOpenEnum, but I was hoping that since we are at .NET framework 4, maybe there's a more elegant / managed way of working with this. I'm keen to use technologies that are more generally supported, such as standard APIs etc. WMI is a great solution but apparently is blocked by default by Windows Firewall, so its availability is not guaranteed.
View 2 RepliesI created a simple dll in VB2008 on my development workstation (uses a GUID and Implements an Interface,It is a basic "Hello World" & someInputValue. I reference this dll in a MS Access code module and works fine on dev machine. I run Debug.Print testDll.HelloWorld("xyz") and I get I then copy the mdb and dll, tlb files to the remote workstation (where I am also running all versions of the .Net framework) and try this on the remote workstation -- Everything compiles fine within the Access code module on the remote workstation, but I get an error message that the ActiveX control cannot be created when I try to run the procedure. I tried to register the dll regsvr32.exe "C:myDirmyTestDll.dll"and get the message that the dll is loaded but the DllRegisterServer entry point was not found. This file cannot be registered. I know that I have tested other custom dlls on this remote workstation before, and everything worked fine.
View 4 RepliesI am used to C like languages such as C#. I added a list box with a list of names. In the code behind I added the below code. When I run the code I am getting the MessageBox but it will state "UserName favorite color is " but does not show the color. I thought it might be misspelled or non-matching names but this is not the issue due to the names being correct.
Public Class Form1
Private Sub lstData_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstData.SelectedIndexChanged
'Declare Variables
[CODE]...
The local car rental company rents cars for 29.95 per day with unlimited mileage. There is a refueling fee of 12.95; regardless of what the level of fuel is when the car is returned. Write a program that will permit the user to input the customer's first and last names and the number of days that the car was rented. The program should compute the total charge for the car that was rented.
I have to do this:
A. using a standard window
B. Using a WPF window (And I don't even know what that means)
C. Using a console application
I am using the following to poulate a list box with the file names in a certain directory...lstImages.DataSource = IO.Directory.GetFiles("C:UsersLBDesktopSTRImagesPumps")This works, and does populate the list box, but it shows the full path on each line...
View 2 Replieshow to list names from a file, as you enter (spell) the name. eg if you enter 'b' all 'b' names will appear. If you next enter 'e' then all 'be' names will appear. repeating this until the last letters are entered. eg 'bell' will show all names starting with 'bell'. You can then select from the list the correct name?
View 2 RepliesSo in my Textbox I have a list of (folder) names, such as:
Folder1
Folder2
Folder3
I want to compare THAT list to another folder somewhere in someones documents (no specific folder). So let's say we compare it to the 'Arts' folder, which contain these folders inside:
Folder1
Folder2
I want to put all of those folder names in the Art folder into a list. And then I want to compare the folder names in my Textbox to the folder names in the Arts folder, and Folder3 is missing in the Art folder, so I want the textbox to contain:
Folder3
...to tell you that you are missing Folder 3 in your Art folder.
I am using VB.NET in VS 2008 Professional. I wish to have my user select the server where the SQL Database resides. I can get a list of the SQL databases, but I am stuck on how to display the servers currently available to the user? I want to add the list of servers available into a list box and have them select the server.
The thing I am trying to duplicate is the drop down list of server names when you are doing an Add Connection from the Data Connections node of the Server Explorer.
For my assignment i need to list all the objects and their names. Surely i can get a list because typing out 150 names seems a bit ?
View 7 RepliesI am trying to find out if an instance of an application (not vb.net) is already running - because I will want to start it but I don't want to start it if it is already running. I have found a solution to check if a process is running:
Dim proc As Integer = Process.GetProcessesByName(ProcessName).GetUpperBound(0) + 1
and return True if >=1 (or just the process number). My problem is, this is a third-party application, and its process name is not just a name but it contains a version number (which I may not know at run time), and it also seems to add a *32 (so probably a *64 if it is installed in x64 ?).
I need to get a list of running processes, by name, and test if "processname" is a substring of the name.
But I haven't been successful in getting a list of names, only process id's.
I have a table in a Access Database that I'm loading into a VB.NET program and I want a way to get the name of each of the columns into a list of Strings. Googling has shown that this is much easier with a SQL database, but that doing so in Access is much more difficult. I came across this question Is there a query that will return all of the column names in a Microsoft Access table? Which gives a way to do it, but when I try the code it just populates my list with a bunch of "System.Collections.Generic.List'1[System.String]"
This is my adapted code.
Public Function GetColumns(ByRef database As String, ByRef table_name As String, ByRef columns As List(Of String)) As Integer
Dim com As OleDbConnection
Try
com = New OleDbConnection(database)
com.Open()
[Code] .....
My for each loop isn't printing the right string. Should be Console.WriteLine(holding)
I want to populate my combobox with the list of banknames available in my database.. I tried doing so but I am getting a blank list. i.e.. shows no value in combobox!
Here is what I tried...
Private Sub ComboBox4_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox4.SelectedIndexChanged
Try
'MsgBox("Open")
cn = New OleDbConnection("Provider=microsoft.jet.oledb.4.0;Data Source=E:\Project-Hemtech\HemDatabase1.mdb;")
[Code] .....
I have the need in my program to get the list of user logon names in a group. This is what I have so far but it only returns all the users...which I need cut down to those in a group, of which i have the name of.
Option Explicit On
Imports System.DirectoryServices
Imports System.DirectoryServices.ActiveDirectory
[code]....
I have a list of File_Name, File_Date.
I need to check this list sometimes against a file name and sometimes against both a filename and a file date.
I've been doing a for each loop and checking each value, I've tried a hash table keyed on file_name which is much faster, however I also need to check to see if the file_name and File_Date combination exist.
Is it possible to have a list that I can do a quick search on using either the filename or both the filename and filedate.
What I am trying to do is search through a list of file names looking for files with the same File name the following code is run from a button on the form The code seem to work ok up to the Array the line marked with ### is the line that the code stops at run time.
[code]...
How can i add an array on names in a list box And be able to add and delet name in a listbox ps sence i just fond out .net cant mke control array ill use listbox with an array of names in it
View 2 RepliesI am trying to get the list of all the SQL Server names. Using the below code I got the name, but actually my server name is OWNER8SQLEXPRESS and I am getting only OWNER8. How I will get the full name.
vb.net
Private Sub frmGetServerName_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim dT As DataTable = Sql.SqlDataSourceEnumerator.Instance.GetDataSources()
DataGridView1.DataSource = dT
End Sub
I am trying to write names from a list box and it works apart from the first listbox item.So this doesn't work:
My.Computer.FileSystem.RenameFile("D:Renaming2.avi", TextBox4.Text & " " & "1" & " " & "-" & " " & ListBox1.Items(0))
But this does:
MessageBox.Show(ListBox1.Items(0))
So listbox1.items(0) does exist but I just get the error that there are illegal characters in the path.
To create a program that asks for input then uses an else statement to create a handling fee balance.
Input: sales record - first name, last name, purchase amount, balance before purchase
Output: report - full name, old balance, purchase amount, handling fee, new balance
Definitions: handling fee is 5% of the old balance if the old balance is less than $1000.00 else it is 2% new balance = old balance + purchase + handling fee
Processing:
Ask for and receive sales information
Calculate new balance
Print output report
End the program when a purchase amount of 9999.99 is entered
I have a winform that has one combobox. I want to populate that it with a list of folders in a directory. I thought this might be a common thing but I have not found any thing concerning this.For this example lets say the root folder is C:TestingFolder ListIn the folder "Folder List" directory there are 5 folders as such:
View 2 RepliesI have a WinForms applciation, I wrote a function that returns a list of all the controls on the form. The function returns a list of control objects.My target is to fill up a combo box with a list of the control names so that once clicked I set focus to it.So what is the correct code for converting a List(Of Control) to an array of string.
View 2 RepliesFill Combobox with List of Control names
View 5 RepliesI have a List box that I would like to populate with the Windows Font Names, how can I do this?
View 2 RepliesI have one application create tables in database dynamically during run. Another application need to find all these tables' name in the database. how should in do in vb.net
View 7 RepliesHow would i read a set of names out of a file and then append them to a list box?I am not guaranteed a pair will be on the same line, and not guaranteed that a line would contain a maximum of one pair(i.e., it might have three pairs or it might have one and a half pairs - a first name, last name, and another first name whose matching last name would be on the next line). A line may also be blank.All of this needs to be in a visual basic format.
View 1 Replieshow can i show all column names of a table in List view.Like table name is "WO"
Wo_no
T_Date
Emp_id
The code I have is:
vb.net
Dim zipFiles(0) As String
Dim x = 0
[code].....