I have an access database that is populating a txtbox field on my form..How do I get those results to be currency?do I add code to the form? or do I add code to the function of the tbl? [code]I dont know which side to code or what to code to get the results to be formated as curency
View 17 RepliesI am trying to create a currency converter that will convert currency. I have a text box to enter the amount and 2 combo boxes to choose which currency you are converting from and to.
I am using a webservice site XML that contains the conversions.
The problem is I cannot get the display to work properly.
I am trying to update one table with results from another table as such:
Table A (field, type) : Table B
ID (key) Integer : ID (key) Integer
ParentID Integer : IssueID Integer
Number String : ParentID Integer
: Number String
I need to construct and UPDATE statement that does:
Sets B.IssueID = A.ID When B.ParentID = A.ParentID AND B.Number = A.Number AND B.IssueID = 0
Here is what I have so far but it is producing an SQL syntax error (missing operator)
sqlStr = "UPDATE B SET IssueID = A.id FROM B JOIN A ON (B.ParentID = A.ParentID AND B.Number = A.Number) WHERE B.IssueID = 0
I have also tried
sqlStr = "UPDATE B SET IssueID = A.id FROM B, A WHERE (B.ParentID = A.ParentID AND B.Number = A.Number AND B.IssueID = 0)
So hopefully this is a quick fix but for the life of me I can't figure out how to get my results from a OracleDataReader record set.Just trying to get all the users for a specific TNS into an array. I was able to do this easily before with ADODB, but thought I would try using ODP.net.Here is what I have so far and it definitely gets all the USERs for a given TNS. its when I get to the READ() part where the syntax is ??
View 1 RepliesI'm trying to populate it with the results from a table in a dataset, something like Dim MyStringArray() as string = {Me.MyDataset.MyUsers.Rows.Tostring}. So I would end up with, StringArray() = {"Bob", "Jane", "Sally"}. I know I'm missing something very simple but I'm just not getting it.
View 5 RepliesI'm working on a form that has a few data grid views that are populated from LINQ queries, no problem there it works as it should however that sorting does not work. After doing some reading its because LINQ results do not support sorting.As I have the LINQ results already is there a way of copying the results into a dataset or datatable then binding the data grid view to that so sorting will work?
View 4 RepliesI 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 have a stored procedure, and I want to save the results of the stored procedure into a table. Is there a way I can do this with a simple query without creating the table beforehand.
View 8 RepliesWhen subtracting two doubles the result appears to be correct but when I save said results in a SQL Server table they are incorrect. I know their are problems with decimal values in the binary world but isn't there a work around for this?For example 421.2 - 418.9 = 2.3, but the result stored in the SQL Server table is 2.29!In the VB code I used Math.Round to round to two digits and the values appear correct during debugging but, as I've said, in the end they are off by .01. [code] decimal(10,2)BTW, I've tried numerous methods of getting the correct value but have not met with any success. I've used Math.Round on Val1 and Val2 separately, after the subtraction, and on the ResultVal. I've also converted the ResultVal to a string using Format(ResultVal, "#####.00") and then back to a number but still the value that ends up in the SQL Server table is wrong.
View 5 RepliesI would like to know how I would separate the $ from number. I am reading data from a text file. the last column has a contain $12.00. I am able to split the five columns into an array. But also want to be able to remove the dollar sign.
i.e.
John Kay Lame Welder $20.00
I have a very specifically designed table in a .aspx page. I have an <asp:SqlDataSource> tag that works fine with a DetailsView. I have tried DetailsView, ListView, Gridview etc. and cannot obtain the desired design. Is it possible to execute a Stored Procedure and have the individual results displayed in the individual cells of a web page table? This seems like it should be simple but it apparently is not.
View 2 RepliesI have a table of student information. Each student has a contact date and a source of information.
I want to produce the results like this
CODE:
At the moment I am using this sql
CODE:
But my results are like this
CODE:
It is just putting the total not the seperate amounts.
This is what I am to create: [URL]I am having trouble coding the String for the amounts in the listbox since VB doesn't allow the dollar sign "$".
View 2 RepliesI'm new to this forum so I hope I'm posting in the right spot.
By entering a dollar amount and interest rate. I'm trying to figure out how I would evaluate when the dollar amount has been doubled. I already have a do while loop to determine when the dollar amount reaches a million, which works fine.
what is the meaning of the dollar sign after a method name in vb.net
like this:
Replace$("EG000000", "0", "")
Suppose I have a table with columns userdef1, userdef2 userdef6 and I have another table that defines these fields. i.e UserDef1 = "MyName" etc
What would be the best approach for retrieving these values and updating the column headers?
I'm just starting to learn VB and I can't seem to get the label to display 4 separate lines that I wanted it to. It always seems to display Grand Total: (number)[code]...
View 7 RepliesI'm having some difficulty formatting some of my strings, I can't see what's wrong unfortunately. I have various numbers, e.g. 100.023, 13488.323, etc in a datagridview column that I would like to be formatted so it looks like this: $123,456
Here's what I've tried so far (that isn't working):
row.Cells(1).Value = Format(row.Cells(1).Value, "{0:D0}") 'I've also tried using {0:C0}
row.Cells(1).Value = row.Cells(1).Value.ToString("$#,#")
'This one (above) comes up with an error saying it can't put an "##" in an Integer column, something like that anyway.
I'm trying to get the Subtotal, Sales Tax, and Total to be displayed in currency form, (i.e.: $0.00). The form:
Private Sub CalculateButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CalculateButton.Click
Dim PartsCharges As Decimal
Dim LaborHours As Decimal
[Code] .....
Is there some easy line of code I can do to format it? I know how to do it the .ToString("C") way, but that doesn't work in my case, because they are text boxes and don't have any declared variables for the numbers that are inputted inside of them.
I want to (SQL) select from a table in an Oracle database, and show the results of the query in the VB application, in a Excel like manner (rows, columns, selectable, etc.). Or in a SQL developer manner. How can I do that? Browsed through a lot of tutorials and howtos on the internet, did not get anywhere. I think (and correct me if I am wrong) that it's gotta be something with DataGridView. But I don't know how to create and populate a datatable with the result of as Select statement, how to create a dataset.
View 3 RepliesI need to write a program that uses constants to establish the base pay, the quota, and the commission rate. The Pay menu item calculates and displays the commission and the total pay for that person. However, if there is no commission, do not display the commission amount (do not display a zero-commission amount).Write a function procedure to calculate the commission. The function must compare sales to the quota. when the sales are equal to or greater than the quota, calculate the commission by multiplying sales by the commission rate. Format the dollar amounts to two decimal places; do not display a dollar sign.The summary menu item displays a message box that holds total sales,total commission,and total pay for all salesperson. Display the number with two decimal places and dollar signs. the Clear menu item clears the name, sales, and pay for the current employee and then resets the focus.The Color and Font menu items should change the color and font of the information displayed in the total pay text box.Use a message box to display the program name and your name as programmer for the about option on the Help menu.
[code]...
So the issue is when I push the pay/calculate button everything is calculating correctly the first time, but then when I push clear to input another workers name and weekly sales and push calculate, my label is blank and does not display any info about the second worker. Then when I push summary after inputting the second worker, it's only displaying the total calculations of the first worker. I can't seem to figure out this problem on my own (After countless hours staring at my code I might add!), so I am hoping somebody can pinpoint what I have done wrong? EVerything else is seeming to work just fine.[code]...
Using VB.NET 2010 I don't know, how I can format a decimal as wanted...
Example:
Value = 1 / Wanted Format = 0100
Value = 2,5 / Wanted Format = 0250
Value = 24,25 / Wanted Format = 2425
vb
DateAdd(DateInterval.Year, 1, CDate(Form1.DataGridView1.CurrentRow.Cells(1).Value).Date.ToString("yyyy/MM/dd")))
[code].....
I have a richtetbox and i have it so that the user can change the font and the font color, does anyone know how i could get it to print with the formatting (font, size, color)?
View 4 RepliesI don't know how to format a timestamp in VB so it gets inserted into the MYSQL database in this format:
[Code]...
Date.Now.ToString return a string like "6/24/2010 3:31:27 PM". I only want the year to be 2 digits, like "6/24/10 3:31:27 PM". What's the best way to do this?
View 4 Replies2 Listboxes gives values to listbox3 like "listbox1item:listbox2item"When I export it to txt file and open in notepad, it shows listbox1item:listbox2item listbox1item:listbox2item listbox1item:listbox2item but when I open same file on wordpad and other text editors it shows like
[Code]...
I am using the DateTimePicker control in a Vb.Net Windows project.I would like the date to reflect the Regional Settings on the user's computer, but also to show the month name, rather than the month number.For example, if my computer is set to English(US), I would like to see Nov 26 2009, and if my computer is set to English (NZ), I would like to see 26 Nov 2009Is this possible?
View 1 RepliesI have a datagridview and need to do some formatting to it. On load the row 0 column 0 cell is highlighted. I need users to click on datagridview to select a value. The issue is with the initial load highlight it looks like the first row is already selected when in fact it is now. How can this highlight be disabled? Each row of has 7 cell, the user is able to select any of the cell of a row and the corresponding row ID is selected. The issue is that only that one cell is highlighted.
I would like the entire row highlighted regardless of what cell in that row is clicked on. One of the columns is a status value. I would like to color the text based on the value. For example if the Status is opened I want the text to be red, if the status is closed the text color should be default.
I am working in VB.Net and trying to use Regex.Replace to format a string I am using to query Sql. What Im going for is to cut out comments "--". I've found that in most cases the below works for what I need.
string = Regex.Replace(command, "--.*
", "")
and
[code].....