Sub Main()
Try
Dim output, filename1, filename2, filename3, date1, date2 As String
[code]....
i'm getting the following error:
in DeleteFile The process cannot access the file'c:empfilename2.doc' because it is being used by another process.
am i supposed to release any processes before deleting the files? what am i missing?
EDIT: here is my "Send Email" function that sends out the files
Public Sub SendEmail(ByVal msgTo As String, ByVal msgBody As String, ByVal date1 As String)
Dim mail As New MailMessage()
Dim objSMTP As New SmtpClient()
I ran into a problem trying to delete certain text files. 99% of the time everything works fine but every once in a while I get a problem trying to delete certain text files. The exception thrown has a lot to say so here's a screen shot of it. : Attachment 77319
Here's the code I use to delete the text files. If File.Exists(StringForTextFile) = True Then Try My.Computer.FileSystem.DeleteFile(StringForTextFile) Catch ex As Exception [Code] .....
I was thinking that maybe if you tried to send the file to the recycle bin it would always allow that. What would the correct code for : My.Computer.FileSystem.SendFileToRecycleBin(StringForTextFile)
What I want, is for my text file to be read into the array named "CFiles()". Then once this is complete to delete the file But I get the error, The process cannot access the file 'C:UsersAndrewDesktopNew.txt' because it is being used by another process. On 3rd to last line. My code is below:
What I want, is for my text file to be read into the array named "CFiles()". Then once this is complete to delete the fileButI get the error, The process cannot access the file 'C:\Users\Andrew\Desktop\New.txt' because it is being used by another process. On 3rd to last line.My code is below:
Public Class Form1 Dim File As String = "C:\Users\Andrew\Desktop\New.txt" Dim CFiles() As String
How can be find out which file is going to delete when, user provides command like DELETE or SHIFT + DELETE or by programmatically gives DELETE command. Well I know about FileSystemWatcher Class, but this class doesn't provide information before delete...
Here is the code that I am using, every time i run it i get an error message
Error Message: Syntax error (missing operator) in query expression '(((? = 1 AND BlankP IS NULL) OR (BlankP = ?)) AND (StudentID = ?) AND ((? = 1 AND Studentame IS NULL) OR (Studentame = ?)) AND ((? = 1 AND 1t IS NULL) OR (1t = ?)) AND ((? = 1 AND 2t IS NULL) OR (2t = ?)) AND ((? = 1 AND 3t IS NULL) OR (3t = ?)) AND ((? ='.[code.....
Dim xx as image xx = image.fromfile(Fileloc) picturebox.image = xx
And i can't delete the file even though I've loaded it into a picture box. If I add this line:
xx.dispose the picture box becomes a big red X. I only want to delete the images when my application is closing (they are temp files). So shall I just dispose them before I delete them?
I am trying to use a unc path to delete a folder from my own machine but I'm getting an "Authorized" error. If I change it to a non-unc path it works file.[code]....
Below is the code I have used for deletion of Data from Listview
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click If lvNotesList.SelectedItems.Count > 0 Then
I am displaying a Master-Detail tables in a DataGridView. The Master has only one table and the Detail also has only table. Both tables have primary keys. I would like to give the user the capability to delete one or more rows from the Master or Detail when they click on 'Delete' buttons. I am using VB.Net 2010, MS Framework 4.0 and Win 7. The database is Oracle 10g. I have written the following code but it doesn't seem to work. I keep getting 'Number of records updated: 0'.
Here is the code to delete from Job table (Master) when the user clicks on btnDelJob: Private Sub btnDelJob_Click(sender As Object, e As System.EventArgs) Handles btnDelJob.Click Dim i As Integer Try Dim response As DialogResult = MessageBox.Show("Are you sure you want to delete these rows?", "Delete row?", MessageBoxButtons.YesNo, _ [Code] .....
I developing a VB.net application and I'm unable to delete the record from. But my code only deletes the record from the datagridview and it is not being deleted in the database.
I'm using SQL Server Express 2008 and the table name is Admin_Table. The fields are :
Field Name Data Type -------------- -------------- admin_ID int admin_Name varchar
I am connected to a mdb using OleDb. The Connection code is : ' GET CONNECTED TO DB Try' Open a connection to the database.cn = New OleDb.OleDbConnection(strConnection)cn.Open() ' Load Data Adapteradapter = New OleDb.OleDbDataAdapter(strSelect, strConnection) ' Create Auto generated Insert, Update, Delete cmds for Tableautogen = New OleDb.OleDbCommandBuilder(adapter) [Code] .....
Add & Update are working perfectly, but delete doesn't update in the db. While application is running it shows that data is deleted, but when I run again, I see the same data, so its not physically deleting from the db. Add & Update both are working perfectly even after re-running.Can anyone tell me where am I going wrong in delete part. The row is also proeprly selected. No exceptions, yet why not deleting physically.
the way i have my code i grab values from my listview (dynamic integers that vary depending on user choices up to 6 long) then perform actions with them in afor loop, at the end i was trying to delete that value so the loop wouldn't use it again but i can';t seem to get the syntax to delete the value.
[code]...
i thought listviewIDs.Items.Remove(listviewIDs.Items(x).Text) would have worked but no
In my application, I open a "Customer Details" form and on confirming I have to delete all records from other 2 tables (Order & OrderDetails) of the database. I am not able to delete records. It somehow stops by on - ordDetAdap.Update(ordDetDs) . The code is as follows :
[Code]...
There may be N number of Orders and each order may have N number of OrderRedetails. There are rows and also shows proper data in MsgBox, also row.Delete works fine, BUT why does it stop at Update(OrdDetDs) I can't make out. Any idea where am I going wrong.
Also Is their any easy way out to delete all records using just a single statement providing OrderId from OrderDetails table ? As of there are 10 rows of a single order, then For loop will iterate 10 times and delete 10 rows, instead if I can delete all 10 rows at once would be beneficial.
I have a program which I am converting from VB6 to VB2010 this is also my first venture into sql. I have read many of the examples to try to get to grips with deleting records including those in this forum by imcilhinney
My problem is that I want to delete all but one of the records when the user presses a button, everything goes well until the 'ExecuteNonQuery' is reached.
i m using fallowing code for update, delete and save data it's working very well when i save new recored but when i update and delete recored it's showing error message "Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information."
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If thismode = 0 Then row = ds.Tables("state").NewRow() row.Item("state") = TextBox1.Text
I am using MS Access 2007 as database and VB 2008 to build an application to show the content of 2 tables as a single table.I have two tables in MS Access and i have linked both the tables using "ID" as primary key(1st Table),foreign key(2nd Table). I used Query Wizard to show the data of both tables in a single table(3rd Table).I am able to view the content of all 3 tables using datagridview in vb 2008(Using Code), but i am unable to add,delete,save and search the content of the table using code. My concern is,i will be able to do all these operations using codes only.Would you please help me out in this.
I have a Motor Class, along with a Collection to hold objects address. Each Collection object holds the Class fields as a String to display in list box. I am able to write the collection string to the file and save the string. But unable to open the existing file, read the file back into the collection object.
Public Class Motor Private strId As String Private strDescription As String
[Code]......
I have looked all over for anything (samples or tutorials for working with files and collection objects) pertaining to type of operation with out any success.
i am working on an application called logonscreenchangerxp i made my program and when i run it on xp virtualmachine i get errors the program is made using vb 2008 and using .net framework 2.0 i am not able to get full permissions to modify boot.ini file and a regisrty value and to delete a file
Below is my code for DELETE button. What i want is if the user select the transaction from the listview and press the DELETE button it must be able to delete the transaction from listview and text file(temporary log file) which i keep all the transaction record. At the same time the list view must able show the total current balance from the deleted trnsaction.
