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.
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.
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.
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?
I 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?
I 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).
In 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?
I 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.
[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?
I 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]...
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:
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.
[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
I 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:
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
I am a newbie of using a vb.net. And I am eager to know everything around. I have a problem that seems hard to find for. I would like to retrieve data from database using drop down list, and select only the fields that i want to retrieve from it.
DesignationTable From my table i like to display only two in my drop down list
I have two linked tables in my database (access), one is for the student and one is the ages(selection drop list ).
When I have transfered the data in vb form, a simple text box is shown with numbers in it. How can I have the drop down list shown with the data I need instead of the numbers?
I've got a list box and I want to save it to a database. I've tried treating it like a normal textbox with a max string length of 50. However this doesn't work for some reason.
Does any one know how to save a list box to the database, and preferably with a variable length, although the latter is not a necessity.
I am creating a rather simple program to do nothing more to show a row form a database when the form loads, the program consists of 2 forms, form one has nothing more than a label and a button to load form 2, form 2 has a listbox where the database row is listed and a button to close form 2 and reshow form 1. The code i have so far is [code]...
i have a windows form with controls that i have associated with a database. all controls display the correct value but i'm having problem with 1 of them. i have added a listbox (not even sure if that is the correct control for that) where i want to display the list of the first column from the database. i want the listbox to display all items so when i click on one item, the other controls will be updated with the information about that item. i know the connection to the DB works because all other controls have the values from the first item. only the listbox is empty.
I have a requirement for a form where user can add a list of 'documents'. These could be word, excel, images etc... pretty much anything. They want a form where they use the openfiledialog to locate the document and then want the list of documents stored on a database.
However, when they view this form they want a preview of all of the listed documents and the ability to print them all. I was considering a datagrid view with image cells but how would I show a word document in there? Or, should I insist that they convert all documents to PDF's?
We have a project to make using the MS ACCESS as our database and VB.NET. The project called "ELECTRONIC DICTIONARY". I got trouble creating the code for retrieving the data in the list view of the VB.NET. please help me how..teach me what's the right codes for it. Here's my code:
[Code]...
IS this the proper code for this?We are required to retrieve only the WORDS in the database in list view. But we need to load the information of the books also.Admin Edit: Please use code tags when posting your code. Code tags are used like so =>
