I have the following code to delete a row in an Access Database Table. It executes with no errors, but the row is not deleted.
Dim adpMasterRecipe As OleDb.OleDbDataAdapter
Dim dsMasterRecipe As New System.Data.DataSet
Dim iIndex As Integer
[code].....
I have the following code to delete a row in an Access Database Table. It executes with no errors, but the row is not deleted.
Dim adpMasterRecipe As OleDb.OleDbDataAdapter
Dim dsMasterRecipe As New System.Data.DataSet
Dim iIndex As Integer
[Code]....
I have a customer and booking data sets on my form. customer id is a foreign key in booking table .but when i click delete button. it gives me an error: The DELETE statement conflicted with the REFERENCE constraint "FK_Booking_Customer". The conflict occurred in database "photoshoot", table "dbo.Booking", column 'Cust_id'. The statement has been terminated. Its a one to many relation between customer and booking. one customer can make many bookings each booking will belong to only 1 customer.
View 1 RepliesWhy does the item I insert have "'s on it? In other words
If my textbox contains Apple Street
the record is inserted as "Apple Street"
HTML
[code]....
I am creating some basic software for our manufacturing department. I am using Visual Studio 2008 using Visual Basic.The software has a user log in. There is a form in which the choose the worker name, the item they were making, how many were made, damaged, or received damaged from the supplierHowever when they click on the "Update" button to insert the record..i get my custom message that it failed and the record is not inserted. I put a TRY...Catch... around the insert query and it didn't generate an error message.I have been following the code in the OLEDB BASICS tutorial so I am not sure what the problem is at this time.
<add name="MFCTData"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Data.mdb;Persist Security Info=True"
[code]....
my table name is "temp", and one of the field is item_id..how can i count how much item_id was added in this table...??is the code "SELECT item_id, COUNT(*) FROM temp GROUP BY item_id"it doesn't work.. i'm using OLEDB connection and can't use sql property
View 8 RepliesIf (Tech_TextBox.Text <> "9999") Then
If File.Exists(ExportFolder + "" + Tech_TextBox.Text + ".pdf") Then
txtRouted.Text = txtRouted.Text + vbLf + Tech_TextBox.Text
myFileName = (ExportFolder + "" + Tech_TextBox.Text + ".pdf")
If cbPDFPrint.Checked Then
Dim MyProcess As New Process
[Code]...
I have created an auto emailer to distribute our work routes for my colleagues. Problem is I made it easy for the management team to update the list. List is ordered by Tech Number, First name, Last name, Email address.
I have coded this in VB.NET 2008 using Database sources and drag-n-drop the table on the form. I let VB do most of the coding of the connection and text boxes. (IE If (Tech_TextBox.Text <> "9999") Then)What I would like to do, instead of using a bogus tech number as an exit. I need an 'IF Then" or 'DO UNTIL' after last record.
Just wondering if i might hit a snag in my program. Ive got 10+ users using the same files, via a Oledb to put info into an excel spreadsheet. If 2 or more people save there file at the same time will the program go into read only on one person. Normally one 3 will use the file at one time. I know Sql itself would be better to use. best way i can describe it, normally using excel if you manage to open the same file twice one opens as normal but the other opens as a Read only file, will the same thing happen if im using Oledb connections?
View 2 RepliesI hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
I have this in my form closing event:
For Each FileFound As String In Directory.GetFiles(App_Path() & "tmp", "*.txt")
File.Delete(FileFound)
Application.DoEvents()
Next
For Each FileFound As String In Directory.GetFiles(App_Path() & "tmp", "*.txt")
File.Delete(FileFound)
Next
I used to run through an ultragrid with a for each loop and that took forever, I stumbled accross this way and it's much faster but I noticed today I still have some straggling .txt files after the form closes at times. Is there a way to actually verify all the files have been deleted before closing the form?
I ran the same for each loop twice to work it out but not sure if that works or worsens it. Also, I'm not entirely sure what that application.doevents does as I initially thought it would finish all above lines before continuing but that does not seem the case. Anyway, these .txt files files are about 500KB and up to 1000 of them at any one time so it's not instant but it's still pretty fast, faster then looping through a grid.
I have an ASP.NET application which creates temporary PDF files (for the user to download).Now, many users over many days can create many PDFs, which take much disk space.What's the best way to schedule deletion of files older than 1 day/ 8 hours ?Preferably in the asp.net application itselfs...
View 8 RepliesDoes anybody know if it is possible to download email messages and send something to the email server to delete an email from the server using ASP.NET?
I have developed a program to download email information from my email server, but I can't figure out how to send something to the server to delete an email. I developed what I have using the resources at this location[url]...
I am sick and tired of all the junk mail I am getting and want to write my own program to delete emails from my email server based on criteria I create.
I have VB 3.0, VS 6.0, VS.NET 2003, VS.NET 2005, VS.NET 2008 and VS.NET 2010 Express. I have developed web sites and standalone programs using VB and ASP.NET. My experience and knowledge is not extensive, but i do have enough knowledge to create a VB program.
I want to make a very simple program that remove duplicate domain name from a txt file. First, it must have a Open file Button so that it can load list of url to Listbox.
So, the URLs will be loaded into listbox. Then It has 2 more button Start and Save button Lastly one counter to calculate how many URL in that listbox
So example.. let say I have a txt file which contains URLs
[URL]
I open this txt file and loaded it into listbox (can scroll)
Then when I press start button, it will delete the URL that has same domain name. so the output will look like this
[URL]
Then I can save the URL from listbox to my disc drive as text file
Am using grids in VB.net to display database records stored in Microsoft Access, the tables allow editing and deleting using the grid fields. Is there a way I can monitor whenever a user deletes or edits a record? I want to be able to view details of every update or deletion to certain records, such as the date and users who did it.
View 2 RepliesMy question is for admin or moderator of this site. First time I make a new post and I am able to edit my post that time only. after a day past i was unable to edit or delete my post. How to delete or edit my previous post.
View 2 RepliesI am looking for maby something I am missing here in this code. My goal is to take the current user and delete there local settings/temp/ files. However some of these files are in use by the OS and that's what im running into a problem with. Here is what I have so far and it finds the dir easly and bam that's the brick wall access denied error because there is some files in there that are in use.
[Code]....
I was looking online for a application that can delete a file more secure then. Kill(C: est.txt")Then i had a thought.Maybe i can make my own.Is it possible to make a secure file deleter in vb.net or should i look into C++
View 5 RepliesI am using this code for row deleting in gridview. It should be like this "while it deleted a row, take row number 5 with serial no 5, serial field of row number 6 should become 5. means decrementing the serial number after one row deleted." but it is not happening while I delete row no 5 with serial 5, the row number 6 remains the same.
[Code]...
I'm lending a copy of my .exe on a memory stick and because I dont completely trust them, , I would like to build in a function that as soon as my app has finished doing what its doing And the big red X is hit it will delete itself, but my problem is that i cant put the deletetion in the form closing because the prog is still running, so what should I do? Is there a way that I can get the app to close as soon as the dedicated task is complete, It will remove itself from the memory stick but if the X is hit before the process is complete the then the prog will remain.
View 14 RepliesHere's my
Dim result As New DialogResult
result = MessageBox.Show("Are you sure you want to delete " & LoadedEmployee.EmployeeFull_name & "?", "Employee deletion confirmation", MessageBoxButtons.YesNo)
If result = DialogResult.Yes Then
**code here**
End If
I'm getting the following error: Object reference not set to an instance of an object.
Is there a way to detect if a file is being deleted,
1) Using the Del key
2) Using the Shift+Del keys
3) Using the above keys from a remote computer through a shared folder
And instead of deleting move it to another folder in the same computer. Basically when a user tries to delete a file or folder it should move it to a specified folder instead of deleting it.
I want to make a fairly simple program that would prevent file deletion of certain folders andor files that i would input into the program. Say if someone tried to delete the file it would display an error message.
View 3 RepliesAdding and deleting a web part zone at runtime. I have tried all possible ways through internet but no luck.
View 1 RepliesI need to execute the following commands from my application:
Echo Y | DEL C:Folder1cache*.*
DEL C:Folder1file.abc
DEL C:Folder1file.xyz
[code].....
This is what I have for code:
Private Sub restoreDatabase(ByVal dbName As String)
Dim newDbName As String
newDbName = dbName.Substring(dbName.LastIndexOf("_") + 1)
My.Forms.portfolioGenerator.Close()
[Code] .....
It seems like it should be pretty simple, I take in a file name as a parameter, create a new name for it, delete it, then try to copy it back from an older version of the same file, and update the connection string. However, it continually tells me that "The file 'filenamehere' already exists." If I set overwrite to true then it goes through just fine, except it doesn't actually copy the file. Obviously I also check the folder, and the file does in fact Not exist...I've also checked all the file paths and what-not, they are all accurate.
I am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage. i want to check it after entering whole name
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Try
Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
[CODE]...
i just want to ask how can i trap the deletion message appears whenever i delete one item in may data entry? im using vb2008 and sql as my database.i know the code in access. does anyone know its counterpart in vb2008? here's the code in Access 2003acDataErrContinue
View 1 RepliesHow do I force users to save the current record (if current record has changed) and not let user go to the next record unless the save button is pressed?
View 5 RepliesI am developing an application that Monitors a specific folder for file changes such as modify deletion, update, etc. The only problem I have is , the application doesn't fire up File events.
Here is the code:
Imports System.IO
Imports System.Diagnostics
Public Class Form1
[CODE].............................
I was toying with a T4 template's FileManager object, when I seemed to create a ".." folder in my solution. I was puzzled, as this shouldn't really be a valid user-creatable folder,and obviously, no ".." folder was created in the file system. So, I deleted it from within the VS Solution Explorer.I watched for four minutes as the entire contents of my solution's parent directory got deleted.
View 1 Replies