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
Is this the correct syntax to delete a record from a dataset? [code]
View 4 RepliesI 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)
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.
View 5 RepliesI have a datagridview on my form which displays records from Mysql table on form load.i want to delete the selected row in datagrid from table on 'row header mouse click' event.
The 2 different codes that i tried --- deletes the record from the datagrid for a moment but does not delete from mysql table & re-appears when closed & debugged again.[code]...
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()
[code]....
Dim filepathName As String = HttpContext.Current.Server.MapPath("/CaseStudyImages/" &ID & "/")
' DeleteDirContents(New IO.DirectoryInfo("filepathName"))
[Code].....
its giving me error directory is not empty how can i delete directory having files in it
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.....
I have this 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?
When I modify and delete data in a DataGridView, I get the error:
The record cannot be deleted or changed because table 'Table Name' includes related records.
but I can add new data, only cannot modify and delete data.
I am trying to delete a worksheet from an Excel workbook. Here's my code snippet
objTargetSheet = objTargetBook.Worksheets(liTTemplateSheet)
objTargetSheet.Activate()
objTargetSheet.Delete()
why when i press the delete button the code does not delete items and if i add items the items are not added from the database.
Public Class Form1
Dim inc As Integer
Dim MaxRows As Integer
Dim con As New OleDb.OleDbConnection
[code]....
I cannot able to delete the database file. File also not in use.[code]...
View 3 RepliesI 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]....
View 3 RepliesI have a Listview and a button like this
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
[Code]....
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
[Code]...
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.
I have :
Public Class ExcelProcess
Private App As New Excel.Application
Private Books As Excel.Workbooks = App.Workbooks
[Code]....
It says Error : Expression does not produce a value. in sheet.Delete()
The Strange thing is that Microsoft API reference says that it would produce a Boolean, but it doesn't as it is a Sub and not a function.
I create a GridView. It has default three columsn. cant find the way to delete a colmn, i want only 1 column in it.how to do this from design view?
View 2 RepliesIn 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.
[Code]...
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
[code].....
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:
[Code]...
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
[code].....
when i try to delete a row . always restricting to delete on certain Table table.( DELETE ERROR tble_tombstone) message comes up.
View 8 RepliesHow 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...
View 1 RepliesI am having an issue trying to figure this out. I am writing a script editor that uses tabs (a tab control) and I want to implement syntax highlighting. My issue is that every sample I can find on syntax highlighting uses
Private Sub RichTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RichTextBox1.TextChanged
I am using vb.net 2008 and sql 2005. I am writing a program to translate data from one database to another. Basically I have two dataGridViews, the original data is automatically populated to the first and on clicking the "Translate" button the second dataGridView is filled with the translated information. I am having trouble with the syntax of passing a value from the original dataGridView to SQL and returning the 'id' of the translated data table. For instance, the original has colors stored as "Blue" "Green" etc The new tables now have unique ID's with the color name as attributes. I need to basically be able to pass dgvOriginal.rows(i).cells("color").value to a stored procedure and get the "id" field of that color. Here is what I have so far.
[Code]...
I would need some clarification on a syntax : could someone tell me why some people in their code use the following :
If Not (xxx And yyy) = 0 Then
'code
End if
instead of
If xxx = true Then
'code
End if
As an exemple : In a code I use for a listview Item Ownerdraw, it sure works like this :
If Not (e.State And ListViewItemStates.Selected) = 0 Then
' draw the listview item code
End If
but not like this :
If e.State = ListViewItemStates.Selected Then
'
End If