I'm trying to have a ListBox show a list of tables available in a database. This can then be selected to be used later on.My problem is getting the actual table name to show up. I have the connection to the mysql database working properly, but it just shows "System.Data.DataRowView"
[code]...
I have a DataGridView which populates from an SQL query just fine in default mode
using these table names
[firstName] [varchar](20) NOT NULL,
[lastName] [varchar](20) NOT NULL,
[code]....
I have edited the column headers and set the column names to the same values as my table names yet the data is not showing in form load I have set datagridview.AutoGenerateColumns = False I know the data is there if I delete datagridview.AutoGenerateColumns = False then the data is shown with the default headings?
Imports Word = Microsoft.Office.Interop.Word
Public Class Form1
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Dim a As String = My.Resources.picture
[code]....
I wont this in table.cell (3), from listbox2
[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
View 6 RepliesI can;t seem to find anything that shows me hoe to get table names from an access DB using VB.NET. There is a main DB as well as tables linked from outside DBs.
View 1 RepliesI have a new app im making... its for a mod im making for rFactor now for ease for the testers getting updated mod files im making a download manager (i have done that bit already and it works) but what im trying to do is put a list box on the form so they can click the file/zip they need to download and click download.. now i know how to get a list of file/folders from a dir on my pc...
Dim dir As String
Me.ListBox1.Items.Clear()
Dim dirs() As String = Directory.GetDirectories("C:\")
[CODE]...
But is there a way i can do this for my webserver? i have lloked on google and cant seam to find anything.... i was going to make a auto updater and i see some source code on code project but as im still pretty new to coding i dont think im ready for it.
Im not grasping something here.I can populate folders in listbox's but dead in the water populating files in listbox's.
Option Explicit On
Imports System.IO
Imports System.IO.FileInfo
Private Sub ListBox5_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListBox5.SelectedIndexChanged
[Code]...
i'm having a bit of trouble. can't seem to add ONLY the file names, without path or extensions to a list box no problem there with a a textbox. also the code i have to get the file to open in a textbox is a bunch of runaround (get's the job done though) but includes a few labels, text boxes, etc. i need a simpler code if possible.
View 6 RepliesI wanna put the files that ends with ".dll" which in the EXfile pat in a listbox in my program so know It's kinda easy question but I'm a begginer, I was using vb6 & there were a FileListBox Tool it was
View 1 Repliesi would like to filter my database for name and surname this is my code and i can't seem to get it right the listbox is showing system datarowview.
Private
Sub search_person_Load(ByVal
sender As System.Object,
ByVal e
[code]....
How do I show a directory into my form, or -optional- filter it on file types?
View 3 RepliesI have the code which gets HTML code and puts it in a richtextbox with seperate lines.I would like the richtextbox to delete each line which doesnt contain a url in it.
View 3 Repliesi recently posted a code that i had that i needed assistance for and it was solved it was for displaying all tables in a database.but now i have this code for showing all column names in a table i was in the process of turning it from oledb to sqlclient. GetOLedbSchema can be turned to getschema but when it comes to OleDbSchemaGuid
Public Shared Function getAllColumnNames(ByVal tblname As String) As String()
Dim com As New SqlCommand
Dim con As SqlConnection
[Code].....
i have this code for showing all column names in a table i was in the process of turning it from oledb to sqlclient. GetOLedbSchema can be turned to getschema but when it comes to OleDbSchemaGuid
Public Shared Function getAllColumnNames(ByVal tblname As String) As String()
Dim com As New SqlCommand
Dim con As SqlConnection
[Code]......
I have a few questions that are bugging me.
1. How can i get file names from a directory and put them in a ListBox? Not the full path to them?
2. Can someone explain how to make a program default to .lua openings?
3. How could i put an icon in the Notification area?
4. When a dialog is open, like options, how can i disable clicking of the main form?
basically, i'm creating a program that is saving text files based on user input.
another screen is then needing to transfer the saved information into textboxes.
to do this i want the saved .txt files' titles to shows in a listbox, and when each selection is made, the textboxes are populated with the information in the .txt files.
This next program I am working on consists of 3 listbox's. The idea is to have the end user load names in the first and second list box. Then have a button's action when pressed combines the list in listbox1 with listbox2 then gives the output combination in listbox 3.
I also wanted to include some checkbox options such as adding a "_" or "." for every item.
Here is a thinking map of how I want it to work.
Listbox 1
TOM
Listbox2
[Code].....
I'm trying to do something like this: when i press a button a dialog opens and then i choose files, the files names should go into the listbox
Private Sub pxBrowse_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles pxBrowse.Click
Dim dr As
[code].....
I THINK I have seen a simpler way of doing this, however I can't remember how to do it... How can I get all the color names into a ListBox? This is the code I found on the web:
vb.net
Prvate Function GetColors() As List(Of String)
create a generic list of strings
[code]....
In a project I am doing, I was hoping to show a listbox at the bottom of a label when I click the label so a number can be selected. I don't want to use a combobox or numericupdown because of the look. The problem I have, and I hope can be resolved is that when the listbox is shown, it is drawn under the other controls. Is it possible to show it over the others?
View 3 RepliesI'm trying to get the list of field names for a given table, to turn them into a string which I can to post back as a variable to another function.I've Googled loads of stuff regarding GetSchemaTable but all I seem to be able to output are field parameters, but not the actual value of these parameters (ie ColumnName, which is the one I actually want!)
Found this page; What is the SQL command to return the field names of a table?But all the queries on there give me an error "You do not have access to Table 'Columns'"I feel sure this is pretty simple, can someone give me a little function that will simply give me fieldNames = "fieldName1, fieldName2, etc"I am using a MySQL server and ODBC connections ASP.NET using VB.
I have a vb express 2010 program where users submit issues to different persons. The issue is emailed to teh selected persons and also saved in SQL on a server. Question is if they select multiple names from the list box to send the messsage to, how do I insert the multiple names into the SQL table? Here is the insert command I use. It will insert one name but will only do one if multiple names are selected. What am I missing?
[Code]...
I made a Listbox but there is an issue.. I want to play a sound when I click one of the names in the listbox.
View 6 RepliesOkay, so the title was horrible. I know that. Here's what I'm trying to do:I have a lot of data that's coming from a database and being adding to a listbox. The data that's coming from the database is a unique ID, and a name. Is there any way I can make the item contain both the ID and name? I know I can append it, that's not what I'm looking to do. I need a way to be able to either get the ID, or get the name, while displaying them both.I have gotten as far as creating a class:
Class Item
Property ID as Integer
Property Name as String
[code]......
I have problem with Sorting ListBox in Visual Basic 2008. When I load names from some files (file's name is number_name like="156_blabla") and I need sort it by that number
It is:
1018_name1
102_name2
1026_name3
And I need it:
102_name2
1018_name1
1026_name3
I want to fill a listbox with file names of the specific extention. This is my code , does not work.
lstClips_ListBox.Items.Clear()
If Not FolderExists = My.Computer.FileSystem.DirectoryExists(PowerPointDir) Then
MsgBox("This Directory does not contain any PowerPoint files" & vbCr & "You need to load the files now...", MsgBoxStyle.Information, "Warning - No Media Found")
[code]....
If i take away the DIR name and the Exten then it fills with ALL the file names, not what i want.
Private Sub cambiarnombres_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cambiarnombres.Tick
[Code]...
Now when a name appear in the names.Text disappear in the listname(listbox) except the last one.But I want to keep all names in the Listames because I want start the process again with a timer. Now I have to close and open the App when I need start the process again but I want to keep all items in the ListBox and Start the process again from the first Items.
Using Visual Basic 2010 Express on Windows 7 whilst learning to program a database application using windows forms. I created a database (.mdf I think) with a tables e.g. patient details. Then created a form and dragged dataset and database adapter follwed by dragging database fields - this all worked perfectly well. I then created a table "tblSuburbs" with key suburbID, suburb, postcode fields. This also went well when creating a form to add, modify or delete suburbs. I modified my Patient table to include a link to the Suburb table - creating a relationship and saving both tables. Here comes my problem - Whilst the Database Explorer shows the "_SuburbID" field I added to my patient table, it does not show up in the DataSet even after I try and "refresh" every "refresh" button I can find. I need the DataSet to show the link field as I need the User to select which Suburb they in.
View 4 RepliesI have a database and I was thinking about using either a List Box or Data Grid to show the data. Is there is another way of showing the data? Also, when the user 'double-clicks' on the data in the List Box or Data Grid then I would like the information to come up in a new form. I know how to show a new form but I don't know how to get the information from the one that has been clicked.
View 12 RepliesI am using OledDb to create/retrieve/delete data from Access databases. At one point in the solution, I the user adds data to a new table and the table name is defined by the user. The obvious problem with this is that the user could add spaces, characters, and Access/SQL keywords that are not allowed in the table name. Later in the solution, the user should be able to identify their saved table and retrieve it. I have considered the brute force method of formatting the input to remove offending characters and then reformat for the user's view, but that seems like something I would like to avoid. I have also considered placing restrictions on the textbox with masks, key event restrictions, and checks for conflicts with keywords, but I would also like to avoid that. So, my question is, does anyone have a creative solution for identifying a table name with something like 'my name is table number *1'?
View 1 Replies