|
can you post the code snippet so i review it for some clue?
|
|
|
|
|
Well my app uses stored procedures to call up data, will be a lot of code
|
|
|
|
|
Hmmm.
i want to show only the code that how can you update the data from datagridview to database.Most probability is that you can not supply value of column 'QuoteId'( or all field for last record)
|
|
|
|
|
Hi Rupesh.
I seem to have sorted the problem. It seems as though a client had info missing in a completely seperate table.
Thanks again.
David
|
|
|
|
|
Hi,
I am pretty new at this programming stuff but I am using VB 2008 express to create a Terminal application that can save data received from serialport to a txt file. I have problems figuring out the right code to save it to text file. So far, I have gotten to the point of activating the datareceived handler but I am lost on how to get it to save to file. I have no idea how data received works as well. Could someone please enlighten me on how this works?
|
|
|
|
|
Quin Nee wrote: I have no idea how data received works as well. Could someone please enlighten me on how this works?
You write code that handles the DataReceived event where you check the BytesToRead property to see if there is any data that came in on the serial port. If there is, well, you read the data using the appropriate Read method of the SerialPort class.
Quin Nee wrote: but I am lost on how to get it to save to file
There's plenty of How-To examples for manipulating files here[^].
|
|
|
|
|
Dear Dave,
Thanks for the hints. I have the program up and running but it's still rough around the edges for my project. Is it possible to recognise the type of data cming in? For example, the device connected to the computer is a wireless node which receives transmissions from other wireless nodes. I want to read the data from each node and save it into different files like the MAC add of each node. Is it possible to do so in VB.NET. So far most of what I read about serial comms is just reading character or data. A colleague suggested using a look-up table to classify the data received. I'm not too sure how it works though. Btw, please take a look at my codes and inform me if there are any better methods of doing it.
Imports System.Text
Imports System.IO.Ports
Public Class Form1
Dim WithEvents serialPort As New IO.Ports.SerialPort
Dim mystringbuilder As New StringBuilder
Private Sub Form1_Load( _
ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles MyBase.Load
For i As Integer = 0 To _
My.Computer.Ports.SerialPortNames.Count - 1
ComboBox3.Items.Add( _
My.Computer.Ports.SerialPortNames(i))
Next
Button2.Enabled = False
End Sub
'-------------------------------------------
' Event handler for the Connect button
'-------------------------------------------
Private Sub Button1_Click( _
ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles Button1.Click
If serialPort.IsOpen Then
serialPort.Close()
End If
Try
With serialPort
.PortName = ComboBox3.Text()
.BaudRate = 9600
.Parity = IO.Ports.Parity.None
.DataBits = 8
.StopBits = IO.Ports.StopBits.One
End With
serialPort.Open()
TextBox2.Text = ComboBox3.Text & " connected."
Button1.Enabled = False
Button2.Enabled = True
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
'-------------------------------------------
' Event handler for the Disconnect button
'-------------------------------------------
Private Sub Button2_click( _
ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles Button2.Click
Try
serialPort.Close()
TextBox2.Text = serialPort.PortName & " disconnected."
Button1.Enabled = True
Button2.Enabled = False
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
'-------------------------------------------
' Event handler for the DataReceived
'-------------------------------------------
Private Sub Serialport_DataReceived(ByVal sender As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles serialPort.DataReceived
'This happens on another thread
mystringbuilder.Append(serialPort.ReadExisting())
Me.Invoke(New EventHandler(AddressOf UpdateControls))
End Sub
Private Sub UpdateControls(ByVal sender As Object, ByVal e As EventArgs)
'Do any UI code here on the main thread
My.Computer.FileSystem.WriteAllText("J:\Test\test.txt", mystringbuilder.ToString(), True)
End Sub
End Class
Most of it was copy and paste but I do get the general understanding of the program. I still feel that the data received section can be improved. I hope to hear from anyone soon about this.
|
|
|
|
|
Quin Nee wrote: Is it possible to recognise the type of data cming in?
Only if you write something to parse the data you've received.
Quin Nee wrote: I want to read the data from each node and save it into different files like the MAC add of each node.
This is only possible if the data you're getting contains that information. If not, there's no way to tell where it came from.
Quin Nee wrote: So far most of what I read about serial comms is just reading character or data
And that's all serial comm is, reading and writing character data.
Quin Nee wrote: Btw, please take a look at my codes and inform me if there are any better methods of doing it.
I can't tell you that because it depends on your requirements, situation, hardware, data your getting and if you want two way communication. What you have now just writes everything to a file, but doesn't have anything to parse the data you're getting nor handle cases where you haven't received enough data yet to parse a command.
|
|
|
|
|
Thanks for the quick reply,
Then how do I parse data? Btw, the data received through the serialport is expected to have MAC address and other information in the form of bits. I believe the data will be in integer forms. How do I change it from ASCII form to readable data?
|
|
|
|
|
Hi,
Looking for a bit of help. I have a program that draws a graph and plots some values. What I want to do is when I hover my mouse over one of the values, up pops a box which shows a bit more information. Is this possible or is there a control to do this?
Thanks for your help
|
|
|
|
|
how you draw a graph? whether it is on form or on panel on some other controls?
i post a article which describe how can you draw a chart using OWC11 .It facilitate you that whenever your mouse is over one of the values then it display related value. See Column Chart[^]
may above link help you
|
|
|
|
|
I draw the graph myself straight on a form. I need something like the way a tooltip box pops up
|
|
|
|
|
You'll have to track the mouse (MouseMove) over the control you're using to draw on. Take the coordinates of the mouse and map them to the points on your graph. Say the mouse is sitting at a point on your graph, or anywhere for that matter, like (20,60). What point did you draw at column 20?? Take that information and put it into a ToolTip window or your own small window. When the mouse moves again, recalculate and move the window.
|
|
|
|
|
Cheers mate,
Sounds like what I'll have to do. One question. Can I have a my own window without the menu bar stuff at the top, without the minimize/max and exit buttons and so on. Is there a way to hide all the stuff.
Thanks for your help
|
|
|
|
|
Sure. Checkout the FormBorderStyle property. You can even have a window with no border and title bar. If you want the title bar, look into the ControlBox property.
|
|
|
|
|
Hi I am looking for working code.
I want to add all the files based on extension should be added to the list box under a particular folder and the subfolders down the line. ( it is like there may be n number of subfolders and subfolders and subfolders)
modified on Tuesday, February 10, 2009 1:34 AM
|
|
|
|
|
|
Hi,
If i choose a windows application (exe) file then it will shows the reference file (dll) information like VS setup project
Thanks
KV
|
|
|
|
|
What are you talking about?? Are you trying to find which .DLL's the default Windows Forms Application is referencing?? That's easy. Start a new project, then double-click the "My Project" folder in the Solution Explorer and click on the References tab. They're all right there.
|
|
|
|
|
i want that reference (dll) information at runtime and not for current application
|
|
|
|
|
Ohhh...you didn't specifiy that in your question. References don't exist at runtime, so you can't get this list. But, there's is a close approximation.
You can find the CURRENTLY LOADED assemblies (kind of like your references) for an AppDomain by getting the list from AppDomain.CurrentDomain.GetAssemblies() . Something like:
Imports System.Reflection
.
.
.
Dim assemblies As Assembly() = AppDomain.CurrentDomain.GetAssemblies()
For Each a As Assembly In assemblies
Console.WriteLine(String.Format("Codebase: {0}", a.CodeBase))
Console.WriteLine(String.Format("FullName: {0}", a.FullName))
Next
Now, as you run your application, this list may change as execution moves from one assembly in your app to another.
|
|
|
|
|
Hi,
I currently have a background application who read barcodes from a serial port scanner, validate the barcode and send it to wathever application running in the foreground and then display it in the focused textbox. If barcode is wrong, a big red screen popup with an error message and the barcode is discard. This is working fine.
Now, I have to do the same, with a USB keyboard wedge scanner. Is there a way I can read the scanner input from the USB port, in vb.net ? Remember, my apps is in the background, barcodes have to be validate before displaying it in the main screen (which is an excel spreadsheet). Does anyone knows how to intercept keys input in vb?
thanks for your help
Dominic
|
|
|
|
|
Excel is a bit of a problem. You don't get any of the KeyPress, KeyDown events in an Excel worksheet. You can probably get them in a form in Excel though. I'm not sure since I don't do much Office Interop.
|
|
|
|
|
Is the scanner giving you any reads in other apps.. Notepad? If not you may need to ask the OEM if there is a set of default set up bar codes for your scanner and for use with USB in a VB environment. If it is reading to other apps I have seen problems upgrading from one OEM to another my self and have had to go back to the OEM for updated default set up bar codes as some time the published set may not work… We had just started to see USB keyboard wedge scanners before I left NCR as a tech lead in the field, and that was almost a year ago but that is how it was then…
|
|
|
|
|
The scanner reads good, problem is, my application have to intercept the barcode for analyse before sending it to the Excel sheet. My application runs in the background (on the system tray). When using serial port barcode scanner, there is no problem at all, I just have to open the serial port, get the barcode, analyse it and send it to the main program's focused textbox. That way, it works fine. Problem is with a keyboard wedge scanner. How can I program my background application to read the keyboard entries (and analyse it) before sending it to Excel??!
|
|
|
|