I am working on a project which requires me to display images from an external database.What is the easiest way to add the .jpeg's to an access database and display them in a picturebox inside vb? I have an existing app with a connection to the database. The text is displaying fine from the database, but I can't get the pictureboxes working.
View 1 Repliesi have a treeview which is databoud to a access dataabse, the database has 1 table, and the treeview shows everyname from column 2.
What im trying to achive is for the treeview to also display the names from column 5 and 6 as child nodes of the name from column 2. Been tinkering all morning to no luck, googles not finding much int he way of working examples, just lots of garbage.
this code links to the access database but but I just get only the first row in each combobox...
and I want also cboBox3 depend from cboBox2 depends from cboBox1, how can I do it?
Imports System.Data
Imports System.Data.OleDb
Public Class frm
Dim objConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = DBSOURCEDB.mdb;Jet OLEDB:Database Password=pass;")
[Code]...
I'm new to visual basic 2010 ultimate. I want to make a search button to "search" ms access 2007 database for specific data and display the results in datagridview. I also want to display the data to textboxes.
View 1 RepliesI am working on a small desktop form in VB 2010 and am trying to place a pictureBox with an image in it, next to another pictureBox already located on the form when the user clicks a button.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim tool As String
[Code]....
But for some reason the newPictureBox with image from "ptext" does not show up on the form. When I specify the new Point to be something like, (50,50) instead of getting the first pictureBox coordinates, the new pictureBox shows up in the right place.
Am I using System.Drawing.Point wrong? Or is there some other error that I'm making?
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 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