It's simple question. I am confused since I am new to vb.net and windows form. I would like to display combining of one column (lastname+firstname) in the list box control from the query. My code display something.
[Code]...
I have a program in which I want to have the user enter two percentages and display the data matching the criteria on a new form. The query would be:
Select *
From Corrosion
Where corrpct1 >= {column in database} OR
corrpct2 >= {column in database}
The way I currently have it written is to display only one row of data. I need to display any number of rows that meet this criteria. My current code is:
Private Sub btnDetails_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDetails.Click
Dim form As New frmDetails()
Me.Hide()
[code]....
1. How can I do my query to incorporate the user entered criteria (in the where statement)?
2. How can I display ALL of the data instead of just one line?
I'd like to use a TreeView control to display database data in a windows form with VB2008. All the information what I found is related to a website design, but I'm working on a database program (sql2005), where I'd like the user to see the structure what he/she make up with a TreeView like control. Just something like that when you explore your hard disk. How can I do that?
View 3 RepliesI am working on a project. Part of my project requires me to capture data, for example, email address, from certain rows/columns of a datagridview(form2.vb) and displays them in a textbox on another windows form(form1.vb) with a click of a button(Add Contact button). The problem is the datagridview on my form must be able to display databases by making a connection to Microsoft SQL Server 2005 but so far, i have not been able to do that. I have seen many codes with regards to my problem but i do not know how to implement it.
Below are my codes that i have written so far. My program's limitations are not being able to display databases from Microsoft SQL Server 2005 so i created the statement below to add columns and test my codes.
DataGridView1.Columns.Add("CustName", "CustName")
DataGridView1.Columns.Add("Email", "Email")
[Code]...
what i'm working on is, i have VB with a loaded Access DB, and i'm using a query to display the information, in a list box and in indivual labels. i have it so it will allow new entries to be made, however i can't figure out the exact code to get it to update to the program the only code i currently am able to show is this since everything is basically being done through access
[Code]...
Cannot get list box to display each increment and cannot get data to save correctly in order to display.
Public Class Projectile_Motion
Dim initialHeight As Double ' Holds beginning height
Dim initialVelocity As Double ' holds velocity
[code]....
How do you carry out a query from a criteria e.g name entered by the user from a textbox. and then display the query results in a list box..
View 2 RepliesIn a VB.Net application, how can I either: Find the dropDownList selectedIndex position of something just added to a database.Have a form restart with the most recently-added entry showing in the DropDownList, by way of modifying the inline SQL query to display by date/time added
View 3 RepliesI have added a list box and now i need help to display the data about my employees in the list box. How am i supposed to do that, do we have to put in codes or need to use that small arrow near the list box.
View 15 RepliesI'm using VS2010.Recently I want to migrate my old Visual Basic 6 project to Visual Basic 2010.
[Code]...
I am facing a problem displaying the result of my "select *" query on the form . Here is my code:
[code]...
But when I write this code and run my form I am not able to see any records present in my database tables being displayed on my form. I have inserted a DataGridView on my form . What changes should I do to my code ?
I need to display data from a complex sql query controlled by 2 combos. The sql main query part is working fine but I cannot get to link the combos to the query. On form load I load combo1 by means of a sub. Then with SelectedIndexChanged I load the combo2. Both combos load fine by do not intereact with eachothers meaning combo1 doen't filter out combo2's information.
CODE:
I had created a windows forms application in vb.net. It contained several windows. Now the users of that application are telling me to display all in one main form. They want to see all the details in one form. I had implemented MDI but they want something like tabs. On different tabs different forms should be displayed. How shall I implement this.
View 4 RepliesI try to show my table data type in datagridview vb.net.[code]I try login using username "system". When I run this code, I got error message "ORA-00900: invalid SQL statement".
View 2 RepliesI try to show my table data type in datagridview vb.net. Here is the sample code :
oradb = "Data Source=(DESCRIPTION=" _
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" & txtServer1.Text & ")(PORT=" & port1.Value & ")))" _
[code]....
i have an application integrating the an API (autotask web services). I get the data by using a XML query opposed to a SQL query. I'm trying to figure out how to fill a dropdown list with the returned data. Here is my
Dim AccountID As Integer = 29783925
' Query returns Account details for account with the ID AccountID
Dim strQuery As String = "<queryxml><entity>Account</entity>" & _
[Code]....
I have an excel file that I would like to load into my form and display there.
View 1 RepliesI have a project in Visual Studio 2008 and there is a working data connection to a MySQL database. In other words, I can query the db directly from Visual Studio and it will display the results.
I've tried a couple of approaches that I found online for writing a connection string and accessing the db, but no luck yet.
All I'm trying to do is code a button to query the db and then reset the text property of a label/textbox to display the results based upon another label/textbox value.
The pseudo-code I am imagining is something like this:
Private Sub query_submit_button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles query_submit_button.Click
result_textbox.Text = SELECT field FROM table WHERE otherfield = key_textbox.Text
End Sub
I didn't see any related questions posted on SO - forgive me if I missed one that already exists and this is a dupe.
What is the correct way to accomplish this?
EDIT
Using MySQL 5.1
I am trying to read data from a text file that will be displayed in the below format:
usernameassword
username1assword1
username2assword2
What i want to be able to do is read each line of the text fine and then split the text where the colon character is and display what is in front of the colon in listbox1, and what is after the colon in listbox2?
[Code]...
i'm developing a project on employees. I have added a list box and display the data about my employees in the list box. How am i supposed to do that, do we have to put in codes or need to use that small arrow near the list box.
View 1 RepliesI have these objects:[code]Using LINQ I need to take a List(Of MakeInfo) and a List(Of ModelInfo) and aggregate the StockInfo from ModelInfo into the List(Of MakeInfo).So for each MakeInfo I will have a total count of all stock where MakeInfo.Name = ModelInfo.Make, and also a minimum price.I think it's going to be something like this, but I'm having trouble accessing the nested object and not sure if it's going to be possible with a single query.[code]
View 2 RepliesI'm new to Visual basic (which will be obvious from my question) and am writing program that does various calculations, then displays the results in a list box. the results, however, are all concatenated, end don't each appear on a new line. I tried adding a carriage return/line feed at the end buit the compiler rejected it.
I can't find any examples of creating a list box, and adding multiple entries (one for each time a loop is performed), nor of how to use columns to make the resulting display cosmetically pleasing.
Public Class Projectile_Motion
02 Dim initialHeight As Double ' Holds beginning height
03 Dim initialVelocity As Double ' holds velocity
04 Dim time As Double ' holds time
05 Dim heightVal As Double ' holds height at different intrvals in time
[Code]...
I'm using this code to search a msacces db and display the data in a listview.The Search is fired after the text_changed event of a textbox. So each character is a search and also each backspace(here's where the real pain is) it will search. When I use backspace its very very slow! When I use 100 or even a 1000 records no problem but this db has 10.000 + records.Whitch event can I use to solve this problem or how can I adjust the code for faster search? ALs o when I test on a windows7 system, dualcore, 2gb memory, when I press a key it will take time before I see the character in the textboxs? Its a new system and only runs this program.I use a texbox to enter for example an artist name and a combobox where the user can choose to search on artis, title, genre etc. [code]
View 12 RepliesI'm currently working on a Capstone Point of Sales project. We're using a multi-column list box to pull up the item #, Item Name, Quantity(may be deleted) and Price. However, I haven't had much experience with a connect database in Visual Basic. how to pull and display the data from the database into the list box?
View 5 RepliesI'm having trouble with collections and how it works, what I have so far is classes and I have attempted to do collection but it is not working properly. I am trying to have the collection hold the classPerson,classCustomer, and classPreferredCustomer properties, and then display it to list and labels in the Main form. [Code]
View 7 RepliesI'm looking for an example of a service application with an user interface.
I've currently a project with a service. Now I want to display some values from that service into a windows form.
I created a rectangle shape and tried to show it at my form like this
Imports Microsoft.VisualBasic.PowerPacks
Public Class frmBoard
Dim baseDice As RectangleShape
Private Sub frmBoard_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
baseDice.CornerRadius = 5
[Code] .....
i am using MS access as my database and VB.net(2008) as my programming.my table has four columns.my table name is myRecordtbl and the columns are ,myid, myname, starttime and endtime.now i know how can i insert into table. but i got hard how to display times then i can choose to insert into my table.the time should be in the form of Hours:Minutes:Seconds AM or PM with up and down arrow.then when i select the time and hit ADD, it should insert into my table.
View 2 RepliesI'm using VB 2010, accessing a MS Access database. I have constructed a simple Windows Form returning data from the db, one field of which has a reference to an image I'm trying to display together with the data from each individual record.
I have a field with a product number, that matches the jpg file name (ie, the product number 5505 matches an image that I want to display, namely 5505.jpg). I've even created a new field in the db called 'Image', that contains the full name 5505.jpg.
So, I've connected to the db with an OleDbAdapter, and all the data fields are displayed via bound textboxes. I've been able to display a single 'set' image with a PictureBox, but I'm not sure how the make the connection between the returned data (txtSearchImage which is, say, '5505.jpg'), and getting the Windows Form to display this.
Am I on the right track using a PictureBox? I've tried binding this via the PictureBox properties to the relevant data field, but (obviously) it doesn't make the connection to the image file on my hard drive.
Here's my code so far:
Public Class Form1
Private Sub btnSearchKits_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchKits.Click
' The following line passes the value the user enter for state
[Code].....