Stopping A User From Destroying DB?
Mar 4, 2011
I'm developing an interface for users that will allow them to enter data into a database without having to know SQL. Problem is, some one out there probably does.
How can I stop them from deleting/screwing with my data when they're typing entries within my text boxes?
For example, I don't want anyone to be able to type in DELETE * or any other kind of SQL statements in a text box to ruin the DBA's day.-Nothing to see. Move along.
View 3 Replies
ADVERTISEMENT
Dec 13, 2011
currently I have a timer that starts when a user hovers over a button, how can i make the timer stop when the user stops hovering over the button?
View 4 Replies
May 12, 2012
Some one built a terrible database and it's now up to me to put the data they captured in a new database that's been designed.
I am querying a table and pulling out its text and sending that text into the new database via a query[code]...
View 5 Replies
Aug 7, 2009
I've almost finished my database application, and I had an idea to insert a button that creates a copy of the database. However, when I click the button, it destroys all of the data in the file before copying. It's a 2000 .mdb Access file with 500+ rows so far.
Here's the code that handles the backup: Private Sub btnBackup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBackup.Click
[Code]...
View 2 Replies
Apr 26, 2009
A] Is there any way of stopping a user from entering text or changing text in a textbox without disabling it or
B] Is there a way of changing the texboxes back and fore color whilst it is disabled?
View 5 Replies
May 22, 2012
I have written a program to add a timestamp to a data sheet which had the time in seconds at which a sample was taken. The sampling was done every 0.1 seconds i.e 10 Hz sampling rate.The code I wrote enables one to select a file to which the time stamp must be added, and then runs a macro from excel when you click "Add Timestamp".
I am having a problem destroying the objects though so that they don't end up hanging around in the background. If Excel is already open I do not want it to close at the end of the program, I want Excel to simply return to its state before the application was run in order to prevent losing data on another unrelated excel task which may be open. The macro which is called closes any sheets which it opens. The other problem I am having is that if the program encounters an error there are a number of Excel objects floating in the background. My code is posted below.
Imports Microsoft.Office.Interop.Excel
Imports System.Runtime.InteropServices
Public Class Form1
[code]....
View 1 Replies
Sep 3, 2010
disposing http listening object when program closed which located other file than my main form.I am starting http listener like this :
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
WebServer.Main()
Klasör = "C:UsersSalihDesktopWebServerWebServerWebServerinDebugWWWRoot"
Sayfa = "index.html"
End Sub
View 1 Replies
Nov 12, 2010
What i have to do is write a program to display multiplication table when a number is put into the textbox and it prints out multiples of 1-12
ex.
user puts in 5, listbox should say
5 x 1 = 5
[code].....
View 1 Replies
May 22, 2010
Is there a way to stop other subs from running while in a separate sub.
for instance say your in the sub
CreateNumber()
and the subs are setup like
CreateNumber()
AddNumber()
DeleteNumber()
Is there a way to be in CreateNumber() and call a function to stop AddNumber from running after creaetNumber() is finished? i just want my program to sit there to wait for an event to happen.
View 1 Replies
Nov 29, 2007
I'm currently programming a music software which plays notes which are listed. as timer ticks, the notes change and so it plays a different *.wav file. The problem now is that the previous sounds stops when a new sound starts. i want them to overlap each other until each one has finished. Code: my.computer.audio.play("file.wav")
View 30 Replies
Feb 6, 2012
I've been trying to create a timer that waits for another timer to finish with its coding and, when it's finished, executes a series of code before stopping itself.
This isn't the code for the actual program I wanted to implement this self-stopping timer in, but it's simple and has the exact same problem:
Public Class Form1
Private Synchro As New Timer()
Private Sub MeLoad() Handles Me.Load
[Code].....
The idea here is that it's suppose to (using a timer) show the messagebox ONCE and ONLY once per button click. However, what seems to happen (despite the fact that I have 4 ways of trying to tell it to stop) is that the program creates multiple messageboxes until there are a total of about 49 messageboxes on the screen at the same time. I don't know if I'm using the wrong event (unlikely as Tick seems to be the only timer event) or there's a way of stopping the timer that I don't know.
View 7 Replies
Aug 25, 2010
I created a service in VB.NET and it runs fine on Vista, I can log off and switch users and the service auto starts and continues to run every time without fail.If I install and run the service on Windows 7, it will not start after a logg off/on or after I switch users.
View 3 Replies
Oct 8, 2009
I have a WCF service, which I can open and close by doing:[code]The problem with this is I have "downtime" of the service in between myService. Close() and newService.Open(). if anyone tries to connect while this is happening it fails. how can I make the "downtime" as small as possibel?
View 12 Replies
Oct 14, 2010
I'm trying to figure out the code for the timer that would allow me to stop the timer after X number of runs through the code. Here's what I have so far:
im tmr_cnt As Integer
tmr_cnt = tmr_cnt + 1
If CInt(boxAns.Text) = CInt(lblnum1.Text) / CInt(lblnum2.Text) Then
[Code].....
View 3 Replies
May 18, 2010
I have a vb.net application which does some processing. This processing can take a while. The application doesn't respond until the processing has ended and then it handle all events (such as click on buttons) that the user has done during the processing. I'd like to add a "Stop" button so that the user can stop the processing at some point. How can I do that? Could threading the processing (which is done in a function of the application) be a possible solution?
I tried to add a button which change a boolean value and putting the code of the processing function inside a while statement based on that boolean value. However it doesn't work because the click event on the button is processed only after the end of the processing.
View 2 Replies
Aug 5, 2009
Ok, so the PDF problem was traced back to when I would close the test build. When I would close my app via Me.Close the Adobe.exe was still an active process.
I have several forms that include multiple PDFs. I need to ensure that the Adobe.exe process is terminated during the exiting of my applications.
How is this accomplished or is there another way?
View 2 Replies
Jul 23, 2011
I used a combination of If and doWhile loop codes. Is it possible that the loop will stop at 2nd loop if it will perform a 3 loops?I'm creating an app that if the problem is got the match at 2nd out of 3rd loop, the loop will stop.
View 1 Replies
Jun 23, 2009
I have this code within a button: If TextBox1.TextLength = 3 Then MsgBox("Please enter 3 numbers followed by a letter. For Example 001A")TextBox1.Text = "" Me.Refresh() End If Although if the user enters 3 numbers only, I want the rest of the code in the button to be ignored so that it doesn't proceed.
[Code]...
View 3 Replies
Apr 26, 2012
I know the title of this thread is a show stopper for a lot of us . But what I want to do is stop two services from running for a period of time then restart them. I know I can do this from the command prompt by using net stop servicename then restart with net start servicename. I need these two services stopped to do some work on the database. I do this manually right now and want to automate the process. I tried process.start with the command net stop but that did not work out. If I try the Process List I get the process running but not the services.
[Code]...
View 4 Replies
Jun 19, 2012
I was wondering if there was any way to stop a for loop untill i have user input, once the input is correct continue the for loop, is that possible at all
View 3 Replies
Dec 15, 2011
I have an application that is on a server running. The way I have it setup is I put it on the Windows Scheduler to run at certain times. We now need to run it constantly on the server. I change the code to put in a loop until I pause or stop it. One issue I have found is that I can kick it off but when I close out of my remote session the application stops.
How do I keep my application to keep running even after I sign out of RDP?
View 6 Replies
Feb 10, 2011
I was wondering how someone could stop a For loop in the middle of it, according to parameters. I have tried but cannot find a solution that works, I suppose an example of this would be if a loop were increasing a label by 1 from 0 to 100 and the user sets it to end at 57 or any number in between and when the loop reached the number to stop.
View 8 Replies
Jan 13, 2012
Using this code, before I added the funky "abort" button code - stopping it using the Stop Debugging button in the IDE blue screened my computer every time, PROCESS_HAS_LOCKED_PAGES - Anyone care to try it ? Win7 Ultimate , VS2010 SP1. This machine has never blue screened since it was built. Code is by no means exotic in any way.
Public Class Form1
Dim Abort As Boolean = False
Private BStart As New Button
[Code].....
View 8 Replies
Apr 9, 2010
I have created a form in which it watches a specified path for excel file changes - this part is on load.
[Code]...
This is supposed to delete any temp file that gets through. Then, when it finds an excel file, it will try to open it. I noticed the sub kept launching when I opened the excel file, so just another check to make it safe. the two variables filearray1 and filearraypath2 are public - filearray1 is an array list with full excel paths (another thread loops through the array and does the operations of the excel file) and filearraypath2 makes sure that the same excel file won't be added twice in a row.
Now, this works really well, but for some reason, at some point, the addfile sub won't kick off, even if excel files are changed, created, deleted, anything. I set a breakpoint on the first 'if' line of the addfile sub, opened an excel file and made changes, or created a new one, and let the program run for 10 minutes and the breakpoint never hit.
View 1 Replies
Apr 18, 2011
I have a function to pull data from a XML, and to report a specific number based on a value in one of the elements in the XML. Unfortuntately, I can't get any break points to work, so I've been debugging with a trace.he strange this is that when i take out the function itself it works like it should, otherwise the Service freezes when it gets to the function and never uses it. I'm calling the function in while loop which is also within a Try Statement, here's example of the code.
Public
Shared Function GetXNumber(ByVal
audit As Audit.API)
[code].....
View 12 Replies
Aug 12, 2011
I have an application in which there is a do...loop. I need the do...loop to perform some code and then stop for .1 of a second. When i try using System.Threading.Thread.sleep(), a wait cursot comes up and the application stops working. I was wondering if there was any way to get the thread to stop without stopping the application.
View 5 Replies
Sep 21, 2011
I have created a Windows Service in VB.NET (VS2010) that executes a certain task every minute. When the service is being stopped, either manually by the user, or when the system is rebooted, what can I do to make sure the task is being finished properly before the service is actually terminated?
View 1 Replies
Apr 21, 2011
The solution and all the projects within it are set for Debug;I deleted the .suo file as recommended in one posting.I ran rebuild on each and every project individually and the entire solution.I deleted the files in binDebug and did the whole thing over again. Still can't debug.
While stepping into (F8) I did get the hollow debug symbol in the margin and when just running the program (F5) the program starts up without stopping at any of several breaks in different functions and subs.
View 4 Replies
Mar 3, 2010
I have some experience using visual basic 2005 I m doing a program to resemble vegas slot machine.. I am using 3 labels to display the numbers. There are 3 buttons. One is "START", "STOP", "EXIT". What i wont to do when i press the start button the 3 lables should start displaying various numbers(continuous changing single digit numbers). when stop is pressed labels should stop at the current number . based on the current numbers in labels, some function is executed(output is provided) What i have done
[Code]...
View 2 Replies
Jun 11, 2009
I have an application which has a thread running which makes constant calls to a server. Occasionally, the calls become unresponsive, and I would like to stop and then restart the thread.How do I do this? I can't use mythread.Abort() because then it doesn't allow me to start the thread again.
View 5 Replies