I have been working on something that checks an MySQL Database to check something - however the program stops responding because it is constantly checking the database. Is it possible to have it wait a few seconds to recheck the database? [code]...
View 2 RepliesI am trying to update a field in my MySQL database using VB.NET.....
Basically, I can read the field's content, using this code:
SQL = "SELECT * FROM `boomtable` WHERE `Tab1` = 'CLOSED'"
However, I want to update the Tab1 field to have the value OPEN if it's currently closed, and make the value CLOSED if it's currently OPEN.. Right now, it's CLOSED, (I put the value in manually when making my table)
Here is the code I'm using that changes my label based on the Tab1 field's value that works fine... Except I want to actually make it update the field in the database in addition to changing the label text.[code]...
I have been on a database project for a while now. I wanted to be able to make changes to my database using the update command of a Datagridview control.However, I have been faced with a series of unsuccessful outcomes.I want to do this how do I go about it?
[Code]...
ok I have a program that controls another program.. but sometimes the other program is not running.. so I ask the question "do you want to run it up" so if they it takes like 15 seconds to come up.. so really I dont want to do much on my program while we wait for that other program to finally come up..
normally when my program comes up I make sure the other app is running.. and it would come up before you would click on something to try to call it.. but during the day.. maybe their app crashes.. so then right before I try to make a call to it I will check if its running.. so I want to run it up but kinda put a hold on my code while it waits..
so whats the best way to do this ? stop my code.. call a timer and when it see's its up call again ?? or can I put in some wait in the code then continue... just looking for the best method people have used..
I am using System.Diagnostics.Process.Start("C:Program FilesAutodeskACADM 2010acad.exe")
how do I make the system wait till the program is fully launched before it executes the next statements? If it doesnt wait, it crashes.
I dont want to use system.threading.thread.sleep as it varies for each computew how long it will take to launch
Is there a way to make an update for your program that the 'user' can update the app without re installing the whole program?
View 1 RepliesCode is below. I am designing this code to transfer a file at a specified time. Right now, I have it sending me an email when it succeeds for test purposes. It will be only when the file copy fails later.
Here's my question: how can I get the program to wait until the file copy is complete to report success or failure? Right now I'm using exists to see if it works, but some other method of checking the file will be built in later. Eventually, this will be deployed to various locations for a bit of automated backup.
[Code]...
I built a console application with a loop at the end,[code]in the loop when the user press "q" on the keyboard, the program will go out of the loop, I've tried using Console.Read or Console.ReadKey which is not working because it waits for the user to press the keyboard,but I need the loop to keep running although the user is not pressing the keyboard so in the program the console will be like: AAAAAAAAAAAAAAAA,etc. until the user press "q" on the keyboard,
View 1 RepliesIn my program, if something goes wrong an ErrorForm is supposed to show up and tell what was going wrong.
And if the error is a "fatal type", then I want the program just display the ErrorForm (which gives some information about the error), wait for a button press, and then close the program (terminate run).
In case of error, the form is displayed.. That's good.
But as the program is supposed to terminate after showing the error form, the error form disappears immediately after showing up (so it doesn't allow the user any time to read what's going wrong).
How can I make the program wait until a button press (on the error form) and then terminate?
how to tell a program to wait or pause without using a timer control.
I did a bit of Lua scripting a few years back and the function was: Wait(5) or however long you needed the program to pause.
I've made a gui for a cmd line program and I need to wait for the cmd line program to finish running before continuing.nd I have some code that starts the cmd line program and then calls a subroutine when it's finished running. But this method won't work since now I'm trying to run the cmd line program in a loop.Edit:Is there a way to just have the runtsmod subroutine (shown below) wait until the cmd line program is finished, instead of relying upon a subroutine starting when the cmd lineprogram finishes. This would simplify things greatly being able to call the sub tha starts the cmd line program and having it finish when the cmd line program is done.
Sub runtsmod()
'If the tsmod program exists in the directory the GUI is run from it is ran
Dim tsmod As String = Application.StartupPath & " smod_GUI.exe"
[code].....
While navigating to a series of sites at one site the WebBrowser control's DocumentCompleted EVENT is tripped and no other recorded Browser events occur after that. When this happens the hour glass cursor indicates the browser is waiting. From this point it take 120 to 250 seconds of wall clock time before the browser resumes. I am looking for a way to force an abnormal termination without destroying the control. I have tried "Stop", "nav to about:blank" repeatedly without success. How can I force an abnormal termination when the Cntrl is in a wait state?
Consider the following: The last known Browser event to be tripped is a Document Complete event; nothing else occurs after this. When this transpires the Cntrl is waiting.
1:50:657: ============================= ENTER WebBrowser1_DocumentCompleted EVENT ========================================
31:50:657: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^THE NEW WEBBROWSER STATEMENT
[code]....
How to make a program wait until a button is clicked by the user. I want to stop my sequence of codes (statements) until a button is clicked by the user.
View 1 RepliesI have an app that gets info from the internet into a label, the progam then decides which event will hapen depending on the info obtained, either load next form and continue or Application.Exit
My problem is that the speed that the info is returned from the net, varies and because the info is late sometimes the program exits when it should not.
Ok so I have a Mysql dsetup called in-out and I have written a vb.net client program to get information from the table in the database, display it in a data grid view, and then allow to user to edit this information and update it on the server. Right now I am hosting the server on my Gateway laptop and also connecting to it from the same laptop therefore I'm using localhost as the server name. My problem is that when I go into the program and change the information and click update, nothing happens... the information stays the same yet there is no sign of an error, syntax failure, or program crash.
I've tried running this on another computer in my house and i get the same results. I can access the information without a hitch but updating it is where I run into trouble. If there was a problem with my code it would have displayed some sort of error or asked me to debug my script, which would have made it a lot easier to solve, therefore i am certain that it has something to do with my database. Before I got to this step, i kept getting an error when retrieving the information that said something like
[Code]....
I have been trying to update my database I only receive a msg box replyng that my msg is successfull updated but when i check my database no data is being saved!
here is my code for update
CODE:
Here is my changePassword button code where I call the method UpdateDB:[b]
CODE:
How would I pause an external program (exe), wait 10 minutes then unpause it using VB.NET
View 2 RepliesIn my MDI Application code I have a form that launches a second form then hides itself until the spawned form closes. It works great unless I choose to close the application while the spawned form is still up.
The following is some example code.
Dim ChildForm as New frmTaskWindow With { .MDIParent = Me, .AddingNew = True }
ChildForm.Show
Me.Hide()
[Code].....
Me.Show() ' error occurs here because my form is already closed by the system. Is there a way to get around this without just an error catcher?
I have a program, that on form load, updates a value. The problem is, that it doesn't work!
my
Imports MySql.Data.MySqlClient
Public Class Form1
Dim MysqlConn As MySqlConnection
Dim UserCommand As New MySqlCommand
Dim SQL As String
[Code] .....
And the problem is that it doesn't update the points. I set the points to 10 via PHPmyadmin, and run the program, but when i go back to PHPmyadmin, its still 10.
i have problem to search and update record database sql. this is my code. i using mysql database and Microsoft Visual Basic 2008
[Code]....
but i have error on Word command.ExecuteNonQuery(): MySqlException was unhandled. There is already an open DataReader associated with this Connection which must be closed first
I am trying to update mysql table from a txt file using vb.net. So far I've found code here and there and been able to extract the data from the txt file, now my question is how to update mysql from the same dataset or xml file. Here is my code to populate the datagrid/dataset/xml file.what is the easiest way to update mysql assuming "Orden" is my primary key in mysql.
OpenFileDialog1.Filter = "Text File|*.txt"
OpenFileDialog1.Title = "Open File..."
OpenFileDialog1.FileName = "trackings"
[code]....
I Use visual Basic 8.0 and Mysql 5.0 I have one Table1:
[Code]...
I want to use Datagridview to update Mysql table1. All changes as update, change, delete automatically processed into Mysql table1. Here by my code
[Code]...
I have some difficulties concerning threading [code]
Code:
1- Dim str As String
2- Dim x As New myClass
3- str = x.doSomething()
4- x.closeSomething()
I've included line numbers so I can just refer the lines by their numbers. My problem is, when the program executes, line 4 seems to be executed earlier than I want it to. It gets executed while ThreadX is still running in line 3. How can I force the program to wait until ThreadX has finished executing, before it executes line 4?
I have made this code, which is to update the MySQL db, the only problem is that even though i got try on, it dosnt catch any erorrs, and the code is not working, meaning it dosn't update anything in the db.
code:
Private Sub updateSqlData()
Dim nSQL As String
[code]......
I have built a dataview where i display data information from tables which was created in MySQL. Can i update the datagrid cells by just clicking it and entering new information ? By updating the datagrid cells, will it automatically the relevant database tables ? If yes, how do i go about writing codes. All the cells now just consist of text format data.
View 11 RepliesI can't figure out how to update a field in a MySQL db using MySQL Connector Net 5.2.5. Can anyone show an example code?
View 2 RepliesI am building a vb.net application for a client, and there is a problem. I am connecting to a mySQL server, and using the UPDATE command to update certain fields to the specified values, however, once I run this code, the fields on the mySQL server turn EMPTY. Here is my code :
Sub updateresidents()
'MAKES NO SENSE; UPDATES EMPTY FIELDS ON mySQL SIDE??!!!!!!!!!!!!!!!!!!
Dim connection As MySqlConnection
[Code]....
I am using VB.NET with a MySQL database. I want to update this code to do it all in ONE SQL instead of THREE. Here's the code I'm using, works fine but too slow with multiple lines...
If count3 = "1" Then
Dim myCommand As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim SQL As String
myCommand.Connection = conn
[Code] .....
I've been working with a remote mysql database. The design of the database pretty much requires that I use SELECT commands that include multiple tables, and sometimes joins. Updating a single table query is SO EASY, yet dealing with multiple tables has me pulling my hair out.
[Code]...
What's killing me is that if I make a change to a field in the products table in the datagridview and press button1, the changes are saved. If I make a change to a field in the specials table in the datagridview and press button2, the changes are saved. If I combine the two updates together in a single routine, only the first one is saved. I presume this is because after the first update executes, the dataadapter no longer reports that there are any changes to save, since the update already happened.
I've tried breaking this up into separate dataadapters for each table, but then even using dataset relations, I can't get the data together in a single datagridview. On top of that, the grid itself is only intended to be used for searching and querying data. It still needs to be bound along with a set of textboxes that accept the input.
Lastly, this database is part of an ever-evolving website database with dozens of tables that need interfacing. I just can't see manually maintaining hand written sql statements for every table. That's why I've been working so hard to get the commandbuilder to handle it.
I've just switched from classic ASP to .net and I always used the following to SELECT, INSERT, UPDATE and DELETE from my MySQL databases:
' Create db connection
Function dbConn()
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "driver=x;Server=x;Port=x;Option=x;Database=x;Uid=x;Pwd=x"
[code]....
And to insert, update or delete I'd use:
Call SQL(1,"DELETE FROM Users WHERE UserID = 1")