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 Replies
I have created a small program that performs various calculations with data entered by the user. I need to be able to save the entered values and the results on the system running the program and be able to open it at anytime in the future and have the values and results displayed in the correct text boxes. I am currently reading up on some tutorials but I was just curious as to how I can send all my data in Visual Basic to my database in Microsoft Access?
View 4 Replieshow to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesMy project consists of a user interface designed in Visual Studio 2010 Express. I have it linked to an Access database. At this time, I have two text boxes that the user will enter a number. I want to be able to write a query that will take the first and second number and pull the information from the database that is equal to or greater than the user entered number
View 6 RepliesI am trying to display query results from SQL server in VB. I wrote following code, but not getting how to "Just display the results";
[Code]...
1. How to produce querry results within the application by user input. ( I want to acheive a similar function to querry in MS Access.
2. How to produce results in a form application from a preassigned querry triggered by a button click event.
I am working on making a Windows based application within Visual Basic 2008 Express that could potentially be used for a music school as a project. This application is connected and bound to a Microsoft Access database. Within this application I have a form for adding a new appointment reservation. This form has a combo box that the user can select the lesson type (eg. "I want a piano lesson"). Upon being changed, a list box would be populated with the names of all instructors that have that selection as either their primary or secondary talent.So, my database is bound, the query is written (correctly...i hope), and I don't know how to 1) select the table column that I want displayed in the list box and 2) actually display the query results within the list box. Is this making sense? Probably not, bu
Private Sub cmbLessonType_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbLessonType.TextChanged
'populate the lboInstructor box
[code]....
ill get the obviuose out of the way. I have XP Pro, VB2010, query(read only) to an ODBC db, displaying several results in a text box. How can I make the data display w/o the the numbers displaing decimal places. These are quantities that are to be displayed not pricing, ie. the result would say 7.0000 qty on hand, and it should say 7 on hand. The code is below,
[Code]...
I am trying to create a CLR SQL Stored procedure that uses a query and adds the results to a list in VB.NET. Through debugging I determined that my add statement for the reader into the List is somehow converting my data types and throwing an error when I attempt to execute the compiled Stored Procedure.The columns I am querying are Integers
Code:
Imports System
Imports System.Data
[code].....
I am learning VB.NET and wanted to try and connect to a Oracle.DataAccess with this simple SQL Query but am stuck how to get my results.
Imports Oracle.DataAccess.Client
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click[code].....
When I run this application the 2% menu item works fine but the 5% does not. It does nothing at all. I'm stuck.
[Code]...
I have a database I am creating with about 50 users over a network. There are about 6 groups of users and these users are spread across 10 branches. I want to block/allow users from particular forms and views. For example I want branch users forms to be filtered by their branch number but depending on the group they are in they can only see some forms. i.e. 50 users, 10 branches, each branch has about 5 ppl of where 1 is in group A and 4 are in group B. I want all users that belong to branch 1 to see the information they enter, but Group B enter data but cannot approved or delete, and group A can enter, approve and delete. So then. On my login form I have the user type his/her username but the i want LEAVE function to update 2 textbox where I have named GroupName and BranchNo. Basically to run a query and look for the username and return in one textbox that user's groupname and the other textbox the user's branch no. This information will be used to filter forms and block the user from certain controls. This is the code I have so far but still can't figure how to display the results.
Private Sub UsernameTextBox_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles UsernameTextBox.Leave
'Make Connection to database
[Code].....
It keeps highlighting the BranchNumber and UserGroup and giving error "Value of type 'String' cannot be converted to System.Data.OledbCommand
I want to display the first and last characters of any given string entered into a textbox. The strings can be of any length as the user wants (as long as it is one word) I would like to be able to do something like this... "william = will and iam" or "Celtic = Cel and tic"I understand I would have to split or divide the string. How would I go about doing this?
[Code]...
I 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 wish to build and display a simple diagram that is built from data entered by the user. Because I can't post a picture of the types of diagrams here I'll use the following example. Image a picture of a house as a child might draw it a large square, with a triangle for a roof, a rectangle for a door, and two smaller squares for windows. Now I want to build an application that lets the user enter data and change that drawing according. For example, by entering the length and height of the house the size changes, change the number of windows, size of the door or height of the roof.
Now this may seem like a useless application but keep in mind the house is just an example the real purpose is different but should be as simply drawn. I'm looking for suggestions on make this work. Should I use a paint? or is something like this better done with a tie into the Visio references?
I've got a (hopefully) quick question. I've got textboxes attached to a binding source on one of my forms, and when I add, then clear, the data for the next entry to be added a small problem arises. If the user has previously entered something into, for example, Textbox3 and the user does not have the data for Textbox3 the user cannot move to the next field unless something is entered into the box.
[Code]...
I would like to create a vb form with a combo box (with song title), a text box (for song lyrics), and a button (to submit or refresh). It is linked with an access database. The combo box is populated with the songTitle field in the db (this part works fine). The text box is populated with the lyrics that go to that song The first updates fine but I can not figure out how to run a query to pass to the text box's text property. I want the user to be able to select a song from the combo box, click the button, and have the text box populated with the new song's lyrics.
Any suggestions on how to accomplish this, or a good place for a tutorial that explains the necessary elements for having vb query a database and return the results?
My name is Tim I'm having a problem getting my multiple selections from my list box to display in the results label and there is no examples in the text any how I'm thinking I need to use a loop to get it done. is this evern in the ball park?
Option Explicit On
Option Strict On
Option Infer Off
Public Class MainForm
[code].....
I am trying to setup an SSN Masked TextBox, the mask i selected for the field is 999-99-9999 When the field has no info the mask pattern shows in it, i would like to hide it and display it only upon info entry, meaning the user will enter the first 3 digits and then '-' will appear, will enter 2 more digits and then the second '-' will appear.
View 6 RepliesI am working on a simple program called "Who's Connected?" where it runs a command (netstat -aon) and then displays the results in a multi-lined textbox. However, when I press the button that will run the command, it tells me that it can't convert the string to an integer or something. And when I did manage to get it to convert to an integer, it really showed an integer in the textbox instead of the connections and IP addresses. What do I do? Here is the code I have: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Running command and displaying results in textbox1 TextBox1.Text = CStr(Shell("netstat -aon"))'Results end up being a triple or quadruple digit number End Sub
View 2 RepliesWe use a database to create Data Collection forms with dynamic items
I used this code to generate labels and textboxes from a table in database (when the user hits the button "load CRF")
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click[code]...
Inside a multiline Text Box I want it so that when a user presses Ctrl AND Enter then a new line is entered. But, if they press Enter on it's own, then it acts like the Accept button on the Form. I believe this is how Facebook does it.
Ctrl+Enter=NewLine Enter=Accept
I am currently attempting to write a program that will take a SQL query saved as a .sql or .txt and execute it against a specified database, and output the results to file. I have seen some sample code of executing a SQL query line by line,
and writing individual results to file.
The query that needs to be run is only reading information from multiple tables, but is pretty lengthy to do line by line. Is it possible to execute or read the whole query from the .sql file, or a text file, and run it against a specified database, and
have the results of the query output to file in vb.net?
So I'm trying to program a selection structure to display different commission rates per sales entered in a textbox.I need to have the commission total display alone. I have the simple interface done, but I'm having trouble forming the selection structure.
View 1 RepliesHow can i display search results on textbox etc. like i have wrote code for searching and then it selects values as per search but later how can i display those values on textbox , i have no any idea about how to do this, i usualy use databinding but in this case i dont think i can use databinding
View 4 RepliesI am making a project in VB 2008 that has a Form (form1) that allows me to add new records to a database, and another Form (form2) that allows me to search for records in a database. I have done Form1 already, but my problem arrives in Form2 where I have to query the database. This form consists of 1 textbox (txt_search.text), 1 button (btn_search) and 1 datagridview (datagridview1). The name of my database is db_extras_test2003.mdb and the table I want to search records from is tbl_contacts.
I know +/- the SQL sintax to query the database (SELECT * FROM tablename WHERE columnname = (here i dont know if i put the variable name i have set for the txtbox, or the textbox itself)).I want this in a way that I (or other users) type in the textbox, hit the Search button and the results are shown in the datagridview (i can show the results in another way if it is better to do so).I have done the connection to the database already. The code I have so far is the following, but it doesnt work
[Code]...
I had done this by using the query builder (in VS Studio) but soon found out thay I gain no points by doing it this way as I am not using any code. I have tried to adapt the code I had to insert data into my database, just changing the SQL sintaxa and some other bits, but it is not working yet. Well, it gives results, but I think it is still geting the results from the query I had built using the query builder. Here is the code I've got so far:
Public Class Form2
Private Sub btn_search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_search.Click
Dim str_search As String = txt_search.Text
Dim str_dob As String = txt_dob.Text
[code]....
I am using a WCF to connect to my database. I have the code below, I am trying to select all the details from the database where the customernumber = what the user has entered on the form.However, I cannot return a dataset to the form as it sends in a string.
Imports System.ServiceModel
Imports System.Data
Imports System.Data.OleDb
[code].....
I'm trying to learn vb .net. Below is my code, and all I want to do is display the calculated results in a summary. Whether it be a message box or a different form it really doesn't matter.
Public Class Form1
'Global Declarations.
Const STEREOSYSTEM_Decimal As Decimal = 425.76D
Const LEATHERINTIERIOR_Decimal As Decimal = 987.41D
Const COMPUTERNAVIGATION_Decimal As Decimal = 1741.23D
[Code] .....
I have a single form in Visual Studio 2010...in that form...
TextBox = txtSearch
Button = cmdSearch
DataGridView = GridView1
GridView1 is bound to a View, tblAccounts.
tblAccounts includes multiple columns, including a text field for 'AccountName'...this name can be in one of two columns.I'm trying have a user enter any part of an AccountName in txtSearch, click cmdSearch, and return all matches in tblAccounts to GridView1.
