I have this code to compute average and stored the result in textbox3.[code]In label6 I want to store the result (2+3+5/3=3.33 so in label 6 will be displayed the result 3.33 and in label 7 will be displayed the result 3 because it rounds my result from label6.
View 4 RepliesMy assignment was to compute design a {Loop, Array } that user inputs grades and calculates the average, Im stuck on the part of computing avg but i
Module Module1
Sub Main()
'Declare Array called Grades with 4 Elements
[code].....
[code]how can i get the result value in stored procedure?
View 3 RepliesI am working on a project that requires me to hop into to separate DB's. So I have figured that I need to have multiple functions inside of my VB page. The only problem I am having,is I am not to sure how to get this all accomplished. So far I have figured out the overall structure, just need to implement that structure.
Here is my idea:
The main Function would call two other functions. We can Call them Sub Function 1 and Sub Function 2. So, the main Function takes the saved sessions information for the E-mail address and dumps in into Sub Function 1. It needs to open up a new connection to the db/stored procedure and RUN the following procedure and then return the result. Here is the stored procedure and what I think is correct.
CREATE PROCEDURE WEB_User
(@EMAIL_ADDRESS varchar(80) = [EMAIL_ADDRESS])
AS SELECT MEMBER_NUMBER
FROM WEB_LOGIN
WHERE EMAIL_ADDRESS = @EMAIL_ADDRESS
So my question is, what is the function suppose to look like? how do I send the session information to the procedure? and finally, how do I return the stored procedure results and push back into the main function so it can be carried into sub function 2?
What I need to do, is to call a SQL stored procedure from VB.NET, and then store the returned query value in a string.
View 13 RepliesMy IDE is MS Visual Studio 2008.I just want to ask how can I get the result of a store procedure from MS Access using VB.Net and use the result in a Crystal Report.
I have a Windows Application Project that requires this function.
How I can execute a stored procedure and the put the results into a webbrowser to display. I know html so I will format the stuff to look how I want it to.
View 6 RepliesI have a stored procedure that takes in 2 parameters and returns an integer value. I would like this value to be the value for a gauge chart on the page. The 2 parameters will change depending on the attributes of the selected item. Is there a simple way to pass the one value from the stored procedure to the chart to display? This will be embedded in an asp.net application (vb) - so depending on the previously selected item, the values for the parameters and result will change.
View 1 RepliesI want to include an average in a column where the average ignores zero values in a report cell where the column may have
17
19
0
[code].....
I want 16, not 11 so (17 + 19 + 12 + 13 + 19) / 5 not (17 + 19 + 0 + 0 + 12 + 13 + 19) / 7 Something like this if it would work.
=SUM(Fields!fieldname.Value) / Count(iif(Fields!count_cycle_per_hour.Value >= 0,Fields!fieldname.Value,0))
Essentially just average everything in the column NOT a zero?
I'm working on a function to return a exponential average and there are a lot of examples of exponential moving averages but they all start with a moving average that is just the mean as a lead in to calculating the continuing moving average. I needed just a exponential average of a value set. After Googling my Bing off I still haven't seen anything so here is my attempt at a basic exponential average. Is this correct? Are there any errors? I have seen some text about adding a smoothing value to change the curve of the exponential average but not how that would be implemented.
[Code]...
I put comments on the average output since I kept getting error messages about that. My out keeps saying:
Maximum value: 33
Minimum value: 33
what am I doing wrong?
Option Explicit On
Option Strict On
[Code]...
I'm in a computer science class, and we are writing simple programs using Visual Basic 2008. I am really inept when it comes to this, as I have never done it before. I need to write a program that: "Asks the user for 5 numbers and computes the average. It then displays the average with an appropriate message before the average."
I have been really close with this, but I can't get the numbers to add up, then divide by 5, and display a pop up message.
i am writing my very first program with visual basic 2010. my question:
textbox1 + textbox2 = textbox3 if i want to add textbox1 and textbox2 together and display the value in textbox3 WITHOUT creating a button for a command, what do i have to do?
basically, i want the value to appear in textbox3 automatically when i input textbox1 and 2.
I have a webbrowser and I want it to auto navigate the text at Textbox3 when the form loads.
I used this but It does not work.
Dim FILE_NAME As String = "DATTALCS.txt"
The webbrowser just stays blank.
I was wondering how I can make textbox1 get divided by textbox2 at the click of button1. The number will go into textbox 3. I was also wondering how I can make the number round up or down. I also want all three text boxes to only accept numbers.show me the code in an easy to read format.
View 2 RepliesI want to make it so that Textbox3 is always 1 less than TextBox2, how would i do that?
View 1 RepliesI have fixed my account creator. Which takes information from textbox3 and 4 and saves it as a .txt file. With the username in the title ex: username.txt. I run the program and it doesn't create the txt file.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Using sw As StreamWriter = New StreamWriter("LOL.txt")
sw.Write(TextBox3)[code]....
I have three textbox textbox1, textbox2, textbox3where
Textbox1.Text = 739
TextBox2.Text = 2.95
TextBox3.Text = Val(TextBox1.Text) * Val(TextBox2.Text) / 100
[code].....
Lets say that I had three TextBox's and they are named TextBox1, TextBox2, and TextBox3, is there a way to do like TextBox And Rand(1,3).Text = Nothing? Something similar to this where you click a button and it will choose at randomly a textbox to clear?I know I could do like Dim Number = Rand(1,3)if Number = 1 Then TextBox1.Text = Nothingend ifif Number = 2 Then TextBox1.Text = Nothingend ifor use else if and such, but I have 12 different textbox's, not three, so, I want to shorten the code, if you could do something like TextBox And Rand(1,12).Text = Nothing that would defenitely be way shorter, can you do anything like that to put together "TextBox" and the number to reference the control? I am not looking to use the full controls list to search for the right control nor to make an array that contains the controls, I just want to reference them without adding extra arrays or searhing for them.
View 2 RepliesI am currently having a headache on how to solve this problem that i am facing. here is the situation: I have a combobox and a list box on the main form. The combobox will get the data from the ms access database. In the database, i have the details of a person's IC, Name and DOB say for eg on one entry I have D215311523C,SHAWN,13/04/1987 So now, my combobox on form load will show the list of dates in the database to allow the user to search base on the date itself by clicking on the selected date. So when the user clicks on the particular date say 13/04/1987, people in the database whose birthday is 13/04/1987 will be shown on the listbox.Meaning to say if i have 3 entries whose dates are the same 13/04/1987, 3 entries will appear. If there is only two entry, then two results will be shown. But now, when i do a single click on the date, one result will be shown. That is correct. But the problem is when i click on the same date again, three of the same results will be shown on the list box. that is it will display : 13/04/1987 13/04/1987 13/04/1987 which is not the case. Then it will show more duplicates of the same results if i click more times on the same date which should not be the case.
Dim n As Integer
Dim numbers() As Integer
Dim StartFrom As Integer
Dim EndAt As Integer
[code].....
I am using a datagrid in my where i am having four columns. In first column the parameter values are entered and in the second column measured value is entered and in third column the nominal value is entered.Inthe fourth column the result is displayed by subtracting the measured value and nominal values. I am doing this calculation in Datagrid cell validated event. What i want is,there will be many rows in the grid,when typing the value in the third column the corresponding result will be displayedin the rowof theresult column,save button will be displayed while the form loads,when the calculate part is completed that is there should not any cell of the resut column empty then i should enable the save butto.
View 2 RepliesI am encountering the following issue So i have a device that sends stuff at the serial port, i then parse it and put it into an array of bytes like that:
Dim HCI_Command_Rcvd_Byte() As Byte All good till here What i wanna do is make an array and put this result every time the serial port gives me a new result, for example:
[Code]...
Basically what i wanna do is let the port parse the messages, fill in the array with the result at an empty spot in this array and then i will have a separate thread that will look in into this array in each non empty space and after it looks into the non empty space it will use or discard the info and also mark this space as empty (after it checked)
I just read about DataSet in VB.NET, it uses disconnected concept. My question is: if my apps has "List All" button that query data from 1 table in the database, and that table has "very very very" many rows, so my DataSet will be filled with those data and eat up memory. Can I limit the data that being put to the DataSet from that query? But I want to be able to retrieve the next data from the same query if the user want to see it?
For example:
I have 1000 rows in my database, and i query all of them. But I just want 200 rows being inserted to my DataSet, but if the user want to see rows number 201 and so on, I want to be able to retrieve the next 200 rows, and so on. So it just like cutting those data into a group of 200 rows. Can I do this with the concept of "disconnected" of the DataSet?
i have three textbox in my program
How do i update my textbox3 Data like this
textbox3 line1 = textbox1 line1 + textbox2 line1
textbox3 line2 = textbox1 line2 + textbox2 line2
textbox3 line3 = textbox1 line3 + textbox2 line3
textbox3 line4 = textbox1 line4 + textbox2 line4
textbox3 line5 = textbox1 line5 + textbox2 line5
i have three textbox in my program. How do i update my textbox3 Data like this
Rich_textbox3 line1 = textbox1_line1 + textbox2_line1
Rich_textbox3 line2 = textbox1_line2 + textbox2_line1
Rich_textbox3 line3 = textbox1_line3 + textbox2_line1
Rich_textbox3 line4 = textbox1_line4 + textbox2_line1
Rich_textbox3 line5 = textbox1_line5 + textbox2_line1
it will continue to last line of textbox1
how can we compute tax using the values in the database.?
View 10 RepliesCurrently i am able to compute MI (Maintainability Index) at a VB Method and VB Function Level. I would like to know how this can be rolled up to the application level?
View 3 RepliesNeed to design a program that can encrypt and decrypt messages stored in simple text files using a private key stored in a separate file. Software should also be able to allow the users to enter simple messages that either displays the encrypted or decrypted message. The encryption method should use a simple substitution method. It should be set out in the following format:
Example (the "@" is the separator):
@
The character The Code End of line
A @ 4gh EOL
B @ 84!9 EOL
Has to use the 256 ASCII character codes. The separator will be used to separate the character and its corresponding code.Here are the pseudocodes I have come up with:
� Read any private key file
separator = readline(file);
while not EOF(file) do
tempStr = readline(file);
[code].....
How can I get the total value of a row(qty) in datagridview in visual basic 2008?
View 5 RepliesI have a Database named CarsType.accdb there are four fields in the data base Item_Name, Item_Num, Item_Qty, Item_Cost.
I am able to get the database to display my data in VisualBasic but I am not sure how to get the total cost to appear in my label (lblTotalCost). I prefer doing it in VB versus writing in my access program. All I am wanting to do it multiply item_qty * Item_Cost How would I go about doing that?[code]...