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 am working with a future value application and I am trying to display the calculated future values in a listbox. For instance, I input the monthly investment, the yearly interest rate and the number of years into textboxes and I want the application to list out the future value for each year until the number of years in which I entered is reached. I cannot figure out how to get the code to display the value after each year. I am trying to use the "mod" operator to display the value each time the 12th month comes around.[code]...
View 7 RepliesI 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 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 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 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.
I have a datagridview that is populated from an Oracle 11g DB. What I would like to do is add the values of a column together and display the results in a textbox. What would be the easiest way to do this?
View 2 RepliesI am attempting to teach myself visual basic and I cannot figure out how to send a calculated value (on a button click) into a one-dimension array and then recall the last five values in a message box when the user exits.
Here's what I have:
Public Class frmInvoiceTotal
Dim totals(4) As Decimal
Private Sub btnCalculate_Click(ByVal sender As System.Object,
[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 Repliesive been struggling on this portion of my code for almost 3 days with no luck. i have a database containing a list of transactions (in this case, the product name, quantity and date of sale). I want to plot a graph for each product showing the amount sold each month for the past 12 months. The functions to calculate these values are working fine. but my problem is this:
each tab page is named after the product name:
TabControl_SaleOfProducts.TabPages.Add(
"TabPage_"
& ProductName, Item)
and then to this tab page i want to add the graph. but i cannot reference the newly created tab page?
This is my first time joining a site like this and I'm trying to learn vb .net. Im very new to the concepts and this was my last resort because I cant find the answer im looking for. Below is my code, and all I want to do is display the calculated resaults in a summary. Weather it be a message box or a diffrent form it really doesnt matter.[code]...
View 2 RepliesI'm writing a time entry program to record when an employee checks in and when they check out.I'm struggling on the part where I need to calculate a time span (time out / time in). I am selecting the In Time, Out Time, and Total columns.I want it to take the Out Time subtract it from the In Time and place that value in the Total column.I have so far and have tried several variations of different updates but have had no luck.[code]I keep getting a syntax error in the UPDATE statment.I'm not very fluent with OleDB yet and I'm not sure if I'm doing the update correctly.I have no problem with OleDB and single UPDATES or single field updates but when I am updating multiple rows with different values.
View 16 RepliesDataGridView1 is bound to a sql table. Cells(0) and (1) come from that table. Cells(2) and (3) are calculated. While debugging the code, the calculations and lookup look fine, but the results will not display in the columns. Here is the code:
Dim SeatsUsed As Integer = 0
For Each r As DataGridViewRow In DataGridView1.Rows
Try
[code]....
I work with both vb.net and c# in Visual Studio 2010, and something which annoys the hell out of me is that XML Summary blocks display differently between vb.net and c#Opened summary blocks look like this
VB
''' <summary>
''' This is the summary of what the method does
[code].....
After I change my LvList format Currency
Private Sub prodList_Activated(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Activated
For Each itm As ListViewItem In LvList.Items
[Code]....
If I dont make ProdList format currency my Total is normal = 13.850 my prodList or my sub Total?
i want to get some values from my database and display them in a textbox.how can i do that?
View 1 RepliesI want a msg box to display when the values in a textbox are between 1 and 17. Should I use Integers and if statements?And if so how?
View 8 Repliesim trying to add the values in column for of my datagridview and display it in a textbox, but the calculation does not kick in unless two rows are displayed. if one row is displayed in the datagridview, then my textbox remains blank.[code]......
View 5 RepliesUsing VB.Net,In my application, am using datagridview, when i clicking the particular row, that rows value should be appear in the textbox.So the code should be come under the DataGrid3_CellMouseDoubleClick Event.How to dispaly a rows value in the textbox.For Example
3 rows means - 3 rows values should display in 3 textbox.
vb6 code
Private Sub datagrid1_DblClick()
textbox1 = datagrid1.SelectedItem.SubItems(1)[code]....
How to write a code in vb.net by getting datagrid row values.
I have a search textbox in my form. I also have, textboxes for computer name, mouse serial number, monitor serial number and phone number. While in my database, they are all reside in one table named tblComputerAsset. I am using Access for my Database.
[Code]...
I have completed all the code for a loan calculator, but am unsuccessful in displaying decimal variables in string as "currency". I have added the .toString("c2") statement and only get one array to display in currency, then the second array does not round properly. Is there a convert function that will work? Here's my code:
Public Class frmLoanCalc
'Ken Schoening
'Loan Calculator
[Code].....
Suppose der is one database name Customer which have columns like Cust_ID,Cust_Name,Cust_Mob,Cust_Address And on Form der are one list box which contains all Cust_Id from database and 4 textbox so when user click on the listbox having id as 1 it should display name, mob and address of cust_id 1 in 4 textbox respectively?
View 18 RepliesI would like to draw a figure like this. But i do not know how to start drawing it. What i could do is simple mathematics calculation, display something in a label and taking some values from a textbox.
View 18 RepliesI need to ba able to display the results from sql into a MsgBox and have the option Yes/No.
My SQl is : SELECT account FROM Ta Where cost=0.
this will return about 10-15 rows, i need to see te accounts with o cost befor i continue.
[code]I have a listbox, 4 radio buttons,a textbox and a button. I want the user to type in a number into the textbox, click on 1 radio button(multiplication) and then click on the button to show the number entered into the textbox multiplied up to 3 times. [code]
View 1 RepliesI can get the results if I plug a number in for i, but I get them as a string for some reason.
Private Sub displayButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles displayButton.Click
'display Fibonacci results
Dim fib(10) As Integer
Dim i As Integer
Dim fibn As String
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'd like to add a generic search feature to my WinForm application (Visual Studio 2010). I want the users to type in a value (for instance john), and then display a list of any company, contact, or student records that contain the search value in the name[code]...
View 3 RepliesHow could I add array values and populate the results in a specified text box?Then repeat for each line after. Then get a final total.
For example:
1 2 3 4 5 (15)-text box
1 2 3 4 5 (15)-text box
2 4 4 3 5 (18)-text box
-----------------------
(48)-text box
I 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]...