|
Shrimpersfan wrote: The error message within the application says 'Cannot insert NULL value into column 'QuoteID', column does not insert NULL's. Insert failed.
from above message, it is clear that column 'QuoteID' does not allow null value. whether you debug your code for record which have null value for column 'QuoteID'. Check for the last row of datagridview which may be contain null value for column 'QuoteID' (or for all fields)
|
|
|
|
|
Hi Rupesh.
I have looked at the databases and looked for any NULL's in QuoteID but none appear. In my datagrid view, there is a white space below the last field (space to enter another record) but i shouldn't think the app will be trying to import a record from this.
It's also strange how the import works with a smaller dataset but not with a large one.
I have commandtimeout's in my code too.
David
|
|
|
|
|
Shrimpersfan wrote: I have commandtimeout's in my code too.
whether you try to increase CommandTimeOut?
|
|
|
|
|
Yes i tried different intervals, in the end i used 0 so the app should never time out.
David
|
|
|
|
|
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.
|
|
|
|