I 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 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.
I 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 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 RepliesThe code I have is:
vb.net
Dim zipFiles(0) As String
Dim x = 0
[code].....
I have a button ad a list box, the button when clicked lets the user select a directory on the HDD, and then the app is meant to list all the sub directory's of that folder int he list box. However I cant seem to get it to list just the sub directory names, not the full paths, and also to only scan by 1 folder deep (selected foldersub folder).
View 1 RepliesI'm having some trouble with list boxes at the moment. I need a list box to display the names of directories that are in certain a folder. How can I do this?
View 3 RepliesI have a small problem i'm trying to fetch list of directoies from 1 special ftp server wich does not support LIST command i was try this code and it works for all ftp server i have try exept this special one :
'' Get the object used to communicate with the server.
'Dim request As FtpWebRequest = DirectCast(WebRequest.Create("ftp://" & txtFTPhost.Text), FtpWebRequest)
[code]...
I'm getting error 502 which means command is not supported and app crashed. I would just simple said leave it but i have try normal ftp clients like FlashFXp and it works just fine (i can see error in the log but it just pass it and show direcoties)
I 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]...
I'm using this code to retrieve the list of files from a FTP server
Dim request As FtpWebRequest = WebRequest.Create("[URL]")
request.Credentials = New NetworkCredential(username, password)
request.Method = WebRequestMethods.Ftp.ListDirectoryDetails
Dim response As FtpWebResponse = request.GetResponse()
Dim responseStream As Stream = response.GetResponseStream()
Dim reader As StreamReader = New StreamReader(responseStream)
messagebox.show (reader.ReadLine)
It gives me alot of information that I dont need, I know that I can use:
request.Method = WebRequestMethods.Ftp.ListDirectory
Which only retrieves the file name but when I try to change it, it gives me an error. Error number 550. ListDirectory so I can only get the file name?
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.
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]...
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.
Can anyone help me with finding all the table names in SQL Server Compact Edition (.sdf file)?
View 3 RepliesI 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 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
I have a vb.net form to add, modify or delete the product list..i have a datagridview in which i m loading data from sql server datatable...now i have a text box which accepts code for the product..i want that when i press a key, all data starting with that key should be highlighted in datagridview.....
eg
i have product codes
A001
A002
A003
C001
D001,, etc..
Now i press A in text box...in datagridview all data with A should be highlighted
What I am trying to do is allow the user to enter a list of authors in a textbox separated by semi colons. After each author is entered, followed by a semicolon, I would like the autocomplete to work on the next name and so on (e.g., Smith, John; Eastwood, Clint...). I can get the autocomplete to work in a textbox with one name, but cannot seem to figure out how to get it to work on a list of names in a text box.
View 8 Replies