I've made a program for a small business that keeps track of what items there are, their prices, and the quantities of those items. I would like to add a button that goes along the lines of "Add to sale" or "Add to cart", and have it select the currently highlighted item in the database grid view to add the price column up, to make a total for a sale.
[Code]...
I have a program where you have three entries, CD name, artist, price and it goes into a listbox and .txt file when closing. I have to have a message box if you enter the same CD name. I have a code to open the .txt file and compare strings but I need to change it to compare only the CD name and not all three entries. Is there a way to do my string compare against my listbox without opening the .txt file?? The program loads the listbox from the .txt file when opening. Private Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click' adds CD information to the list box
' declare variables
Dim strName As String
Dim strArtist As String
Dim strPrice As String
[code].....
My first method is trying to get all entries in one of the database tables. However when I try to build the solution this is the error I get:
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Error
1 Value of type 'String' cannot be converted to '1-dimensional array of String'.[code]....
In my head form, in have a few textboxes related to an access database.
How can i put my entries in my database.
I already created a connection, dataset, tableadapter,...
I manage to show some data of my database in to the form but not in the other way.
I want to set a certain column to true or false automatically based on what value another column has entered. I managed to get this working by myself using the 'SQL Pane' in VB and testing it by using execute sql but I don't know what to do now. I assumed that I could just save it and it would work from there but that's not the case, it dissapears from the SQL Pane if I close the project (even though it worked fine when I ran the project the first time), so where do I put it/what do I do with it in order to get this to work?
View 1 RepliesI conected my access database with the form and I need the code to count how much entries are in the database and increase that number by one, and then to write that number in one textbox so that when I press save in the form the entry would have that numbar as id.
View 7 RepliesI have an accounts program. My cash book shows data based on date picked from DateTimePicker. Cash book is not entered everyday. I want to make my datetimepicker so that based on dates found in the database, it changes colour or enable / disable some dates, for which cash book has been entered. How is it possible?
View 6 RepliesI created a simple database that has 3 tables & 2 joint tables for data entry purposes.The tables & fields are listed below. All items that appear in red are the primary keys
Employee
EmployeeID
- FirstName
[code].....
Is it possible for Forms to check for certain entries in an online mysql database and to create new ones? (login/registration)
View 8 RepliesI just starting coding in VB.net about two weeks ago so I'm still a begging and I learn best by seeing working code and then adapting it to my situation. That being said, I need help displaying table entries in a listbox. I've successfully created a database in my test application, added it to my Data Sources and used a drag / drop method to add Datagrid View & Details (labels & textboxes) to my application for testing purposes. Now I want to try and display table entries in a listbox.
Example Database:Table: Contact
- ContactID (autonumber) [primary key]
- FirstName (text 50 limit[code]....
Also is there any benefit or down side to creating a database in MS Access, create the relationships & tables, then attaching that database to my application or is it better to create the database in the application like I did in the example above by using the Add New - Service-Based Database option?
I have a program with two forms, one that handles the applications controls, and the other with the functions that open a file (csv), open a database, and query the database. The controls on the first form are a list box, three labels (to display parsed csv information), and three buttons (clear database, load database from csv, and load listbox).
The clear database and load database buttons (events) seem to function correctly.On the other hand, the load list box event doesn't function 100% the way I'd want. [And, I can't test the selected index event yet]
The code for the load list box event is:
Code:
Dim db As New DBUpdt 'second form
b.openConnection("weather.mdb") 'open database connection
db.query("SELECT * FROM stations") 'query database
Do While db.moreRecords
[Code]...
You see, in my new VB application, I have a form with a TextBox and a ListBox, and I need to make it so that, whenever some text is written in the TextBox, a SELECT operation must be performed in a table belonging to an SQL database, in order to return the elements of a particular column that are LIKE the text I just wrote in my TextBox. The results of this SELECT operation must then be written inside the ListBox.In other words, whenever I have some text inside my TextBox1, I have to do:
SELECT Description FROM Elements WHERE Description LIKE TextBox1.Text (this must be done whenever the text changes)And the results of this operation must be displayed in the ListBox on the side.
How do I code the total cost to give me a pound sign with the total cost at the moment when the total comes up for an example it gives me 3.6 when I need it to show £3.60 here is the code I have so far. [code]
View 2 RepliesI am trying to take a database with multiple entries of 11 digit numbers and run a check sum algorithm that adds the 12th digit to the 11 digits as an output.The algorithm is as follows:
Add sum of odd digits starting with first digit, then multiply by 3.
Add sum of even digits, then add to result of odd digits multiplied by 3.
Take result and divide by 10. The remainder is the check sum which needs to be added to the end of the original 11 digits.
I'm looking to retrieve all the entries from one column of an access database table and copy to an array. this array i will then be randomly selecting values from it to create foootball fixtures. I'm confident of being able to achieve the random side of it but i'm struggling to get the records into the array.
View 12 RepliesIm making a 'DVD database'. I need to be able to cycle through entries in the database wit ha next and previous button but for the life of me cannot figure out how to do so.
[Code]...
I am working on getting a multiple values from a single column displayed in a single textbox or label. I know I should be able to find the information I need online, but I am coming up empty. I am using Visual Studio 2010 with SQL Server 2005. For example, I want to pull all the email addresses, that have a value, from a table and display them together. The output I am looking for is like this:
[Code]....
I have data entries in my database that have a common field. For example:
account_id type user_id
1 new 1
2 old 3
3 new 1
4 old 1
I am using a query like this(mysql): SELECT account_id, type, user_id FROM table WHERE user_id = 1
This is just all theoretical. The problem that I am having with this is it is only returning the first result in this case account_id 1. How can I get it to find all the results with the user_id 1 because in the way I am thinking that it is failing is that it is finding only the first result and then ending?
I'm having some trouble firstly trying to calculate the total of a column in the database connected to my vb.net project. Then I want to divide that total by the number of items in a listbox. This is my code so far:
Private Sub btnavresult_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnavresult.Click
Dim sqlx As OleDbCommand = New OleDbCommand
[Code]......
I get an error saying "No value given for one or more required parameters." when I try to run my program on this line "Dim rdr As OleDbDataReader = sqlx.ExecuteReader()"
The pay rates for the project are:
a. Level 1 - $10.00
b. Level 2 - $12.00
c. Level 3 - $14.00
d. Level 4 - $16.00
e. Benefit Deduction Rate - 0.10
f. Overtime Factor - 1.5
For ease of program maintenance, all of the above rates and factors must be stored in module level constants. All references to pay rates in the program must refer to the module level constants.
When the Calculate button is clicked:
a. The value in the Hours text box must be validated to insure that it is numeric value greater than zero.
1. If the value is not valid, a message box must appear as shown below and the user must be offered the option to continue processing or quit the program.
2. If the user chooses to continue processing, the focus must be set to the Hours text box.
3. If the user chooses to quit, the program must close immediately.
b. If the value is valid, the program must calculate and display the total pay in the Total Pay label.
1. The pay rate is determined by which Job Grade radio button is checked.
2. For hours less than or equal to 40, the total pay is the hours times the pay rate.
3. For hours greater than 40, the total pay is 40 hours times the pay rate plus the hours in excess of 40 hours times the pay rate times the Overtime Factor.
4. If the Full Time radio button is selected, the total pay must be reduced by the Benefit Deduction Rate.
5. The value displayed in the Total Pay label must be formatted with a dollar sign and with two decimal
places.
6. The focus must be set to the Hours text box.
Why i get an error when i try to run this code
Code:
Also the message box, both yes and no close the program.....
I am working with VB 2008. I want to be able to run this program say in N: and it will show me in an excel sheet the following:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
where clients contains subfolders and files and the size is the total of all those files within each folder and the count is the total within each folder also.
This works fine as it is but i have to select one by one the top level folders and some of them are huge so it takes forever to give me an answer.
1) I would like to see in my spreadsheet the following by only select the network drive n:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
N:Software 10.7 15430
N:Billing 0.98 105
2) I would also like to know if this is the faster method.
3) I tried adding a progress bar so that the user can have an idea of how much this will take but i had to remove because it was not working.
4) I would like to see the folder name, size of folder and count of files in the listview.
Here is the code:
Imports Microsoft
Imports Microsoft.Win32
Imports Microsoft.Win32.Registry
Imports System.Collections
[code].....
I am using Visaul Studio 2010 to build a Windows Forms application to maintain a table in an SQL Server 2008 database. The table is named CASHBOOK and here are the further details:
DATE | DESCRIPTION | DEBIT | CREDIT | BALANCE
--------|----------------|---------|-----------|---------
1/1/2011| CASH BALANCE | | | 5000
1/1/2011| SALES | 2500 | | 7500
2/1/2011| PURCHASE | | 3000 | 4500
2/1/2011| RENT | | 4000 | 500
2/1/2011| SALES | 5000 | | 5500
I can use CASHBOOKTABLEADAPTER.INSERT(...) to insert appropriately, but my problem is how do I update the BALANCE column?
I'm maintaining a Accounting program.. I have a Cash Book Table in SQLserver Databse...field are DATE DESCRIPTION DR CR RT(Running Total is empty record). When in Insert a transaction into that Table the Running Total should give the correct balance for example :
Date Desc Dr Cr RT (Running Total)
1/1/2011 Cash Balance 5000 5000
1/1/2011 Purchase 2000 3000
[code]....
I'm inserting record into that table through Windows form.
I am using visual basic 2008 amd creatomg a datagrodview format like below [code] Now I wnat to get total balance in total column after less discount in percentage with ENTER EVENT proceedure and get the whole total column balance in a textbox i.e Net BalanceTextBox. Please tell me how to calculate discount in percent % and get total in total column and also tell me how to move cursor in next cell instead of bottom row in datagridview.
View 2 RepliesI have 3 columns in a unbound datagridview, "length" "height" and "Total". Total = length x width and the final total in TextBox outside of the Grid. I found question simalar in this forum and tried the code but i am getting errors.The following is the code i am using
Public
Class Form1
Dim UnboundColumn[code]...
how to find out the total number of rows in a database through datareader
View 3 RepliesI have a table from a database and i need to display the total number of record and display it in a label.i already have binding navigator but i will not use to display the total number of record in that table. and i will also make that binding navigator invisible.
View 2 RepliesI don't know if this is the best way to do it or not but here goes.I have an access database and a datagridview and they link via a SELECT statement at runtime.I want to total one column named LNLMTS and display the result.I am looking at using SELECT Sum LNLMTS FROM tblProduction WHERE SO=@so AND DATE=@date
View 8 RepliesI'm developing Asset Management System, it will compute for straight line depreciation, my problem is how to calculate running total on each group that I've extracted from my database.Here's a snippet for my extraction of data
Private Sub cboAType_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboAType.SelectedIndexChanged
ListView1.Items.Clear()
If Not cboAType.Text = "-" Then
[code]....
I'm new to forums as well as new to VB 2008. I'm in process of making a order calculator which will total any values you selected in combo boxes/checkboxes and then display it in a selected area. There are 3 things that I want to achieve: 1. Be able to add another total to an existing total (currently I'm able to see only one total when I hit "Calculate" button)2. Display how many orders I have made so far (new total counts as one order)3. Be able to add up checkboxes selected to an overall total. (when I try to add up one checkbox with another it seems to be stuck on 1.5 pounds which I assigned for each "side order")
View 4 Replies
