I'm having difficulty understanding how to set up a simple trigger. I have two Tables, "Customer" and "Order" Both tables have a "CustomerID" field, where the one in "Order" points to the ID in "Customer". When a record from Customer is deleted, I want all records in "Order" deleted where the CustomerID is the same as the one being deleted from "Customer". Trigger for the Customer Table that would do this?
View 1 RepliesI'm working on a Free, Open Source Multimedia player. I'm hoping if I do it right, I can have it beat out WMP and iTunes. As this is the case, I'm trying to program the whole thing without connecting to either WMP or iTunes through COM or ActiveX, and not use any of the .dlls.One of my current problems is that I can't seem to figure out how to setup a "Library" function. What I'm thinking right now is I want to setup a database, and then connect to it. I was able to create a Local Database, and setup my Table and Fields, but I don't know how to connect to the database; I figured out how to create a new instance of the table, but those get deleted as soon as the program is closed.If anyone has a suggestion on how to do this, or a tutorial they can point me to, that would be fantastic. My only stipulation I have is I'd like to be able to use SQL searches on the database, to make searching for song faster.
View 3 RepliesI have a main form that has a dynamically generated treeview and also a panel control. Depending on the selection made within the treeview the panel docks 1 of three diffrent usercontrols which are full sub forms(done for ease of modifing design of sub form rather than layering panels on top of panels).Upon button click withing usercontrol i wish to trigger event within main form.For example delete button wich then triggers to remove current selected node from treeview. code for 1 of three diffrent user controls
Dim ctrlQ As New QuoteUC(TrViewQuotation.SelectedNode)
PnlSubFormDock1.Controls.Add(ctrlQ)
Code for delete button for which i need to raise event.
If MsgBox("Are you sure you wish to delete this customer ?", vbYesNo, "Delete Record") = vbYes Then
Deletecustomer(n)
End If
i have to develop a software for motorola mc9090 that reads barcodes and rfids simultaneously, so i need to catch two different triggers: the one on the keyboard for barcodes and the other in the backside for rfids.the problem is that i didn't find any sample that illustrates how to set the trigger to read only barcodes, i found something on emdk 2.5 samples that shows how to set the trigger to read rfids but nothing for barcodes. So when i press any trigger the barcode reader is always enabled with rfids reader.Does exist a way to manage them with separated triggers?
View 1 RepliesI want to create a real setup project for my application so when someone want to download it he can run only setup, not default setup that provide me VB . How can I do that?
View 4 Repliesadd serial number requirement to Setup & deployment > setup wizard for VB.net application
View 16 RepliesI am using VS 2008 VB and setup my application software in Win XP without any issue. But after installed in Win 7, it doesn't work well (it show one file not found, but I saw the file in the right folder). Could it be the incompatibility of VS 2008 and Win 7? If I upgrade to VS 2010, will the issue be fixed?
View 10 RepliesI'm a Visual Basic beginner. There are many things that I didn't know about Windows software development as I've been a Mac user for 20 years and just started developing Windows programs several days ago.
Anyway, using Visual Studio Installer (File > Add > New Project > Visual Studio Installer), I have two files inside the Release folder - setup.exe and Setup.msi. I've got some information about these files. So when you publish your software, what do you do with these two files? According to one web site, you can put them together into one with IExpress, which produces a file with an extension of CAB. Another web site suggests SFX Compiler. In the meantime, I downloaded a dozen applications at Download.com earlier. If I click on the download button, the final delivery extension is .exe on most of them. I know that you won't go anywhere by double-clicking on setup.exe from the Release folder without Setup.msi. Meanwhile, Setup.msi is a tand-alone application. But nobody uses this file alone to distribute their product.
I've finally got a project compiled and tested and ready to roll out.I have discovered that the "Publish" option is not what it seems, and that we must create a separate "Setup Project" to carry out the task of installing the files.This is not the most intuitive process I've seen, and the online help on that subject is not easy to understand.I was hoping that someone could direct me to a tutorial or guide that would step me through the specific approach I need. Many of the other guides online are vague and address multiple scenarios and do not separate the approaches very well.I have the contents of my project in /bin/release. It runs nicely by iteself with no errors.Here's what I need:
1. To create a setup exe that I can distribute that will install my software, with all of the supporting (resource) files and folders.
2. I need the setup process to force the installer to "agree" to a EULA.
3. I'd would like to provide an image on the installation screen/popup.
4. I would like the software registered in the registry and rely on it being there in the registry.
5. I need it to default to program filesprojectname (it does by default)
I hv deployed my project using "Setup and Deployment" wizard. I hv installed MS VS.NET 2003 Bootstrapper Plugin -> A plug-in for creating deployment projects in Microsoft� Visual Studio� .NET 2003 that contain the .NET Framework version 1.1 and/or Microsoft Data Access Components (MDAC) version 2.7. still it is giving the error The setup requires .NET Framework 1.1.4322. Install the .NET Framework and run the setup again. The .NET Framework can be obtained from the web. Would u like to do this now?
[Code]...
Setup and deploy for my project worked fine for a while allowing you to install my program and uninstall the old version, but now it installs two entries. I don't get it, before I got it do do that it would give an error that it needed to be uninstalled first. Now like I said I get two entries in the programs uninstall window. RemovePreviousVersions = true. I change the version number and update the product code. Even tried changing the upgrade code. I just don't get why it doesn't work anymore, and its really annoying! Also, is there a way that the setup file can just be one .exe rather then a setup file and a data file?
View 2 RepliesI want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
does anyone know the actual code to put into the my.settings file for this? or something like that I saw it in a post now I cant find it again 0_o .
View 13 RepliesI have created a Trigger in VS2009 in VB.net. I have used a SQL Server Project. Now I have successfully created this Trigger:
' Geben Sie fr das Ziel eine vorhandene Tabelle oder Ansicht ein, und heben Sie die Auskommentierung der Attributzeile auf.
<Microsoft.SqlServer.Server.SqlTrigger(Name:="myTrigger"
, Target:="users"
[CODE]...
I am using Expresion Blend 3 and created a new user control in my project. I want a storyboard to run if a custom property of that user control is triggered like with the ones shown here in the list..
I learnt you need a dependency property, but my understanding there is limited. Here's the basic code I set up with property "IsAwesome" as an example[code]...
This is my very first trigger and I'm not sure I have it set up correctly. I have a table called PayTypes. Here is my trigger syntax:
[code]...
I run this with a breakpoint on the first line, update my VB.NET datagridview (which updates and saves just fine), but the breakpoint never gets hit. Am I going about the setup of the trigger incorrectly?
This is my very first trigger and I'm not sure I have it set up correctly. I have a table called PayTypes. Here is my trigger syntax: ALTER trigger payTypes_trigger on PayTypes AFTER INSERT, UPDATE, DELETEs PRINT 'AFTER TRIGGER EXECUTED SUCESSFULLY' I run this with a breakpoint on the first line, update my VB.NET datagridview (which updates and saves just fine), but the breakpoint never gets hit. Am I going about the setup of the trigger incorrectly?
View 8 RepliesMaybe there is a better way to do this. The jist of I want is to have SQL Server raise me 2 types of errors: a WARNING and an ERROR from a trigger when I update a table. If SQL server returns a WARNING the trigger should COMMIT but show the warning to the user (using .NET - preferably through a SQL Exception which is only raised if severity > 10) and if it is an ERROR the trigger should ROLLBACK and show the ERROR to the user (through a SQL Exception).My attempts (needless to say this isn't working) at this was to have a trigger like this:
ALTER TRIGGER [dbo].[TR_TRANSACTION_UPDATE]
ON [dbo].[tTRANSACTION]
FOR UPDATE
[code]....
If I have my cacheduration set to some value for my Web Service, is it possible to force the function to trigger?
View 2 RepliesI have a CRM application that I would like to programatically post new records and updates to, based on values in other tables getting inserted or updated. Problem is because of how this CRM app was designed I cannot use straight SQL insert/update SQL commands. This is because the database has some proprietary account#/record ID generation algorithm, and also writes to a log table using some pretty cryptic looking values.
The only way to ensure the integrity of the data is to use a the COM based API they provide. How can I send calls to this API from SQL Server code, I'm guessing a CLR user defined function? Can anyone point me to such tutorial on the web?
The updates I am making MUST be in real time, that is why I need to use a trigger that calls this app's API.
trying to get my app to trigger som events on a keypress (lets say left arrow) when my form is not in focus.I've google it bu all i can find looks very complicated, is there an easer way of doing this?Or is it a very complicated thing to do?
View 3 RepliesIs it possible to highlight a row in a datagridview using mouse events. I am assuming that I can use the following in some sort of MouseOver or MouseHover Event: Would have to translate mouse position relative to row into a row index number of x.
[Code]...
I have this code in my ViewProductsInventory (which is called from my MainForm by ShowDialog):
Private Sub ViewProductsInventory_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.Tb_inventory_datesTableAdapter.Fill(Me.InventorySysDataSet.tb_inventory_dates)
Dim inventory_date As Date
inventory_date = Me.cboInventoryDate.Text
[Code] .....
Upon clicking the editbutton will execute EditForm.ShowDialog()
And in my EditForm the record will be updated, after which will trigger ViewProductsInventory.btnSearch_Click( ViewProductsInventory.btnSearch, EventArgs.Empty)
And then the error "Conversion from string "" to type 'Date' is not valid" occurs.
I tried Msgbox(Me.cboInventoryDate.Text) and returns nothing. I'm assuming that my cboInventoryDate is not being populated at this time therefore when btnSearch_Click is triggered it receives nothing.
Am displaying list of available documents in the data grid which are retrieved from the database. Once we click on a specific one then it will retrieve PDF document from the server and display it in the browser.Currently, if I click a document from the list in the datagrid then it will display the PDF file in a new browser. Here is the code for that :
ds.Tables(0).Rows(i).Item("DOC") = "<font color=blue onmouseover=""this.style.cursor='hand';"" title=""Click for PDF"" " + _
"onclick=""location.replace('index.aspx?Name=" & link & "')"">" & docNum & "</font>"
[code].....
I try to sent an event to trigger the parent.Why doesn't the event arrive?Event is public Handler added to parent.
View 3 RepliesWhat should I do to trigger an application (wpf in vb.net) to look for updates?
View 5 RepliesIn .NET I have a class called Caption. I have another class called Gauge. Within the Gauge class I have a property defined as a Caption.I am trying to figure out how to do thefollowing:When a certain property is changed in my Caption class how do I get it to execute a subroutine in the Gauge class? I am thinking I have to declare an event and AddHandlers to fire it off, but I can't think of how to accomplish this.
View 2 RepliesI am trying to build an add-on for some software. they are done using vb.net
I want to trigger an event called project selected but dont seem to get the option.
Ive selected the control but the event doesnt appear in the options list i can override the event by doing a Addhandler myControl.ProjectSelected, AddressOf newEvent is there any way in my newEvent method to run the orginal ProjectSelected event ??
My mainform is a MdiParent.On there i use for example 2 forms.If both are on the mainform, i want that one of the forms checks if the other form is open and if this is the case he must send an update.Sofar i have this in the first form:
'If the form 'FinishRepair' is open, send update for the iriscode
Dim frm As Form
For Each frm In My.Application.OpenForms
[code]....
So in the first form, i want that the public sub is activated when he finds the form.
What code do I use to trigger something when I have focus at a textbox and presses R-Ctrl?
View 6 Replies