Handle ErrorEventhandler With A Thread To Update A SQL Table?
Feb 5, 2011
I have an application which runs two threads.
- One thread is the main thread while the other one is to monitor the main thread.
- The errors are written to a custom event log
- There is an event handler to handle the event logs
- When an event occurs I want to create a new thread and update the event to a sql table (pseudo code)
- Also in case their are number of errors/events
how should I handle them (pseudo code)
View 5 Replies
ADVERTISEMENT
Mar 4, 2009
I'm creating a Client Server application which involves theServer running some scripts in clients and getting back results in an automated way. In Server, other than Main thread, i have 2 worker threads, a) one monitoring response from clients and b) the other scheduling next available job to respective client which executes that job. The issue here is ,I want these worker threads to write the status of their work in the UI(which comes under Main Thread). Also i need to write things in worker thread in a Data table and Rich Text Box in Main thread. But, I can't do so, since it has been blocked to access one thread's function or property directly from others. Is there any work around to do this?
View 8 Replies
Nov 18, 2009
I have a program that runs for some time and I would like to update the user on its progress. The rest of the GUI is updated using Delegates and Invokes and such (Java is Soooo much cleaner in this regard - everything is thread safe!!), but there is no invoke method for the progress bar. How can I use a delegate to update the progress bar when there is no invoke to invoke!!
View 1 Replies
Jan 22, 2011
I've got a form that acts as a progress report for a long running operation, it has a listview on it (which I might be replacing with a DGV soon) that gets updated with progress updates from a background thread that is doing all the work. The method running on the background thread raises events that the form then handles and adds the string passed in to this event to the listview. The method running on the background thread raises progress update events several times a second and for each of these updates the event handler on the form must invoke a method on the UI thread to actually add the item to the listview.
This works fine on my test PC (which has a quad core CPU and 8 GB of RAM) but others have reported that after a while the form goes to the Not Responding state so I'm assuming all of these updates on the UI thread are being requested too often for it to be able to process them all as well as user input.So I'm looking for a better solution and have come up with the following:When the background thread raises these progress updated events, instead of them being added to the listview instantly I add them to a Queue(Of String). Then every second the form would check this queue and remove any items currently in it and add them to the listview - using a Queue(Of T) instead of a List(Of T) should guarantee they come out in the correct order. Both of these operations (adding to the queue and reading/removing from it) would be done under a SyncLock block that would lock on the same object to avoid both threads trying to work with the queue at the same time, so there would still be some contention but I'm hoping it would mean the UI thread only gets busy once a second instead of potentially roughly 30 times a second as it is doing now.Does that sound like a good plan? Can anyone think of a better way of handling this?
View 18 Replies
Apr 7, 2011
I am in the planning stages for developing a VB.Net class (let's call it OpDAq) that is to obtain data via an API provided by a COM object (AxInterop.TWSLib) that makes requests to an Internet server. The API provides data via events. Class OpDAq should do its work on a separate thread; it takes several seconds (sometimes up to ~10) to collect the desired data. One should be able to create several instances of OpDAq in order to collect data in parallel. The class would be given a reference to the TWSLib object when its constructor is called, as well as several parameters. There needs to be a way for the class to provide results, preferably in the form of a generic list.
View 6 Replies
Sep 14, 2011
I've a little program that has got tabControl with 2 tabs - "results" and "log". My idea was that when an error occurs the tab will switch automatically on tbLog to show what the problem was. Most arguably the problem is in threading. This is the code that..I use:
Dim thread As New Thread(AddressOf ExecuteQuery)
thread.Start()
ExecuteQuery executes the query and I'm making an error deliberately to see if I'll be automatically switched to the log tab which is in Try-EndTry procedure:
tbGrid.SelectedTab = tbGrid.TabPages(1)
The program indeed switches to tabLog (which is number 1) but I don't see any controls on it (txtLog), then when I'm trying to switch tabs a couple of times I get "Error creating window handle in a thread". I read other forum threads about it where people as how many controls do they have in their programs but my program does not exceed 70 controls on a form.
View 2 Replies
Sep 4, 2009
I have a standard windows application called winap. I have a com component which acts as an api to the winap. I have a class in winap call classapi which has all the methods that the api calls and all works well. The problem is that one of the methods in my class api needs to get a handle on form elements in the main worker thread. Whenever I try to access an existing form I keep getting null because the for exists in the main worker thread and my api call is in a seperate thread.
[Code]...
View 5 Replies
Apr 23, 2009
I have this code to edit the datarow of my table adapter but t doesnt update the table. I think i have a missing code that's why but i cant figured it out. by the way im using vb2008 and SQL as my database. [code]
View 3 Replies
Nov 13, 2009
I have a project which contains a large number of lookup tables, and I have all of these lookup tables represented in a single typed DataSet, which contains TableAdapters for each lookup. I've designed an editor for these lookup tables, which should allow editing of one of these at a time. My front-end is written in VB and WinForms, the back-end is a SOAP web service; I can successfully pass the changes to the DataSet back to the web service, but can't find a way to use a TableAdapter to update the single table that has been changed.
What I'm trying to do is instantiate the appropriate TableAdapter for the updated DataTable by sending the name of the table back to the web service along with the DataSet, then referring to the TableAdapter with a dynamic name. The normal way to instantiate a TableAdapter is this:
Dim ta As New dsLookupsTableAdapters.tlkpMyTableTableAdapter
What I'd like to do is this, but of course it doesn't work:
strTableName = "tlkpMyTable"
Dim ta As New dsLookupsTableAdapters(strTableName & "TableAdapter")
Is there any way to achieve this, or am I taking the wrong approach altogether? My other alternative is to write separate code for each table, which I'd prefer to avoid!
View 4 Replies
Sep 26, 2008
An unhandled exception of type 'System.InvalidOperationException' occurred in system.windows.forms.dllerror in line: dbAdp.Update(dbDset) in btnSave_Click, (elseif editflag = true) blockdescription: Update unable to find TableMapping['Table'] or DataTable 'Table'I was also wondering if I could simply use the ExecuteNonQuery for the delete statement, but since I've placed my data in a datarow, I'm not sure if i can actually use it. Any thoughts on this? Btw, this is my first time using a datarow, and I've recently been studying how to use ADO.net.
dr = dbDset.Tables(0).Rows(CurIndex)
dr.Delete()
dbAdp.Update(dbDset.Tables("addresses"))
[code].....
View 2 Replies
May 23, 2010
While am using the below code it was throwing an exception update unable to find table mapping [Customer] or data table customer.
[code]...
View 1 Replies
May 22, 2011
How can I update local dataset with mysql database without making duplicates. Assuming I set some column in mysql as primary key, which has unique string.
adapter.fill will just add duplicates, but adapter.clear before that is not an option.
So I want to update if the key column is the same with mysql data and if there is option for ignore adding new row.
View 1 Replies
Aug 28, 2011
i able to insert the table but i unable update to another table at the same time
my
Imports System.Data
Imports System.Data.OleDb
[Code].....
View 4 Replies
Jun 15, 2010
Im working on a program ( vb 2005 CE framework ). I have mainly two threads, the main one and another one I use it for a different thing.When I tried to update the UI this exception was thrown : Control.Invoke must be used to interact with controls created on a separate thread.well !I have tried to use the INVOKE, but it wouldn't work. this is where I get the error :
Public Sub PaintKeys()
Dim tempLevel As clsLevel
Dim tempKey As ClsKey
[code]....
View 5 Replies
Jun 22, 2012
The usual VB way to handle a computationally heavy task is to put it in a background worker thread, while the main thread keeps handling the UI.Say for whatever reason I needed to do this the other way around: the main thread doing the grunt work and the background one updating the UI.Here's what I have so far. The only problem is, while the UI window (Form1) does get redrawn, you can't interact with it, not even move or resize it (the mouse cursor turns to hourglass and won't click).
Public Class ProgressDisplay
Private trd As Thread
Public Sub New()
trd = New Thread(AddressOf threadtask)
[code]....
The client will call it like this (actually in unmanaged c++ over COM but you get the picture):
Dim prog = new ProgressDisplay()
DoLotsOfWork(addressof prog.update) ' DoLotsOfWork method takes a callback argument to keep client informed of progress
View 3 Replies
Dec 7, 2010
below is a small part of my asynchronous TCP connection code. When I connect I'm passing a ListViewItem as Object parameter. I'd like to update the ListViewItem once the connection has been established or an error occurs. ServerConnect runs on a separate thread, because it's an asynchronous connection, so I can't update the ListViewItem directly.
Does anybody know how to update the ListViewItem?
I looked at jmcilhinney's asynchronous TCP example in the Codebank forum, but it confused me. I don't know which parts I need and which parts I don't need.
::edit::
One more thing. I also need to update the ListViewItem in the Read sub, but I'm passing "buffer" as Object, so how would I update the ListViewItem there?
vb.net
Imports System.Net.Sockets
Public Class TCP
Private Socket As TcpClient
[Code].....
View 8 Replies
Apr 22, 2012
I am trying to write an app that in the thread will do some tasks, the form lokks like this:and what it should is something like this:
- retrieve data, populate a row in the listview, increase the first progress bar
- retrieve data, populate a row in the listview, increase the first progress bar
- retrieve data, populate a row in the listview, increase the first progress bar
[code]....
View 2 Replies
Feb 15, 2012
I am having two tables with a similar structure. I want a code to select data from one table and update the same in second table and then delete the records in the first table.
View 6 Replies
May 1, 2010
I need to Update Access Database Table with Data from a Different Table. Not all the rows of original Table to be Updated will be affected. How do you loop through the 2 Tables to do the required Update.
The Table to be updated is called "RecordList" and Table with new Data is called "RecListReport".Every attempt I've made won't work. I tried to Use 2 Datagridviews but couldn't get it to work right.
NewTestConn()
Dim Testconn2 As New OleDbConnection(NewTestConn1)
Dim da As New OleDbDataAdapter
[Code]....
View 6 Replies
Nov 2, 2011
Basic function - enter 5-10 urls. Download all web pages using multi threads and then process it. Then in the end, the text from all threads should end up in a richtextbox. It can't be done using any of my googly searches so i thought about asking this :
how would you update text in a richtextbox from a different thread?
I am being able to download and process web pages. But can't add it to richtextbox.
View 2 Replies
Jul 26, 2011
I have a TCP server app that starts 2 threads when the server is activated, I want the threads to add text to the textbox on the main form. Here's is what I have tried [code]I have added MsgBoxes at points so I know the Sub updatetext_ is being called, and the text is being passed, they are also showing that InvokeRequired is always FALSE. In any case the textbox txtMessages is not being updated.
View 11 Replies
May 9, 2010
I've looked at the on line doc over and over, and I can't seem to figure out why this won't work. This code runs the thread, and the thread seems to execute the code in the 'threadsafe' sub, however neither the progress bar is updated or the button click performed.
Imports System.Threading
Public Class VisNotify
Inherits Form
[Code].....
View 4 Replies
Sep 1, 2009
I'm not sure exactly how to describe this. In VB6, there was a Timer command. I could create a variable of type Timer and loop until the current value for Timer exceeded the initial plus a given amount of time. This allowed me to update form variables while the timing loop was executing. How can I do something similar in .NET?[code]...
View 5 Replies
Oct 20, 2010
I am new to multi-threading in VB.NET and have come across a problem whereby I am wanting to append text to a text box on a form from a service thread running in the background.
The application I am developing is a client/server listener, I have been able to get the client and server PC's to talk with each other (confirmed through MsgBox), however I am now struggling to get the service thread on the server to append the text to the textbox, nothing vissible occurs.
I have a form named testDebug which calls a class (RemoteSupport), this class does all the handshake tasks and updates the textbox with the connection data.[code]...
View 2 Replies
May 4, 2010
The code below works fine when I put it in form1.vb and change "form1" to "me" but I can't seem go get it to work from my class.
VB
Imports System.Threading
Public Class Class1
[Code].....
View 2 Replies
Dec 8, 2009
I'm writing a program in which I'll receive data using serial port using Comport.DataReceived event which I've written in seperate class. Once I receive data from my comport I need to display that data in my listbox in the form. What is the best way to do this?? I don have much knowledge on using delegates. An
View 14 Replies
Apr 22, 2012
I have a form that looks like this:and i'm using a backgroundworker to update the components:
Code:
Private Sub btnGO_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGO.Click
[code].....
View 2 Replies
Aug 8, 2011
I have a web app which displays a list of emails that need to be sent for the day. The user can select what emails to send, then click a button to generate them. When they click the Send button, a process gets started on another thread which generates the emails, then cleans up after itself by deleting a temp folder. Once the process is finished, the Repeater is rebound to update the User's view and remove the emails that have just been sent so they don't get sent again.
My problem is that when I delete the temp folder from my 2nd thread, the UI doesn't update with the new Repeater data. It updates correctly if I just delete the files in the folder instead of the folder itself, and it also updates correctly if I run the delete the folder on the original thread instead of the 2nd one.
New Thread code
Dim t as Thread = New Thread(New ThreadStart(AddressOf EmailLetters))
t.Start()
Delete folder code
Dim fs = Server.CreateObject("Scripting.FileSystemObject")
fs.DeleteFolder(Server.MapPath(".") + " mpEmailFiles")
Why won't the UI update to show the new repeater values when I delete a folder on another thread?
When you click the button, a thread gets started and a javascript load script starts executing which does a PostBack every 10 seconds. Each postback checks if the thread is complete and updates the Status label showing the result. If I delete a folder from within the background thread, the final update to the status label never occurs. If I remove the DeleteFolder call, it does.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ Import Namespace="System.Threading" %>
<%@ Page Language="VB" Debug="true" %>
[Code]....
View 2 Replies
Apr 17, 2009
I created a new thread to run with a loop to update a textbox (this is just a demo, in reality this thing would go out to a db every x minutes to request an update). I did this on a timer, but i wanted to try to do it on a different thread.. anyways, this is what I have: (one form, one textbox, and this code...)[code]I'm getting a warning through (the "Thread.CurrentThread.Sleep(2000) part is underlined) which states:"Access of Shared Member, Constent Member, enum Member, or Nested Type through an instance; qualifying expression will not be evaluated".
View 5 Replies
Nov 12, 2010
I've been searching around for ages now but can't seem to find what I'm looking for, anyway came accross this wonderful place so thought ay I'm creating a rewards system for school where pupil earn points for good behavior which they can then use to purchase things like a packet of pens. (They can also have points deducted for bad behavior)
View 2 Replies
