Program Not Responding - Keep Track Of Tons Of Data By Inserting It Into Sql
Mar 18, 2010
I have created a little program that helps me keep track of tons of data by inserting it into sql. I created 5 forms and all 5 can insert data at the same time, but mostly just 1 of these is working continuously. I have noticed that the program will run, then at random times it will stop responding (can't minimize/click on anything/data entry stops), and the only way to stop is to kill the task. I can't even click in the debugger to set a break point when it happens, and setting breakpoints before debugging is useless as the program could run 2 hours and stop, or 10 minutes and stop. 5 forms, they open different excel files, insert data into sql, and repeat.
I want to create a program that will keep track of the amount of (network/internet download) data that has been received, but I have know idea how to go about doing it.Where would be a good place to start with this type of development? Or could some one give me example code that will get me started.
I've been working on a program that generates a batch file, then when you press a button, it executes that batch file. There are multiple batch files attached to each item in the list box.
[code]...
The only thing that it does when I press the button, is starts the batch file, then goes to function searchtitle, which executes the batch file again when it finds out it didn't work properly.The button text doesn't change, none of the items are being added to my first list box, and I can't do anything to the window after pressing the button. It constantly opens the batch file every 5 seconds or so.
I have written a very simple program to simulate the operation of some electrical relays which respond to buttons pressed on a form.The important thing in the program is the pick and drop times of the relays so I use about 40 timers to simulate the operation of the relays each stimulated either by another timer or the operation of a mousedown operation over an area of the window which has a GIF background.
The program works great when simulated within VB2010 Xpress but when I publish and install on either of my 2 laptops it freezes and does not respond to the mousedown procedures. It seems slightly better if I don't enable XP visual syles but still does not respond enough to be used. I am running 12 procs each time a continous timer runs out but altering the value of the timer does not make any difference. I've also noticed if I minimise the window and reopen the window it does move on slightly but still never responds to the mouse.
Also the timers in the program for the relay times seem to work at strange values and not those set sometimes? It seems to work OK on my main PC if I install it
I am making a mass emailing system that reads off of a xml document and sends an email based on the stored object made from the XML tags.This program will have to send hundreds if not thousands of emails out. I made a test XML document with 160 emails to be sent out to my address.The program gets a (not responding) after about 10-15 emails, (although it keeps sending). Also the email sent counter lable doesn't change at all during the sending, the progress bar works however.Also, when I tried running it it stopped at 140 emails.
' Algorithm ' Show the progress bar ProgressBar.Visible = True
I have a form with 3 background workers. On the click of a button all three start async. Once they all finish my program stops responding. If I run one at a time I encounter the same error.
'Background worker 1 Disableform(Me) Try Dim source As String = _Topsource("[URL]" & gamertag.Text) Dim statstbl As String = source.Remove(0, source.IndexOf("<div class=""statWrap"">")) [Code] ......
I am making a process monitoring program for his game server. Occasionally, the programs stop responding. I've used the if process.responding then process.kill la de da, but its not working right. Is there a debugging tool out there i could use to intentionally make a program stop responding?
I am trying to search for the occurence of a string within MS Access database with 1000000 records using VB.Net. The program does not respond once it is run or it is taking a very long time. However, if I reduce the size of the database the program runs.[code]...
I'm using VB 2010 Express with a local Access DB. On the form I have a DataSet, a TableAdapter, a BindingSource that points to the DataSet (and the DataMember is the same table as the TableAdapter), a BindingNavigator that points to the BindingSource and finally a DataGridView that points to the BindingSource also.
I have added a Save button to the BindingNavigator. I want to enable / disable the Save button depending on whether there are changes in the data to send back to the Access DB. I think this is the code, but I am not sure if I'm really doing what I think I am (i.e. I am concerned I will assume something turns out to be wrong) or if there are better ways.
I am also uncertain what event to use to respond to. I have guessed at CellLeave, but I could be wrong and there might be much better choices. Finally I've been told that it's different if it's a DataTable, but I do not know enough to determine when something is a DataTable?
Private Sub CompClass_DataGridView_CellLeave(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles CompClass_DataGridView.CellEnter Me.BindingNavigatorSaveItem.Enabled = Me.Component_MI_DataSet.HasChanges End Sub
I am having an issuse with weither i should make 15 different fourms or just make 15 text boxes three for each round plus creating something that would add the doubles and triples I do not know what to use for a code, I have just started programming. this is what i have tried to do.
I'm trying to make a program where you can keep track of your progress through various projects your doing. I'd like to have it so they can add a new project via the text box/button and then when they click on that project from a listbox or something(still trying to figure out the best way) it shows the notes they have typed etc. I know how to make it so its saved when they exit and all that good stuff but I'm not sure how I would do everything else.
I am trying to use a power meter to track the progress of my program; this will be for my use only and will be removed later. I would also like to display the percentage run in the meter. I already know what the start and end points will be for the meter. What do I need to search for? I have been looking and haven�t been able to find anything that suits my needs yet. I am running VB 2005.
I have created several WPF User Controls. The lowest level item is 'PostItNote.xaml'. Next, I have a 'NotesGroup.xaml' file that has an ItemsControl bound to a List of PostItNotes. Above that, I have a 'ProgrammerControl.xaml' file. Each ProgrammerControl has a grid with four different NotesGroup user controls on it (and each NotesGroup contains 0-many PostItNotes.
Then, I have my main window. It also has an ItemsControl, bound to a list of Programmers.
So, you end up with a high level visual view of a list of programmers, each programmer has four groups of tickets, each group of tickets has many PostItNotes.
The trouble I'm having, is that I want to respond to a mouse click event in my mainWindow's code behind file.
I can add a MouseClick event into my PostItNote.xaml.vb file and that is getting called when the user clicks a PostItNote, and I can re-raise the event; but I can't seem to get the NotesGroup to listen for that event. I'm not sure if that's even the correct approach.
When the user clicks the PostItNote, I'm going to do a bunch of business-logic type stuff that the PostItNote control doesn't have a reference to/doesn't know about it.
I want to make a program that will track Do Not Rent (DNR) People.I'm a intremediate vb6 programmer and have not coded in a long time.I do have and wanting to do this on VS2008 professional in VB2008.I did a simular program from a vb6 book about 12 years ago. it was a address book that i changed a little to add some things I needed it to keep track of, and it saved everything in a text file.I want to know what the pros and cons are for using a text file? xml file? or a data base?the data i be keeping track of will be vital statistics as name, state id number, id type, ect. and a picture of the id from a scanner or import from a .png, .jpg, or tiff image.If i use a data base file either Access 2007, MySQL, or SQL 2005/2008 file, do i need to have Office, MySQL, SQL 2005/2008 programs installed on the the computer im doing the programming on? do i need to have the above programs installed on the target computer?i do not think a txt file will work for me because of the picture i want to keep with the data not seperatly. So to make it a little more clear I want to be able to add, append/update, not to be able to delete a record, and be able to search the file for a record.I want to be able to navigate the records or file with first, previous, next, and last. each record will be showed seperatly.I would like to have a STATUS (lol thingy) that only my wife or I can change but let my employees be able to enter the rest of the information on there own. the STATUS Levels will be like 1st warning, 2nd warning, 3rd warning, DNR, and Rentable at our discression. I want it to only allow changes to status if they have the proper password. so i do not know if this also elimates txt files or xml files as an option.and when the wife, my employees or I make an entry I wanted it to add the time and date with the comments we entered in with the initials of the person whom entered the data. so i was thinking i will need to have security levels in my program and give each person a password so the program can fill out most small data itself.
if i do decide to use a database file to store the data, picture, and employee information can it be done with 1 table, or should i try to seperate the data in seperate tables? should i use one to one or one to many? I do not think one to many would be the best solution? it been like 12 years since I did any database programming in school and it was dBase3. If u think it be best to use multiple tables could u give me an example as to how to seperate the data.The client info would be like a address book with a picture and a comment box that will automatically add a date/timestamp and the users initials with a space between every updated or appended entry., and the employees would have there login in name and password, and initials.I was thinking of making a wizard to enter the data in for both employees and the DNR's as for people changing the date on the computer and entering info so to make it look they entered data on an earlier date I was thinking of having it log onto the internet time server and setting the date/time of the computer in the background as it loads up.
In one of my applications, I decided to make a separate project for a few general classes. However, it started to give me tons of errors that I am having a difficult time figuring out.
I have data(one byte) that want to write on the Last Track of CD (the end of a cd ,where that is not able to write any more data on it)and read that. I dont want change CDFile system data
I have to write a program that will allow a usert o track the invitation list for a party. The user can enter the name of a person to be invited. When the send Invitatin button is clicked, the name appears in the checked listbox. This counts as an invited person.When an invited person confirms that they will be attending, the user will check the name in the checked listbox. this counts as a confirmed person.
What I am having a hard time figuring out is the codes! What would I declare my integer variables to hold the count of invited persons and the count of confirmed persons? And how would I code a loop to check if the name enetered in the name textbox already appears in the list box, if so, display a message telling the user that this person has already been invited?
I'm working on a small project, and ran into an issue. I'm creating new picture boxes on a form to represent a control. My question is how would I code a click event for an object that isn't on the forum initially? Also, how can I keep track of which object is assigned to which data in an array? (IE picturebox 0 is array(0) of data)
I have a program that runs a pretty long operation in the background once a user clicks the button. I have implemented a progress bar but if the window is touched or moved then it grays out and says (Not repsonding). Everything still works and when the operation finishes the program resumes function. (But a user would not know this
I am INSERTING into 2 different tables with 2 different buttons (One after the other by clicking each button). I have a form with 1 button directly on it to INSERT into tblCustomers from a field that is directly on the form as well. I then have a TabControl with another button with other fields (5 to be exact).
After I add data to the data base by filling out the field on the form and then by first clicking the add button located directly on the form and then add data to the fields directly on the TabControl the data will not INSERT itself into the tables in the data base for the 2nd table. Only the first table get data in it and not the one related to the TabControl.
BUT if i add data in the TabControl and then click the button on the TabControl it adds data into to the 2nd table. Is there a way to refresh my program so that it will accept both the "forms data" and the "TabControl data"?
having problems getting one of 2 pictures displayed when I run the program. In a whole, this is a coin tossing program that, after the toss button is pushed, is supposed to show either a coin heads or tails image while also displaying True or False for heads or tails respectively. Additionally, a running tally of how many times heads and tails is displayed.The main issue right now is that when I press the toss button, no image is displayed, but True or False is displayed as well as the running number. After checking, running numbers correspond with the T/F results. The secondary issue is that a running tally is displayed, but instead of it being in a single or double digit increasing format, it shows up as 0011122223345666 as you keep pushing the toss button. I've researched books and the web to find out where I'm going wrong and to get more clarification on why it's not showing, but I haven't been able to decisive.
Public Class Form1 Dim randomObject As New Random() Dim headscount As Integer Dim tailscount As Integer
I am using VB.Net 2010 and SQL Server 2005 Enterprise Edition I have created a table named customer having columns (id int, fullname varchar(50)) and id is my primary key I have created a Class Library for inserting data into the customer table. to insert data I am using following code...
Public Function insertData(ByVal TableName As String, ByVal LinkToDb As SqlConnection, ByRef Adapter As SqlDataAdapter, ByRef DS As DataSet, ByVal MyArray As ArrayList) As Integer ' ----- inserts data into table Dim sqlCmd As SqlCommand
I am writing a simple program that serves a similar purpose as the character map, but just for the Spanish letters with accents (������ & ������). Character map doesn't work for me because I have to highlight the letter I want to insert and then copy it and then paste it into whatever window I'm working with.What I want to make is a program that has buttons for each of those letters, and when I push the button for a particular letter, it inserts the character into whatever window was active before I pressed the button. I also want whatever window that was active before I pressed the button (the window I inserted the character into) to become active again so I can resume typing right after I press the button.I have programmed in VBA before, but this will be my first VB project. I have tried searching how to do it, to no avail. Where do I begin?
Is there a command or couple of code lines that will pause the running program for one or two seconds?
I have a program that checks the system time every 250milliseconds and I need to skip checking it three times the first time it comes back with ":00" seconds from the system clock.
Or another option would be to reset the timer to 1000 and then back to 250...
Basically I am trying to insert some data about a user into a database for a test that they complete. If it's their first time completing the test then I want their results to be automatically stored. If not then I want their results to only be overwritten if they agree to it.
Here's my code so far: Dim sqlx As OleDbCommand = New OleDbCommand Dim con As New OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source =
Doing a project in Visual Web Developer 2010 using Visual Basic. MS SQL Server 2010.I can connect to my SQL server. But when I try to INSERT INTO sql server, I get an error that the columns could not be found. But the column's SQL is listing is from my VALUES field! Here is code and SQL error. [code]
