I have 45 buttons on a form, Button1, Button2, Button3 to Button45. Each one has to have a Button?.Text value from a database eg. Button1.Text = "Beef", Button2.Text = "Cabbage", etc. In old VB6 I could use the Index value of each button to reference it, but in VB.Net there's no Index capability.
Is there a more elegant way to populate these buttons other than having a Select Case statement from 1 to 45 as below? [code]....
I have an Access Database that contains two tables. I would like to populate 10 text boxes on my form with the data from the tables. For example: Table1 has a list of names 1 thru 5 and I would like to have 5 text boxes on my form when the form is loaded to populate those names. I know how to populate a combo box with the information, but not sure how to do it into individual text box
Current Code:
'create connection and command string
Dim conStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
[code].....
The treeview system I am using is by Andy Bonner from the following Link, as advised I have created a new post.[url]...
Andy you were asking what it is I am trying to do so I will try explain it a little better. The treeview system you have created allows me to import / edit and save XML files based on the treeview structure that I create. What I now want to do is use the same XML files to populate buttons on a form.
So for example if I have 10 buttons on a form then on load it will look at the xml file and change the text of the buttons to whatever the main level of the treeview is.[code]...
I have a form that cycles through a database table with next and prev buttons Database name is "China.accb" and the table is called Users Table Users has two fields, both text.One is called UserID and the otheris Password"am getting an error message when I try to click the next button that states: "Unable to cast object of type "System.String' to type System.Windows.Forms.Textbox'. I've highlighted the line causing the error below
Imports System.Data.OleDb
Public Class frmUsers
Dim intMaxRows As Integer
[code].....
I need to pull from an access database to populate a combobox. Then from there I need to have a second combo box populated depending on the selection in the first box. My thought of an example would be a website that is setup for selecting car make, modle,year...can that be done in VB?
View 1 RepliesI have a piece of software with two tabs, inside each tab there are buttons (the user can add the buttons when they want). when tab1 is full tab2 should start to fill. I currently know how many buttons fit on the screen so I just say something like if buttons > 150 then start to populate tab 2 The problem i have now though is if the resolution is changed then a different amount of buttons can be displayed. so if I put my screen to 1280x720 some buttons are left of. I was thinking of detecting the resolution and then using different cases for different resolutions but this seems very inefficient im wondering if there is a different way?
View 5 RepliesI want to populate a combo box but not using a database
e.g. combobox displays
red
white
blue
But want I want is if a person chooses red I want to pass back the number 1 value to a backend database. I'm able to populate a combo box with the colours but not sure how i 'grab' the value to pass back
Dim colours as string[] = new string[] { "red", "white", "blue" }
m_cmbColours.Items.AddRange(colours)
What I want is this
value Colour
1 red
2 white
3 blue
Combobox just displays the colours and when chosen in the combo box I grab the value corresponding to colour chosen.
I've given up on my harder stuff and have simplified it to something else. There are no errors that pop up now but the list box doesn't populate! I took the code from a book and there's a data adapter, data connection, and data set on the form already (they're not named in this code though, since the book didn't say to). When the program opens, the list box has a line of text in it and the list box doesn't fill with the right items.
Private Sub EditStock_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
Dim dsitemlist As New DataSet
Dim itemlistadapter As New OleDbDataAdapter _
("SELECT ItemName FROM Stock", ConnectString)
[Code] .....
And here's what shows in the box.
system.data.dataviewmanagerlistitemtypedescriptor
I'm stuck, can someone teach me on how to populate my listview using database.
View 2 RepliesI need to create a search form where a combobox populates with names then the user clicks a name and the textboxes in the form are filled with the correct data for example txt_Firstname txt_last txt__nameage would all be filled with the right data from access.
I already have the combobox sorted meaning i can successfully see First names in the combo box so now all i need is helping with clicking a name in the combo box and the dataset being populated in the text boxes heres the code used to populate the combo box:
Private Sub Search_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dbprovider = "PROVIDER = microsoft.jet.OLEDB.4.0;"
[Code]....
I populate a datatable from a database. The table is sorted by the first column.
Then I add some new rows to the table. After that I sort the table with pgds.Tables(0).DefaultView.Sort = "firstcolumnname"
The new added rows are listed after the originally ordered rows and not in the right order.
I've been working on this for three days now and I can't seem to get my listbox to populate. I'm connecting to an sql database. Where am I going wrong? Dim cmd As New SqlCommand("SELECT DISTINCT natureport FROM rates ORDER BY natureport", conn)
[Code]...
I am trying to learn how to populate a tree from a database, I did this same thing back in Vb6 and am trying to learnhow to do it in VB.Net, but I am having trouble with the code. From looking on the web I have piced this together, but I think it may be far off. It just jumps out put leaving the tree blank; and it gives no error message. I put in a try error catch and it cannot convert the data to a double, but even if I take this out it does not work. It is stuck at the line with: dr("CustomerID") <> hID I was using this to check for a parent node, I can take it out, but it still does not work; I am afraid that I am be way off here. I am using the Nothwind database.
[Code].....
how to populate a treeview from a SQL datbase. I have been looking on the web but I have not found a lot and wwhat I did find show some things that, like child nodes that I cannot find. Basically I am pulling orders from the Northwind database and want to have a branch with an order and off this branch the with the ID of the order details. So when the they click on the order node it expands to show the orderdetail ID.
I get the a branch, weiht the code below, with the order IDs but cannot get the child branch.
my code
Public Class Form2
'Dim TreeView1 = New TreeView
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
Using VB.NET I want to display the date in datetimepicker from the database.
Code.
cmd= new sqlcommand("select date from table1", con)
dr = cmd.executereader
while dr.read()
[code]....
But it showing error as specified cast is not valid How to get a value?
populate values from a database(Access) in to vb.net form. after selecting a field from first form , the next form should display all the parameters used in the selected field from the data base. Also if do editing it shppuld be updated in the database.
Public Class Editdetails
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim cn As New System.Data.OleDb.OleDbConnection[code]....
I have 3 labels I want to populate with info from my database. I have a SELECT statement that works for only one piece of info but I need it to include the other 2 as well.
I have 3 labels: Current, YTD, and MTD My select statement is working for YTD but I don't know how to write the SELECT statement to include the others.
[Code]...
This is my GET Method to get my data from my DataTable
Private Function GetData() As PagedDataSource
' Declarations
Dim dt As New DataTable
[code].....
Im new to vb.net and would like to know the very basics on how a datagridview works? how does it populate data from the database? what process does vb follow to update this datagridview? I'm trying to get my head around the following terms and need some explaining how they work and how they are linked? if possible, is there a link to a diagram that explains this?
[Code]...
I have a database in ms access. I am trying to use a listview to populate this database. I have comboboxes and textboxes that populate the listview. I have tried to just make sure that my database will populate with the combo boxes before I try to code it to populate from the listview. I am running into an error while trying to populate this database. The error I am receiving is the following,
Syntax error in INSERT INTO statement.
The error is occurring in the da.update(ds, "TrapDatabase") line.
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim con As New OleDb.OleDbConnection
Dim dbprovider As String
Dim dbsource As String
[Code] .....
can someone please give me basic steps on how to hard code a combo box to display a column from a database?
View 21 RepliesWhen you use the feature "generate database from model" how do you put some data into a table?for example i want a tabel with all country after the database is created. Is there a script / shortcut to do this?
View 3 RepliesI am trying to populate one column in an Access table using two check boxes - one for 0, one for 10. How do I make it so that on click or after update, whichever check box is checked populates the cell with the associated number?
View 2 RepliesHow do I populate a combobox with elements from a database?
View 2 RepliesI have an application in which I have to populate a datagridview from one table from an access database. Here is the code that I use to open and close .mdb file.
Public
sql As
String
[Code]....
... But I don't want to use this way... I want a different way with a dataset or... I don't know.
I was given a task to actually to develop a application where it will automate the process of extracting data values from excel files and add in into access table. Is there any online examples or any advices on how to go about developing this?
View 1 RepliesI just wanna ask how can i add, delete record in datagrid that is bind in a textbox using ms-access.
how to populate listbox from ms-access database.
Is there a way in which I can populate my listbox with an Access (.mdb) database and search for values in it. Also, can I move selected values back & forth from that listbox to another listbox (or textbox). Is this possible using Visual Studio, VB.Net?
View 6 RepliesPopulating a listbox with data from a database
View 2 RepliesI have a local MySQL server which has a database. Now, I want to populate a listview with all entries (Rows) in that database. [code]...
View 4 Replies