I have in Sql a money filed named value, and the data looks like this: 234.0000 .
I use this data trough a vb application, and so I store it in a double variable named dfValue, but I only get 234.0, even if I use: select round(value,2,1) and then Format (dfValue,"#.00").
I usually have a check to see if a certain database column is DBNull and if it is convert it. Current with a datatype of money in SQL 2008 with the row column containing
Null, i declare the equivalent value as Decimal (in .Net) then get the error "'DBNull' to type 'Decimal' is not valid".... How could i check this column for null and convert it?
i have problem multiplying total minutes of user login with price. for example, my price for 10 minutes is 100. if user A start login at 9.00 am and logout at 10.00 am, that means he spends 60 minutes using the computer. how to multiply 60 minutes with 100 (my price) so that i could get the correct price and update the data to my database?
[Code]...
How can input number to database where my field in database data type money.[code]...
View 5 RepliesI am linking to an SQL table with 'Money' field. When i try to update this field in VB.NET I get an error message that "Can not convert a character value to money. The char value has incorrect syntax".
[Code]...
For each column in data table i want to add parameter with same data type as column data type. But looks it's not that simple.
Dim cmd As New SqlCommand
Dim dType As New System.Data.SqlDbType
For Each cl As DataColumn In DataTable1.Columns
[CODE]...
How can I do this?
I need to create a function which have either 1 parameter with a string as data type or 2 parameters with double as data type.Something like the substring method.
View 2 RepliesI'v designed a ms access database table with one field having Datetime datatype. I can Insert data into it from vb.net front end by trns_dt DateTime.Now.DateBut when I fetch records from the tableand assign the dataset datasource as da, it shows datatype mismatch error.
daleDbDataAdapter("SelectDaily_Transactiondtp_from_dt.value dtp_To.value con)
dsDataSet
[code].....
I have a program that calculates commission, but if the commission is nothing then I do not want it to show a zero commission. I want a message box to show a message that there is no commission earned.
View 1 RepliesMy colleague gave me a DLL that manage all database business. I wanted to invoke a function that uses Stored Procedure and return the search result. In the function receive a parameter type in ystem.Data.IDataParameter[]. Below is my codes.
[Code]...
I have a function (on vb.net) to get a data from a XMLWebService:
[Code]...
I added this lines in the form load of DataGridPrinter by Merrion in the codebank..[code]Unable to cast object of type 'System.Data.DataViewManager' to type 'System.Data.DataTable'.
View 2 Repliesevery time i run this code i get the same error
Unable to cast object of type 'System.Data.DataTable' to type 'System.Data.DataView'.
the code is
Dim plmExcelCon As New System.Data.OleDb.OleDbConnection
Dim cmdLoadExcel As System.Data.OleDb.OleDbDataAdapter
Dim PrmPathExcelFile As String
[Code]......
[code] "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.The statement has been terminated." [code]
View 6 RepliesI have one question. i have seen some codes like:
Req = CType(System.Net.HttpWebRequest.Create("url"), Net.HttpWebRequest)
Is it really necessary to cast the same type, or is there a difference when its not casted.
I have a number of controls (Device1, Device2, etc.) that all inherit from BaseDeviceControl. In the DragEnter event handler I am trying to test for the correct type by using the BaseDevvceControl like this....
[Code]....
I am pulling data from a local MSSQL database using a stored procedure, then send the data to a web service. Every part of the component works well except for a pesky problem will a DBNull being returned from the DataRow field, when I know that the field is not null and has valid data. The database and associated INSERT statements that add to this field are designed to not allow NULL entries. When I debug break the program on or right before the line that throws the error I see that the field has valid data for the current row.If I add a null check to the code (as below) the operation continues as normal:
Dim dataResultsTable = Me.myViewTableAdapter.GetData(int)
For Each myDataRow In dataResultsTable.Rows
If worker.CancellationPending Then
[code]....
Why is the read operation returning DBNull instead of the data in the database?
EDIT: Just to be clear, the operation does return the proper data, but the data is not being saved into the variable.
<ItemsControl DockPanel.Dock="Top" ItemsSource="{Binding Path={x:Static vmc:clsPersonViewModel.ChildrenPath}, Mode=OneWay}">
<ItemsControl.ItemTemplate>
[Code].....
In the code above, if there are no children (the ChildrenPath property returns NULL), nothing is rendered in the view. In the code below, when ChildrenDataSetPath is NULL the XamDataGrid still gets rendered. How do I achieve the same for a single object (as opposed to a collection) as the datacontext?
<DataTemplate DataType="{x:Type vmb:clsPersonViewModel}">
<igDP:XamDataGrid DataSource="{Binding Path={x:Static vmb:clsPersonViewModel.ChildrenDataSetPath}}">
[Code].....
I'm making a program with a few text boxes that are for cents, nickels, dimes, quarters, dollars and I want them to all add up which works but when you leave one text box blank you get an error. This is my code:
Dim Cents As Double
Cents = tbCents.Text * 0.01
Dim Nickels As Double
Nickels = tbDimes.Text * 0.05
[code]....
I have had a lot of trouble trying to distribute my programs for money. The way they are set up, you type in one product key, and it is activated. Now you can do this for any amount of installations or computers. What I would like to be able to do is have it so they can only use a product key 5 times. For example, you would host a text file on a server like this:
" XOTS3-G4SIT-HJ58GS-HMG52J, 1, 5" where the random characters are the product key, 1 is the amount of times it has been used, and 5 is the maximum limit. Something tells me that this is going to tie in with ASP.NET somehow, which I have no experience in, so if we could stay away from that it would be great. Also, I am having lots of trouble hosting a website from my house, so if there is a way to host it on another server like ripway.com that would be good too. I know I am supposed to post a source, but I really just want to know how to read and write to a text file on another computer using vb.net. I could figure out the rest.
how can i breakdown the amount of money into available denominations. for example, i will input 7,542, the program will output how many thousands, hundreds and 1 coins are in the amount. im thinking the trimming functions of VB but no idea how to start.
View 9 RepliesI have a textbox and a label, on the label it shows the current price and it in the text box im allowing the user to enter a price aslong as its higher then the current price,once they have entered there relevant bid and clicked the button "Bid" i wont to automatically show them the new bid and show a relevant message saying "Congratulations your the highest bidder" or something along them lines...
Can some one point me or tell what i should use to calculate the current bid value and the value they enter add them together and show the new amount?Just for additional information they can bid as little as 1p as long as it increases the current value....
I am creating a roulette wheel using microsoft excel visual basic. I want to create a table with the amount of money you have that goes up or down based on wheter you win/lose. This is what I have so far:
Public Sub spin()
Dim speed As Double
Dim spin As Double
Dim maxspeed As Double
[Code]...
I'm trying to convert a mathematical result of money format example:
Dim num1 As Integer = 2000
Dim num2 As Integer = 500
msgbox(cDbl(num1 + num2))
It only returns 2500, which I need to return my 2,500.00?
I want to format the contents of my textbox while typing.I know that I can do this in LostFocus event, but I want it to be done while I am typing. Does anyone have any suggestions on how to implement this?
View 1 RepliesI'm trying to insert data into a table but I get the error "Cannot convert char value to money. The char value has incorrect syntax". Here is my
[Code]...
I have an InvalidCastException Error in my program. The program is that i try to insert an employee record into a database table after getting the details from a form. I've used Money data type is SQL Server for salary and SqlTypes.SqlDecimal data type in employee template class. i've used a stored procedure to pass the values and i add the basic value by passing a parameter by the method
Dim prm8 As SqlParameter = com.Parameters.Add("@basic", SqlDbType.Money)
prm8.Direction = ParameterDirection.Input
prm8.Value = emp.Bsc
I've used the money datatype itself even in the stored procedure variable.I get the following error.
failed to convert parameter value from sql decimal to decimal
Even if i use
prm8.Value = Convert.ToDecimal(emp.Bsc)
I get an error Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible'.
I am getting this error when I am tring to load string type to data table)
Using connection As New SqlConnection("connectionstring;")
connection.Open()
Using Command As New SqlCommand("SELECT ClientId,forename,surname from t_clientdetails
[code].....
I get the below error Unable to cast object of type 'System.String' to type 'System.Data.DataTable'.This is the code I'm using
Dim str As String = String.Empty
If (Session("Brief") IsNot Nothing) Then
Dim dt As DataTable = Session("Brief")
If (dt.Rows.Count > 0) Then
[code]....
i am supposed to calculate change. well this works fine but i need to know how to make it show how to breakdown the money in dollars quarters nickels dimes and pennies. [Code]
View 5 Replies