I have a bunch of serial time values, like these:
0,475694444444444
0,463888888888889
0,54375
0,584027777777777
Is there a function in vb.NET that can convert these values to hh:mm:ss, or something more readable than those values?
I have a Excel sheet which containes time. 2 cells are being compared in a formula. Sometimes a value is missing in one of the cells, this will cause a negative date. Negative dates in Excel is shown as ####. how i can set this value to zero? Ex: Value A is compared with value B. If value b is missing, theres a negative time.
20:05:20..space..20:31:5300:26:33
20:43:43 ..space..empty cell..####
how to export textbox values to excel.
View 1 RepliesI'm trying to build an application wich shows some info about a specific user. The info is stored in an Excell sheet.
What I want to do is this: I'll have the user fill a field with in example the logon name. Now I want the application to search the Excell sheet for that record and list the info into seperate fields on my form.
I made my program and now I just need to add in the serial and trial part of the application. I know the application must connect to the host and go to a txtfile. How would i do the trial and serial. Also If the serial is already activated I want the application to reject that Serial and Count how many times they entered in a wrong serial.
View 2 RepliesI need to import data from Excel into a MySQL 5 database. The format of the column in excel is set to "Time". the field value looks something like this:
17:20:00 If I do this in my vb.net
strTimeIn1 = Trim(jobdt.Rows(j).Item(7).ToString)
I get this in my Immediate window when debugging:
"12/30/1899 4:10:00 PM"
what's the correct way to convert that string to a time value so I can insert into a datetime field in my database with no issues.
I have a database table that stores a datetime value.I want to display that value on my asp.net textboxes, except I need to show date value in TextBox A and Time in TextBox B.How can I split those values in VB.NET?
View 2 Repliesi'm using visual basic 2008 express edition and having a problem in saving the data i've added in datagrid to excel. i use inputbox to add data into the datagrid. when i click the save button, the data from the datagrid must be save to excel. this is the code i get from some forum and i already edited it but it only saves the last data/row i inputted.
[Code]...
The idea with this form is to add the futures which is calculated when the button is pushed but I need the list to update every time and show the values each time to which the previous value is added to the new calculation, e.g. of what it should look like in listbox:
Year 1: $1,290.93
Year 2: $2,724.32
Year 3: $4,350.76
etc....
I have been working on this a while and I am at a standstill, I was given a function to clear the form everytime it calculates but I don't know how to implement it, I am new to VB. Here is what I have so far:
Public Class frmFutureValue
Private Sub btnCalculate_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnCalculate.Click
[code]....
I used .NET Framework 1.1 in C/S project before. Now I have updated the project to use .NET Framework 3.5 without modifying source code, but I have found that : the Remoted DateTime values can not be converted to the equivalent local time of a remote computer that is in a different time zone. In .NET Framework 1.1, the DateTime values can be converted automatically.
[Code]...
I have a program written in Visual Studio to me 3 values ( 0-255, 0-255, 0-255) to send the serial interfaces, and While assigned to the 3 values of 3 sliders together.[code...]
View 1 RepliesI am creating a maths programs that draws graphs for the user. so far i have placed 22 values into an array and now i need to import them to excel, draw the graph and import the graph back into the program to display them.[code]...
View 4 RepliesHow can i add serial key at the time of installation when i install vb.net 2005 setup on any system like windows to proceeed installation you must enter the related serial key.
View 4 RepliesI am still new in programming. I am an electrical engineer. I have to read the time from GPS from one serial port apend this time to a data got from other device serially.
View 1 RepliesI'm writing a simple program to retrieve data via the Serial Port. I have a piece of hardware that returns its 14 byte status every time vbCr is written to it. The program works fine except after a few hundred requests the program begins to hang, off and on. Some times for a second some times for longer. I need to update every 25 milliseconds so the hanging sets in quickly. This faster the interval the quicker the problem sets in but no mater how long the interval the problem eventually starts.[code]...
View 8 RepliesI want to send hex values across the serial port. I know, I know, your thinking not this again. But what I need to do does not seem to be addressed, or I am some how missing it when I search around.
[Code]...
I'm having a bit of an issue receiving a stream of serial data and displaying the data real-time in my GUI. I am fairly new to VB.Here's what I'm trying to achieve: I have an I2C device (bank of LED's) connected to my Arduino. Using the VB.NET (2010) GUI I request which LED I want on (via buttons) and the I2C device then sends a reply confirming which LED actually turned on (basic feedback). Ok, sounds great right? Here's where I get issues. Well when I try to read the serial data sent to VB and display the real-time stream on the GUI, a) I get a bit of a mess as an output (values are ok, just spewn across GUI) and b) when I select a new LED to turn on, the GUI data does not refresh to this change. The stream being sent from the Arduino is ok, I looked at the data in a serial monitor.
[Code]...
connected to my Arduino. Using the VB.NET (2010) GUI I request which LED I want on (via buttons) and the I2C device then sends a reply confirming which LED actually turned on (basic feedback). Ok, sounds great right? Here's where I get issues. Well when I try to read the serial data sent to VB and display the real-time stream on the GUI, a) I get a bit of a mess as an output (values are ok, just spewn across GUI) and b) when I select a new LED to turn on, the GUI data does not refresh to this change. The stream being sent from the Arduino is ok, I looked at the data in a serial monitor.
Public Class Form1
Dim ticktock As Integer
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[code].....
I have writen a piece of software which takes values from a serial port, peforms some calculations and then records the result in an Excel file.It also uses some values stored in an excel file for reference.
The program will run fine for days/weeks until the PC is rebooted mid run.Once it gets rebooted mid run I ge the error "RPC_E_DISCONNECTED"This then occurs everytime the program is run.Full error file below.I'd like to code for this error of course but even a simple fix to stop it happen once the PC has been rebooted to allow it to run again would do. I can give more details but I'm not sure where to start.Target system is windows XP SP3 with office 2007
[Code]...
When I look at a file on my hard disk, e.g. test.csv, when I look at the Properties of the file, it is officially known as, "Microsoft Office Excel Comma Separated Values File", and file types of .pdf are listed as "Adobe Acrobat Document", etc. etc. All of this information can be seen in Windows Explorer too when my folders are displayed by Details. How do you get at this "type of file" information with .NET?
View 2 RepliesI created a button instead of the print button in crystal report because i need to record the report printed report serial number, date and time to the database. when i click on the button, dialog box appear. if i click on the ok button , system record the printed report details to the database and report printed successfully. but when i click on the cancel button , system again recording the printed report record.
[Code]...
I 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 am trying to write a small program so I can log times of the jobs I do throughout the day. I have figured out getting the time values and getting the time differences between travel start and travel finish. The problem is i need to add together two sets of travel times to get a total travel figure for the day. I am struggling with the adding of two time values in textboxes.
View 6 RepliesLet's say I have the this statment If textbox1.text <> textbox2.text Then
Now I want the msgbox to show me both values at the same time. I know if I want it to show me the value of one of the textbox i just have to use & val(textbox1 or 2.text) &. How do I make it show me both of them at the same time.
I am trying to sum two values of textboxes which are already in time format
Text1.text = 07:00
Text2.text = 08:00
How to sum them and display in another textbox Total.text = 15:00
I'm trying to import my xls files to sql server, but i saw some values become null even though data in excel values are exist.
below is my connection string :
Code:
Dim cnstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & txtfName.Text & ";" & _
"Extended Properties =""Excel 8.0;HDR=YES;IMEX=1"""[code].....
This error occurs while i'm importing the alphanumeric values into text, but previous values are numeric (but string datatyped).
I'm trying to export a set of values to excel. The data is being taken through a DAQ card and is displayed in two textboxes on the form. So far I can export 1 data point to A1 and B1 of the spreadsheet. here is what I have so far.
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
Dim acquiredData() As Double = DaqTaskComponent1.Read
[Code].....
If a use the NPV() function in Excel (2010) with a discount rate of 5% and 10 cells that each contain 505,000 the resulting NPV function call "=NPV(5%,C2:C11)" returns the value of 3,899,496.
If I use the Financial.NPV() method in the Microsoft.VisualBasic namespace (in my C# application) and pass in a discount rate of 5% (as a double) and an array of 10 doubles with a value of 505,000 each, the VB function returns the much lower value of 100,999.99 (plus a few more decimals).
I have a stand alone VB.Net 2005 application that uses a serial port that generally stays open while the application runs on a Windows XP system. In trying to bullet-proof the UI, I ran into a problem when the USB to Serial Converter normally used to provide the serial port is disconnected while the serial port is open. In trying to handle the resulting error when accessing the port, I find I cannot close the port.
When trying to do so, the error message says something like "unable to close the port. You may not have sufficient permissions." Reconnecting the USB/Serial Converter does not reactivate the port.
[Code]...
I have a problem about read in excel to textbox in VB,I want show time (format hh:mm:ss) of "A1"(is 16:50:20) in excel to textbox in VB but I get "10.720 " in text box
View 9 Replies