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].....
My site has descriptions of the products we sell and I am currently trying to get those descriptions to pop up inside a modal popupextender. I can get them to popup with a textbox where I have enabled="false" so that it can't be edited, but it shows all the tags along with the text such as the <p>, <li>, etc. Is there a different control I can use inside of my modal that will show my text better?
<!-- Descriptions -->
<asp:TabPanel ID="tab2" runat="server" HeaderText="Des[code].........
If you are currently trading options on futures or are interested in exploring them further, check out this newly updated trading guide, featuring 25 commonly used options strategies, including butterflies, straddles, strangles, backspreads and conversions. Each strategy includes an illustration demonstrating the effect of time decay on the total option premium involved in the position.</p><p>Options on futures rank among the most versatile risk management tools, and are offered on most CME Group products. Whether you trade options for purposes of hedging or speculating, you can limit your risk to the amount you paid up-front for the option while maintaining your exposure to beneficial price movements.</p>
I've been ttrying to code an app that will act like the VB intellisense, without the added properties. In short, when I type (in a multiline RichTextBox), the letter t I would like the populated listbox show at that point (because "Then" is a word in the listbox) and if I click "Then" in the listbox have it "autocomplete" the word and display it in the color blue.
lstKeyWords.Location = rtb1.GetPositionFromCharIndex(rtb1.Selectionstart + 10)
lstKeyWords is the ListBox and rtb1 is the RichTextBox - This was the only way I could get the ListBox to show in the "almost" correct position?
i am trying to read a log file which has 2000 lines. Input array is my temp array. while debugging i can see the input array values are populated until input array(9,40) after that the array is populated full of question marks. I don know why it is happening [Code]
View 1 RepliesHere is some sample code:
Dim arrValue(3) as Integer
arrValue(0) = 5
arrValue(1) = 4
[code].....
I have a dynamic array that holds my results. I want this result to display on a form as an equation.The results from my array are numerical numbers and I want them to be multiplied to column headers of my datagridview.Column header for my datagridview are X1, X2, X3, X1^2, X2^2, X3^2, X1X2,X1X3,X2X3.My array is of the size 9.The values in my array could be , 23, -7.19, -26, -78, 32.5, .89, 21, -2.3, 4.5, 6.7..I am just making my results display on a msgbox one by one but I cannot get all of them once.
View 1 RepliesHow do I simply display the integer values of a 10x13 integer array
View 1 Repliesi 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 RepliesI'm working on my code about cpu scheduling and I encountered a problem in putting the values inputted of the user from the textbox to an array, when I try to retrieve the value from the array I always get '0' and I don't
Public Class Form3
'Public txtIN As TextBox
Dim lbl As Label
[code].....
(The following code cant work , it just wont update.. my bar default max is 80 and its still shooting over 80, its not dividing)
Sub displayprogress(ByVal amount As Integer, ByVal progress As ProgressBar)
progress.Value = 0
For i As Integer = 1 To amount
[code]....
i did try replace the question with SQLLquestion(0) but the result given was 0 and not the question from database i tried calling function sqlquestion() from one of the form but it just cant work i think tis wrong...
im 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]...
After I store the values into the array via the addButton I need to display each value and the total of all the values into a TextBox via the createButton Here is an image of how the application is supposed to look: [URL]
Public Class MainForm
Private Sub exitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles exitButton.Click
[Code]......
I have created a textbox array based on the number of 'Channels' on another form. This number dictates how many textboxes (and other controls) to add to my new form.
I expect the user to type in their 'type' of channel into each textbox.
The thing I am having problems with is once the user types in the information, how do I access the data and store it for a future form?
Here is my code (once again excuse my programming skills):
Public Class Fixture1Setting
Dim labels As New List(Of Label)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[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 question on a datagrid object in vb.net 2008, that I what to be populated with certain values of a parameter from mssql database. The connection is made, the column header are loaded, but I what, when the form is loaded, to populate the datagrid only with certain values, doing a select commnad where id has a value given by me.What is the command to have this select done and display the values in the datagrid?
View 3 RepliesI am really hissed off with this control. Does anyone know how I use this control for currency values. I want to set the text to say 1.15 meaning 1 pound 15 pence and the mask control to show 1.15. If I enter 1.1 I want it to format to 2 decimal places 1.10.
View 1 Repliesi have record of 30 employees....and what i am doing is when the form loads i want to assign the textbox the value from the database....can i do it thru an arrary
eg i want to do something like this
For i = 0 To 29
fname[i].text = name[i]
how to i assign the name (fname[0]) in design window......is there an alternate way of doing this ?
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 RepliesIn a public module (codefile) I defined a data structure called db_connection,then declared a variable of that type like so: Public db_con as db_connection I pass db_con to a sub. I expected the db_con structure to be populated with values after the call to the sub. It does not.This is something I have done for years in vb6.What might have changed to prevent this from working?
View 2 RepliesI have a project to work with an existing Access 2007 DB table using Access Currency data type fields. I've tried many, many, many variations on what I'm doing, including using a command parameter or using this scheme and trying dOLEc in my command string (as shown below).
Dim dOLEc As Long = Decimal.ToOACurrency(dQ)
It all works fine (db connects, inserts record OK, closes connection) until I introduce any currency variable (WMoney is my example below). Then it returns Syntax Err 5 in INSERT INTO statement. Current VB string for the execute non-query command is:
Dim sdbcommandString As String
Dim dQ As Decimal = 8950.13
'control test--no currency field--works perfectly every time
sdbcommandString = "INSERT INTO Workers (WFullname,WRay)VALUES('George D. Jones','abcdefg');"
'but add the currency data type to it and it bombs
sdbcommandString = "INSERT INTO Workers (WFullname,WRay,WMoney)VALUES('George D. ZZZZZ','abcdefg'," & dQ & ");"
As I said, though perhaps not too clearly, I've also tried variations on this theme:
sdbcommandString = "INSERT INTO Workers (WFullname,WRay,WMoney)VALUES('George D. ZZZZZ','abcdefg'," & dOLEc & ");"
In all cases, I use the same code to connect to my db and use
OLEdbConnection1.ConnectionString = sDBConnString
OLEdbConnection1.Open()
OLEcommand = New OleDbCommand(sdbcommandString, OLEdbConnection1)
OLEcommand.ExecuteNonQuery()
And I've tried it using variations on this theme where :
sdbcommandString = "INSERT INTO Workers (WFullname,WRay,WMoney)VALUES('George D. ZZZZZ','abcdefg',?);"
OLEdbConnection1.ConnectionString = sDBConnString
OLEdbConnection1.Open()
[code]....
I need to use to make it work with a currency field?
I am trying to do a form it has 2 comboboxes and I have the arrays set up one of the combboxes is for pizza size and it has 4 selections and the other combobox is for crust style it has 2 selections. The user has to pick on of each and it pills the price from the array and then displays the price in a text box. I for the life of me can't figure out how to get it to pull the info from the array and then display it in the text box, it either displays nothing in the text box or a 0 or 1.
View 1 Replieswhen i get the money field from sql server to vb.net code, i always get 1.0000 instead of 1.00. how do i convert this to 1.00 in vb.net?
TD = New HtmlTableCell
If Not SqlDR("Price") Is DBNull.Value Then
TD.InnerHtml = SqlDR("Price")
Else
TD.InnerHtml = "0.00"
End If
i have a Checkedlistbox in a windows form, and have defined 5 values in it.Also the form holds a datagrid in it. i have manually defined 2 columns in it.Now i would like to populate datagrid with some data according to the check list values selection. When any selection was done in the checkedlistbox, some data need to added to the gird.in case if i am ticking further selection, i need the datagrid to be inserted with additional values with the prior populated data.
being a beginner, i am not able to get any idea to get this worked.
I have a checked listbox that I've populated with a table that has three columns, Name, Address, Phone - and have done so successfully, but when i display the items in the listbox, i would like to retrieve additional values of the checked items other than the primary displayitem.[code]'we now have an array full of the Name column only, from our checked items 'i'd like to grab the other two as well (not to display in the listbox, but to use elsewhere as variables) 'and keep the checked listbox as a control in the above code, the fill_array variable is only populated with the items displayed in the checkedlistbox - my question is, can i keep the display item the same and pull the other two columns from the datasource, but only for the ones that make the checkeditems list?
View 5 RepliesI have set up a search form so that when the user enters a character, a search occurs. I have some code behind to do the search. The code I am using is as follows:
Javascript:
<script type="text/javascript">
function TextBox_OnKeypress() {
document.getElementById("ctl00_MainForm_ibtnSearch").click();
[Code]......
What is the most appropriate data type for storing currency values in VB.NET?
View 1 Replies