Set To Cascade Updates / And Deletes?
Dec 16, 2009
Just looking to keep application looking neat, One Form Parent / Child relation, set to cascade updates / and deletes. What I'm looking for is when the form loads the user enters some information for the parent (about 2 column out of 5), then I create a datarow with the information that I have. At this point before I actually send and update command, I would like to get the next scope identity for that datarow.
The reason is I also use that Identity as an Id number in this case a receipt number, and the user will enter detail data that is stored in the child, then calls the save function, this is when I intend to actually call the update to the database.
So the question is, Can I retrieve the scope identity for a datarow that only exist in the dataset without calling the update command and actually storing the data in the database? Or in my case creating my own auto index sub a better choice?
View 2 Replies
ADVERTISEMENT
Oct 22, 2010
how to implement UI, BL and DAL in a project the way that I see it as a requirement for some projects. The way I am able to do a project now is from a form create an object of a class in which there are properties and functions that do database selects, updates and deletes. Looks to me that doing a project like that is separating the UI from the DAL. In an update button click event I may call Obj. Delete (txtCustID.txt) for example. I don't understand the part of further breaking it down to include a Business layer; in which a vb solution is made up of three solutions.What goes in the BL?Does the BL call the DAL?
View 2 Replies
Sep 3, 2009
Because there was no aswer in Windows Forms General general forum i decide to post the same question in here... is about cascading comboboxes in vb.net.. Could somebody give me a guideline how to stop previouses selections of dissapearing when another selection is madein a new row... [URL]
View 2 Replies
Mar 20, 2010
I'm developing an app in VB.Net (Visual Studio Express 2008, on Windows Vista) that connects to an Access relational database. The database has 3 related tables (TextSections, LineItems, Cycles) that I'm loading into my dataset. I've set up two foreign key constraints and want all changes to cascade through the related records in the child tables. I cannot get the cascades to reflect through.
For example, when I delete the parent record, the children records remain (in the database - they are removed from the dataset). Also, when I modify the parent record (change the Description field for example), the change is not reflected in the dataset datatable that holds the children records - unless I go through and ReLoad all of the data from the database and re-Set the constraints. I have set the .AcceptChanges, .UpdateRule, and .DeleteRule to cascade, and have also set EnforceConstraints on the dataset. Why aren't the changes cascading through the children?
Below I've pasted (1) the Load Routines for my datatables TextSections (parent), LineItems (child), and Cycles (child of LineItems); (2) the method that creates the constraints in the dataset, and (3) The Save routine for TextSections.
Friend Sub LoadTSTable()
Dim key(1) As DataColumn
Dim newCol As New DataColumn
[code].....
View 1 Replies
Jul 20, 2009
I am pretty new on programing and for the past 2 days Iīve been trying to paint a table grid based on the selection made on 5 combo boxes. My problem is that I am trying to fill the combos based on the selections made on the other combos and really I am going insane. I have found a couple of examples that show how to do this using JavaScript but I donīt think this is the best solution. i would like to do this using a stored procedure which I think is more efficient. My db is on SQL 2000 and I am using asp for server script.At the moment all i have is this, which really doesn't do very much, all it does is composing the where clause so that whe i call the stored procedure if filters the results based on the combos, but ofcourse the combos are at the moment static: [code]
View 4 Replies
Jun 3, 2009
CAN ANYBODY GUIDE ME HOW TO USE CSS IN ASP.NET APPLICATIONS USING VB.NET.
View 1 Replies
Mar 11, 2012
I've got a collection of a type of form and multiple of these can be displayed on the screen independently at the same time and now I'm wanting to add the ability to cascade these forms, but these forms can all be re-sized so it'll be very rare when they are of the same or similar size. I would like to be able to cascade them based on their present size, so the largest for is in the back and the smallest is in front.
I also realize that a form could be wider than than another form but that other form is taller than the current one, in which case I would like the taller form to be considered the larger one (an arbitrary decision, I know). Here's the code I currently have that cascades them in the order they are in the collection, I just need to know how to re-order them based on their size.
[Code]...
View 5 Replies
Nov 6, 2009
I have an MDI application where the child forms are set to sizeable, but when I hit the cascade option the forms are resized. Other than setting the forms to a fixed size is there any way round this?
View 2 Replies
Apr 29, 2011
I have to develop an exe, which should remove my application folder
View 2 Replies
Jan 24, 2012
I have two (2) variables in a textbox (L7B) and (D2B).
TextBox3.Text = (L7B) &
" " & (D2B)
I want to write over (L7B) without changing " " & (D2B).I have been using the TextBox3.Text.remove command with success however in this case there are just too many scenarios. (D2B) isn't the same number of characters so I would have to determine the number of characters to remove in each scenario.
To write over (L7B) I thought I would try TextBox3.Text.remove ((L7B)). To my amazement VB accepted this command but when I run it it removes " " & (D2B). How is it removing the wrong variable? I could understand if it didn't work at all, after all that's what I expected to start but to delete the wrong variable !! why?
View 5 Replies
May 7, 2011
I set up a test harness by checking for and then deleting records added to the db in the previous testing session, and then I test my recording adding code by adding back the same records.Interestingly this code works fine when there is a break in the debugger, but fails with a "duplicate key" exception when I let it run with no breaks, which leads me to believe there is some kind of concurrency issue.The basic metacode is as follows:
DoTest()
dim j as datacontext
dim recs = from myrecs in j.mythings select myrecs where myrecs.key="key1" or
myrecs.key = "key2"
[code]....
I've confirmed that I'm properly deleted the previous added records, and this works fine as does adding the new records when I have a break in the code before I hit the add records step. but without the break, it throws duplicate key exceptions in the "addrecordestomytable" method suggesting that it hasn't grabbed the current version of the table when it creates the new data context in addrecordstomytable, even though the records should have already been deleted.I've tried refreshing the table, but this doesn't seem to work either.Note backing database is ms sql server 10?
View 1 Replies
Oct 10, 2009
I want to make a program that deletes file(s) i ''Trash'' in VB08. If you know some codes just reply.
View 15 Replies
Aug 4, 2009
I need to write a program which deletes itself while running...How to do in vb.net and what is the concept to do it..
View 4 Replies
May 15, 2011
I try to do a very simple job which is: Delete a row in dgv AND database! But now after three days I'm running out of steam
The problem is: I select on or more rows in dgv and push the del button. The sub zDelete starts working and at the end the selected row is gone and the row after my selection is gone too!?!? The deletion of the selected row was well done in dgv and database. But why is the next row in dgv only also disappeared??? After a restart of the form the missing row is back up again. And when I try to delete the last row it trows an exception error: System.IndexOutOfRangeException was unhandled
The code fragment is this:
'Delete all selected rows in dgv AND database!
Private Sub zDelete()
If MessageBox.Show("Do you really want to delete the selected rows?", "Delete", MessageBoxButtons.YesNo) = DialogResult.Yes Then
[Code].....
View 3 Replies
Feb 24, 2012
So I have been working on this small project for a little while now Basically I need this program to be able to delete a single folder or multiple folder depending on the text in the textbox.So far, I can do the single file just fine, this is the code for that.[code]Simple as it sounds...I haven't figured it out...then again I am pretty new to VB, being I started programming in it literally 2 weeks ago.I am guessing that I have to set a variable for the textbox...which leads me to believe I need to use something other than a textbox to do this...I was thinking of using a DataGridView...I not sure how I would make it check if there is anything in a cell then delete it if there is.
View 13 Replies
Aug 28, 2010
Frontend: Visual Basic.Net VS: VS 2010 .net Framework: 4.0 Backend: MySQL 5.0. Everything is working well, add/edit/save. I am using datasets to manipulate the database the forms are created by wizard and i drag and drop the details over the form. The Problem: I delete a record on the form, it disappears (it deletes it from dataset i think) but i go to the database it is still there also if i close the form and re-open it the records re-appear.
There is something i do but it raises an error, after deleting the records i hit the save button,the following comes up. Transaction has already been rolled back or is not pending after that the records are really deleted.
View 2 Replies
Apr 2, 2009
We were working with a VB.Net app that contains something like 2200 VB modules/forms/classes and got a not-uncommon error message when we went to compile it. (Didn't write down the exact message, but it's basically unable to copy an image file that's in use.)Problem, of course, is that not everybody got out of the app when we told them to. Like I said, not uncommon. (It's a shared app that runs from a server.)Now, the weird thing. After kicking the offenders out, when we recompiled the program the image, which we use on search buttons, was gone. The file was still there but all of the property settings that referenced it were gone. Looked into the Designer code & they were gone from there, too. Seems to me that a compiler should *mark* the code that won't compile, not delete it.Anyway, I only see two courses. Either we restore our app from a backup, losing all our changes, or we go thru all the forms (like I said, there are 2200 modules-not sure how many are forms, but it's a bunch) and manually replace the properties on all the search buttons. Either way it's going to cost us at least a day's work.
View 2 Replies
Jul 27, 2009
I have a manually created a dataset (dsPickingList) that I add data too as the user inputs data on a form. There is a datagridview on my form of which it's datasource is set to dsPickingList.What I would like to do is spot if a user deleteds a row from the datagridview and update the dataset (dsPickingList) as it is ultimatly this dataset that is stored to the db and printed, not the DataGridView.[code]This is why I need the action from the DataGridView to update the dataset
View 1 Replies
Apr 9, 2011
I have a delete method for a binary search tree that only deletes the last two values that were entered in, and when it tries to delete anything to the left of the root or even the root itself it returns a null pointer exception.
Public Function Delete(ByVal key As Integer) As Boolean
Dim current As Node = root
Dim parent As Node = root
Dim isLeftChild As Boolean = True
[Code]...
View 4 Replies
Jan 20, 2011
I am trying to make a program that deletes all setting made by using the SaveSetting function. I don't use the MySettings class as it makes a setting for each user. This is basically what I need it to do:[code...]
View 9 Replies
May 25, 2011
I would like to know how can I make an executable file wich deletes itself and the folder it's inside.
I've tried launching cmd, making it wait for 3 seconds and then delete the directory, but it does nothing. The last lines of my code are:
Process.Start("cmd.exe", "/C ping 1.1.1.1 -n 1 -w 3000 > Nul && DEL /F /S " & Application.StartupPath)
Application.Exit()
View 1 Replies
Nov 27, 2009
ive been wanting to put some kind of self destructing code in my application that deletes itself after a given period of time. (like 2 weeks)
View 3 Replies
Jan 21, 2010
I am trying to write a program that deletes temp files from my entire c drive. windows 7 will not allow any file manipulation. access denied . everything works fine in windows xp. what needs to be changed in my code to allow anyone to install this program on their computer and run it without errors like this. I need to change my code to correct this not windows 7, as other people will be installing this on their systems and they can't be setting their c drives. every answer i've found online is either to change c drive to have no security or set the code to demand uac to run as administrator(which doesn't work )
View 7 Replies
Nov 20, 2009
Several times while debugging a VB.Net program I have found that continuation lines are missing from a subroutine designed to handle an event. The continuation character "_" is there but the following line is missing
[Code]...
The first few times I figured I had made some editing error, but this has happened 3 times now, always in the same way (different subroutines but same place). As far as I can tell, no other continuation lines have changed. Is this a bug or some feature I have missed?
View 2 Replies
Sep 24, 2009
i want to make a virus remover/scanner tht deletes files og scans for virus.. Just reply i you know some of codes or if you have a project.
View 15 Replies
Sep 24, 2009
i want to make a virus remover/scanner tht deletes files og scans for virus.. Just reply i you know some of codes or if you have a project.VB2008/2010..
View 11 Replies
May 31, 2011
I have a database with 2 tables. One is a table with persons and one of the entries is also saved in another table.
tblKandidaat = person info (Bedrijf, Naam, Status)
tblBedrijf = Companies (Bedrijf)
I have a listbox (lbxBedrijf) that is filled with the companies (Bedrijf) from tblBedrijf.I want a button (btnWisBedrijf) that only deletes the company (Bedrijf in tblBedrijf) if it doesn't excists anymore in tblKandidaat (Bedrijf).
View 1 Replies
Dec 15, 2011
I am currently working with a vb2010 front end with access as the database. everything works for accessing the information adding information. But when I try to edit/update the contents of a row I find that the update is being applied to the first row of the table rather than the target row. i have tried using the ID as a way to specify the row i want updated but that doesn't appear to work.
UPDATE ExamContent
SET Question = ?, ExamsText = ?, [Answer 1] = ?, [Answer 2] = ?, [Answer 3] = ?, [Answer 4] = ?, CORRECT = ?, LastEditUser = ?, LastEditDate = ?
[code].....
View 4 Replies
Sep 30, 2009
I know there are several ways to publish updates but I would like to know the best way to do it. What I already have configured is a shard network folder which I intend to have the program update from there. What would the best way to publish updates to the folder be?
View 1 Replies
Apr 29, 2009
In the following code, TextBox5 reports conditions while the mouse is moving over the form, and TextBox7 reports only when the mouse has STOPPED moving over the form. When I start the program, and move the mouse from outside the form, onto the form and don't stop the mouse, the coords continually update in TextBox5 as expected. When I then stop the mouse, TextBox5 clears and TextBox7 reports, "Mouse Hovering", also as expected. Then if I start moving the mouse again, TextBox7 clears, and TextBox5 starts displaying mouse coords again, as expected.
[Code]...
View 12 Replies
