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.
I have a small application which has a MS Access as backend, and the front end is developed using VB.Net 2008. When I click on the listview item and then click delete button to delete a particula list and its content on the database, it is giving me the error as "No value given for one or more required parameters". My access database have a Primary key as the first character of the firstname combined with the first 2 characters of the lastname. It does not have a Anutonumber fiels. My code for the delete button is as follows: the code was working fine on a MS Access that has a Primary Key as the AutoNumber being generated.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click If lvData.SelectedIndices.Count <= 0 Then
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()
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] .....
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
my deletecommand delete all my rows whenever i delete a row..but when i view it again the other rows still there and the i deleted is actually deleted.[code]
*WeightCheck is a dataset connected to a mdf SQL server file..Datagrid on form is bound to the dataset..This code executes because datagrid on form updates with the deletions..[code]
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 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)
My apologies I have posted this in the wrong catagory It should be in VB.net, my mistake)Hi guys I posted this question at the end of another topic I started but I think it will be over looked as the origional topic was solved of the dreamincode community You must all be getting sick of my quexstions by now haha I suppose you don't learn if you dont ask.
Anyway I have used the delete sql method to delete data from a database, I want to refresh the data in the form after the record has been deleted. Do I have to close the form and then open an new instance of it? or is there another way I can refresh the data?
So what I'm looking into doing is be able to add items into a listbox (which is easy), and when the user selects an item, depending on the item, it'll update labels which are on the same form as the listbox(not sure how to do), and then the user can "use" the item they've selected, and it's removed from the listbox, UNLESS there are multiple of them.An analogy to make this easier to visualize would be this:
There are two forms, frmMain and frmInventory (where the list box and labels are located).In frmMain, the user gains a potion (in this case, let's say three potions, kill two birds with one stone).
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 datagridview i use to load alot of klients into a combobox. The values of the datagridview is a connection to a MySQL db.
What it's suppose to do, is to: When clicking the combobox, it should make a list from the datagridview, getting all the names from the klients.
My problem is that it gets dublicated, and will use to much memory at a moment.
I've tryed to check if the item it was about to add allready existed in the datagridview, if it was, it shoudn't add it again, however my code failed, and I'm having huge CPU and RAM useage when running this problem for more than 30mins.
My code:
Private Sub loadCustomers() SQL = "SELECT * FROM kunder;" Try
[Code].....
The code above is only checking for dublicated in the combobox, And I want the code to also check for dublicated items in the datagridview.
Or a way to clear the datagridview right after the items are inserted into the combobox?
How is it possible to delete all the items from a ListBox that have the same extension? This is in particular to video files that have have extensions of .mpg, .modd and .moff. I can populate the ListBox with just the .mpg files but I would like to know how I can remove the other file types should I put the whole lot in.Also, presumably using similar coding, it it posssible to highlight all lines with a particular extension?