I have this question about the control triggers, I have this project that have textbox, using it's textChanged function and setting the autopostback in to true.
Now, when I trace the command I have notice that the function have been triggered twice, and I just want to know now how that happens and how I can set this to trigger only once.
I use the following code in a Sub called "updateDb" to accept changes back to the Db, etc. in the .CellEndEdit event from a DataGridView:
Try
' Write changes back to actual .mdb file
' Accept changes from DataGridView object
Me.Validate()
[code]....
Which is the most appropriate event to handle for this task? Right now I'm calling the updatedDb sub when the .CellEndEdit event triggers and when the .UserAddedRows event triggers.
Is it possible to list all triggers in all tables on a database?I can list all user stored procedures with:
Private Sub StoredPro()
Dim theServer As Server = New Server(serverName)
Dim myDB As Database = theServer.Databases("mydatabase")
Dim dt As DataTable = myDB.EnumObjects(DatabaseObjectTypes.StoredProcedure)
End Sub
But nothing obvious in SMO for triggers. (I'm actually trying to list just custom triggers, any that are not named DEL_tablename, INS_tablename, UPD_tablename) within the selected database.
the MouseWheel event triggers 3 times every time i scroll ... this i believe is because i have my wheel set in windows to scroll 3 lines at a time but i am updating a "zoom" and only want it to trigger 1ce per wheel movement any ideas?
View 9 RepliesI have a custom class. I would like to add an event that triggers when the form it is on resizes. Is there a way to do this?
View 1 RepliesI am using an activeX control to read data from an external source. This data is processed in 5 second increments. Each piece of data is passed through an event. When the event triggers I call a "decision" procedure from the event to process the data and make decisions on what to do, i.e. call other procedures, store the data, etc... This works fine when I have a small number of samples (around 10), however, when the number of samples increases to say 100, that is I am recieving 100 pieces of data every 5 seconds, the "decision" procedure does not fully run. Is it possible that the event trigger is causing the code to exit the "decision" procedure prematurely? I know that the "Decision" procedure starts since I have written data from the beginning of the procedure but not the end of it. how to handle the rapid event triggers?
View 7 RepliesAnyone know how to make the return key used in a text box trigger an event?
View 3 RepliesI am currently rewriting an Access application to VB. The database was already MySQL 5 with the Access application - solely used for the forms and reports. In access the MySQL database is accessed though ODBC, in VB via a .NET connector.
The problem is the following:
In the MySQL DB I have a trigger to create a UUID (or a GUID if you prefer) as a "Before Insert" trigger.With Access, the record creation works fine, and the UUID is created flawlessly.With VB, the record creation is stopped by VB when trying to insert/save the record - saying the DB requires the field UUID not to be null. Although this is right (it is mandatory in the record creation in the DB), it obviously does not take into account the MySQL trigger (and how could it?).How do you get rid of the validation for this field?
I have a datagridview which is populated from the SelectionChangeCommitted event of the combobox. The datagridview contains both bound and unbound data columns (see below).
View 1 RepliesIn my master page there is a submit button for the site search. On most pages this is only triggered if enter is hit whilst the search box has focus. On a couple of pages though hitting enter on the main form it triggers the search submit. I know that I could fix this by enclosing the search in it's own form tag and then changing every page to have it's own form tag, but I need something that is a lot simpler as a fix as I'm low on time. Is there a way I can tie the text boxes in the form to the correct submit button?
View 1 RepliesI found this mystifying in VB6 and it's still here...
For example - I have a combobox on a form and I have put some code in its SelectedIndexChanged event. The problem is that I want this code to be executed *only* when the user clicks on an item in the combobox dropdown. Why is it then that it gets executed when the form first loads? And how do I stop this happening?
I used to use a "FormLoading" boolean to decide whether or not the code was executed but this surely shouldn't be necessary. Is there a better way?
I have a class in VB.NET that has a method (called CurrentValue) that returns a number. There is also an event that the class raises to indicate the number has changed. In the event handler on my form, I update a textbox using the exposed method.[code]When I run this I get a "Debugger.Runtime.CrossThreadMessagingException" error. What could be doing this? I am instantiating MyClass in the same form that contains the textbox.I can also set properties of the MyClass object without any trouble.
View 1 Replies[code]I get an error that the connection to the IMAP server has disconnected because the suspend event is not triggered until the computer wakes. How do I get the trigger before the computer sleeps?
View 2 RepliesI have a program that will print dwg and idw drawings to different printers. from our drawing vault we kan use a plotbutton which creates a pcf-file (text file) and copies the drawing to a specific location. the program reads the pcf file which contains the max printsize for the drawing, who is printing it, nr of copies, location of the drawing. all data is written to or read from a small database. as long as there are drawings the printing goes fine, they are listed in a datagridview on the form. As soon as the last record is removed from the datagridview I get the following error[code]...
View 2 RepliesI have a message box with YesNoCancel button..
Pressing Yes will do some action and close the app - works fine,
Pressing No will do nothing and close the app - (see below),
Pressing Cancel will Do nothing and keep the app open - (see below).
I'm using DialogResult.No for No button and DialogResult.Cancel for cancel button. But pressing either of them triggers DialogResult.Cancel event. Whats the problem?
I'm working on a program with a fairly complex graphical interface. Due to the volume of information possible in the interface, the tooltip, or something like it, seems likely to be a fairly critical means of obtaining feedback. However, after a bit of testing, there are a few features that I am not really enamored with. First, I am changing the tooltip text dynamically based on the portion of a control that the mouse hovers over. This is done in the Hover event handler. What I am seeing is that once the hover event is raised once for a control, it appears not to be raised for that control again unless the mouse leaves the control and re-enters. Therefore, the tooltip is set based on where the mouse hovers the first time it hovers on the control, then doesn't change until the mouse has left the control.
More disturbingly, the tooltip sometimes doesn't show up at all. It appears that if I am quick enough about moving the mouse over the control, then hovering does nothing and no tooltip shows up at all. The way to get the tooltip to show up is to move the mouse smoothly, and somewhat slowly, over the control, then pause. As long as the motion is slow enough, the tooltip always shows up. However, if the mouse is then moved, the tooltip goes away, and won't return until the mouse has left the control and come back to it. So basically, First, I will look into showing something on MouseMove rather than Hover, as Hover appears to be inconsistent, at best. Yet that doesn't solve the problem that the tooltip is too inconsistent in behavior. Is there an alternative, or timing property settings for the tooltip that improves responsiveness?
I am writing a web page, on this web page there is a txtStart and txtEnd. Next to them I have Calendar ImageButtons. I would like to code it so when the ImageButton is clicked a calendar popup appears and when they select a date on the popup it goes away and the date is populated into the txt. Format MM/DD/YYYY. Can anyone help me? I have been looking online for hours now and only find solutions for C# users or for a seperate page all together. I am writing my code in VB and I cannot make new pages. Here is my web page code:
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="PSInventoryRelease.aspx.vb" Inherits="DigeControlCenter.PSInventoryRelease" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="TC" %>
[code]....
I've been searching for the answer for this all over, but I can't seem to find the solution. I have no idea how do this. A code that triggers an event after multiple command buttons are pressed in a certain order. For example: I press Command1, then Command2, then Command8, then Command5, then an event happens. It's kind of similar to entering a code to activate something.
View 4 RepliesI am trying to implement a way of persisting a collection in a custom settings class. I have successfully created the settings class (inheriting ApplicationSettingsBase) and can save properties using the built-in editors on a PropertyGrid, but my custom implementation of a property grid for collections doesn't persist any of the values I add. Here's my code:
Imports System.Configuration
Imports System.ComponentModel
Imports System.Drawing.Design[code].....
I set a breakpoint on the Set methods for both the BackgroundColor property and the EmailAddresses property. The BackgroundColor property works as it should - it breaks on the Set statement and stores the property correctly. But when I close the custom CollectionEditor dialog, the EmailAddresses "Set" method is never called. How can I get my custom editor to actually save the property once it's done being edited?
I am using/creating a DataTable so the "enforceConstrains" property is not avilable for DataTable.Error message: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Windows Form Load Event:
Private Sub Expenses_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
expensesGV.DataSource = listExpenses()
expensesGV.Columns(0).Visible = False
End Sub
I am getting below exception when i am going to enter record in a table through StoredProceduer of sqlserver i have a field which i need u update immediately after insert of new record in table. for that i created a sotredprocedure in which i wrote insert command first and after that i wrote a update command for same recored but it gave me below error SQlException: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2. Uncommittable transaction is detected at the end of the batch. The transaction is rolled back. Some Error in stored procedure execution
[Code]...
ok with this is going be realy hard to explain i just wanta learn this commands so lets say you have a combolistbox
[Code]...
i have to make a project in vb.net to connect with nokia phone using AT commands. There are so many articles on it but i hvae found nothing complete.
View 4 Replieswhy this code doesn�t work:
If CheckBox9.Checked = True Then CheckBox10.Checked = True : If CheckBox8.Checked = True Then CheckBox9.Checked = True
I'm trying to use a cell phone modem to send an sms message but i'm not sure whats wrong with my code?? Also i'm getting en error with _ContsSMS = False .. but i have no idea what that line is ? (Also are AT commands not used for Windows 7, is this why it wont work?)
Using COM7 As IO.Ports.SerialPort = _
My.Computer.Ports.OpenSerialPort("COM7")
'set command message format to text mode(1)
[Code].....
I'm fairly new here and based on the help that i've seen people give I though this would be a great place to ask! Basically, I'm new with coding, so I decided to work with Minecraft - specific a Minecraft Server Starter. It has a built in text box to display all the stuff that the console would normally display and an input tetbox to use commands.I have it so you can either use the Normal Minecraft Server or a Bukkit server. Basically, when I run minecraft.jar it works perfectly, I get the Output from the console and I can input commands.When I use craftbukkit.jar (bukkit) I get the Output of the console fine, but I can't input any commands... I can't figure out why it's doing this!
[Code]...
So I have this page as such:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ViewContacts.aspx.vb" Inherits="ViewContacts" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[code]....
and the commands are not being added to the buttons to add, edit or delete contacts....
catch statements - it works well just checking my disk drive for a file, if an error is thrown then I open the disk tray and ask them to put the disk in, click OK on the message box and it performs another check for the file, if this fails the button that starts all this is disabled on my main form (the code is shown below).
Okay, so my problem is I'd like to have the message box pop up and the have the drive open up (using an API which I have) either at the same time or in the order of: message box then drive open. I can see two ways to do this: Have the commands happen at the same time (Can you even do this?) OR Have the message box appear and then open the disk drive (but how I could achieve this I don't know as the message box waits for the user to click OK... I originally though of starting a timer just before and getting it to open the disk drive tray in the tick event,
Code:
Public Class Form1
'open cd-rom tray API
Private Declare Function mciSendString Lib "winmm.dll" Alias "mciSendStringA" (ByVal lpstrCommand As String, ByVal _
[Code].....
I wrote a program that read a text file, find some specific text and eventually replace it with other. This works fine but after the file creation I have to ftp MANUALLY to my AS400, putting the file and finally run a specific command.
Here's the question, I saw that I can use FtpWebRequest but it only permits to download, upload and so on, I need to run a custom command (passing a string).in other words here's what I need:
user = "me"
pass = "you"
host = "as400"
ftp.Credentials = New System.Net.NetworkCredential(user.Text, pass.Text)'now the connection is opened put my file send custom command
I am using mysql and I have installed the connector... here is a sample of my code. so far I can sucessfully connect to the db, but i am trying to learn how to parse sql commands to the db. for example in this snippet, i wanted to add to the testing table, an entry consisting of Fname and Lname.... It is not working... what should i be doing different ??
Imports
MySql.Data.MySqlClient
Imports
[Code].......