Deleting Items Of The Database?
Jan 3, 2009
I have a database(acces) with tabel questions and answers.
-->
tblquestions
questionId -> -> primary key
question -> string
[code]...
There's a combobox with questions and a listbox with questions of the chosen answer(s).I have already to add and show the questions, answers.Now I wan't to delete the answer(s) (in the listbox) of the chosen questions I have this already
con = New OleDbConnection(providerStr & dbLoc)
con.Open()
Dim command As New OleDb.OleDbCommand("DELETE FROM Answers WHERE questionId= " & 0 & " AND answer='" & lstAnswers.SelectedIndex.ToString & "')", con)
[code]...
View 1 Replies
ADVERTISEMENT
Apr 18, 2012
My program takes a checkboxed item and depending on the serial number that is present on the item on the invoice, subtracts one from the amount list I have the following in a listview on a details page which I added with the following code:
Item - Low Socks(pink)
Serial # - 34-75-860
Price - 5.89
Amount - 12
[Code]...
Right now it doesn't look like it does anything. I have tried changing my index's on my subitems to 1 and 3 instead of 0 and 2 but i figured because they are subitems that they need to be subitem index 0 and subitem index 2 since there is one item and three subitems to that one item.
View 1 Replies
Feb 18, 2010
I'm trying to delete an item from a listbox so that it wouldn't appear when i run the program again. Is there anyway you could do this.
View 14 Replies
Jul 18, 2010
i am running into some difficulty with the .NET garbage collector. i have a custom control that i need to dispose and reallocate depending on user interactions. calling ctrl.dispose() and then instantiating a new control accomplishes what i want, with the nasty exception that the garbage collector (at least, i am presuming this is the GC, since this exception will happen on it's own after the application has been idle in the background for several minutes) will then periodically throw an exception: "cannot access disposed object
View 4 Replies
Apr 23, 2012
basically i had this problem before which i fixed with this code!
'REMOVE TIME
If ListBox1.SelectedIndex <> -1 Then
Dim Box As MsgBoxResult = MsgBox("Are you sure you want to remove this time?", MsgBoxStyle.YesNo)
[Code]....
It worked perfectly, all ive done to my code since is change the way the listboc is loaded / saved, it now comes from a .txt in My Documents rather than the C drive.
It now only deleted the top value of the group selected int he listbox and not all of them as it did before.
View 5 Replies
Apr 16, 2012
I have an invoice that lists several items that one person has ordered. I want to take this invoice and every time I check the item it removes one of those from another list i created called item details. I added items to this list using the item collection in the listbox.. I have invoice one that has a pink sock ordered. when i clicked this box next to it I want my total pink socks of 12 to move down to 11... the detail page and the invoice are two separate pages.
View 1 Replies
Mar 5, 2012
OK so I did a noob screw up, I was cleaning my application and delting unused data sources and unused data bindings. Now my form is blank! All code shows up for the form and all items still show in the mainFrm.Designer.VB
View 4 Replies
Jul 16, 2009
when i had 3 text box then i did the following code and it worked for me also:
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
Dim con As OleDbConnection
[code]....
in the above code ,depending on the textbox3.text,i performed all the deletion,so it was easy now i have got a three of combo box and three text box....... i filled the combo box with the database entries.....now i want to perform deletion depending upon the selected items of any one of the three combo box........i cant get the logic of the where portion in the delete syntax.....
View 4 Replies
Jan 7, 2011
I can delete record but it only checks for the username.How bout for the password?Can I use
("delete from tblogin where username=('" & txtUsername.Text & "') AND password=('" & txtPassword.Text & "') ", sqlconn)
so that it can also validate the password?
Private Sub btnDeleteuser_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDeleteuser.Click
sqlconn = New SqlConnection("server=CHERRIE-PC;Database=yss;integrated
[Code].....
View 3 Replies
Jan 15, 2011
now i got a problem deleting records in the database
this is my code
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
[code].....
View 3 Replies
Jun 22, 2011
i am deleting from an sqlite database using the ids of the records like this the dirID is an array of the IDs Dim i As Integer = 0
[Code]...
the problem is that it dosen't alwasy delete from the database, and its not throwing any errors. Could there be a better way of deleting
View 1 Replies
Apr 28, 2012
I want to get all items from one column of database table to the combobox items.
View 2 Replies
May 7, 2010
Visual Basic 2008 I'm trying to delete a row from an Access database in my DataGridView using a coded delete button. I have an input box asking for a row number to delete. It works fine except if I have anything but an interger, leave the input blank, or hit the cancel, I get :
[Code]...
View 1 Replies
Dec 24, 2009
I've been working on a little sidebar project for fun about a casino. It may have a couple of card games like, war and eventually 5 card draw. I haven't begun any card programming yet because I'm on a screen that shows players.
View 2 Replies
Oct 13, 2011
I have a form with a listbox bound to a tableadapter. Users can select from a combox, that has a list of users in it, then click "Add" to add it to the listbox and remove to remove it. This part works fine. The problem comes when updating the database:
[Code]...
View 1 Replies
Mar 11, 2009
ive added a datagrid view to my form and ive also linked it to a database which displays the details i need. but what if i want to delete any rows(records) from the datagrid or edit. i need it to also change in the database. whats the coding? ive tried n tried but cant seem to get the code. its vb.net 2005
View 1 Replies
Dec 6, 2011
Dim Conx As String
Dim DBx As String
Conx = "Provider=Microsoft.ACE.OLEDB.12.0; "
[Code]....
View 3 Replies
Oct 1, 2011
what happens is i have a weekly salary table and once a week an administrator computes the salaries and it will be saved there, i want the delete code to delete the already saved record with the same Emp_ID as what i'm trying to save. my problem is i don't think the code i put deletes the record because it will still tell me that there is already an Emp_ID the same with what i'm trying to save..
so far this is my code..
Dim cnn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source = C:UsersFlorieDocumentsVisual Studio 2008ProjectsPayroll SystemPayroll Systemobjx86DebugPayroll_MaryRoseAn.accdb")
Dim cmd As New OleDbCommand
[Code].....
View 2 Replies
Feb 17, 2011
I have created a service that will update a table. <foxpro to mysql>Before the update it will delete all the data in a table<mysql> and then insert the record from the dataset<from foxpro> one by one.I have more than 5000 records and it is very time consuming, now I would like to ask for some idea if there is a way in vb.net to only insert the data that have been recently added to the table<in foxpro> to mysql table. Is it possible in vb.net to know what has been added in the table?
View 3 Replies
Aug 8, 2011
I have records in my datagridview (from database(ms sql server 2008 r2)). What i want to do is to insert the records selected by my datagridview checkboxcolumn and IF POSSIBLE automatically delete a record if the records to be inserted are equal to the records inside the database. (Hoping you got what I want to say.) For example. I have an A,B,C(child) that is under XXX(parent) in my database and I'll be inserting the A,B(child) again but it will be under YYY(parent). The old record in XXX will be deleted except C. I just want a possible DELETE STATEMENT These are what I've done so Far :
Insertion of record to database
Try
connectionString = "Data Source=***;"
sql_connection = New SqlConnection(connectionString)
[code].....
View 7 Replies
Apr 27, 2011
I have a form with textbox controls that are bound to the database. I have a bindingnavigator within the form, when i use the save & delete buttons on the bindingnavigator toolbar they seem to work but when i check my db nothing has changed. I have tried to work around this problem by updating the saveitem code using the code below.[code]
View 3 Replies
Nov 5, 2010
im having a problem on double execution, this is a part of audit trail on my system, the DELETE FUNCTION is working, but it aint updating, im getting an error - it says that "Syntax Error on update statement" on i tried to manually query it on my access and it is working, i bold the statements that affectes the UPDATE function
Dim burahin As String
burahin = MsgBox("Are you sure you want to delete a customer from the database", vbOKCancel + vbQuestion, "Administrator")
If burahin = vbOK Then
[code]....
View 5 Replies
Mar 15, 2012
I start my project in vb.net backend is sql server i have completed my design now i start my coding but i am confused for connectivity code whether i used dataset or datable which is good? please give me best connection code for retriving,updating and deleting data from database..
View 1 Replies
Apr 6, 2010
I used the wizard to create a datagridview and then binded a grid to an access table.Data show up fine..But I can't dete records via the bindingnavigator.Hit the delete button then hit the save button ?Data does not get updated in the backend database.My properties are set to true for adding and deleting.
View 1 Replies
Feb 12, 2012
My project involves making a table database that displays student number, surname, first name, homeroom, and grade avg. Through SQL commands, there must be functions to add, update, delete, search by field, and save records to the database.I have already set the database up just fine and displayed it in a DataGridView. Through the DataGridView, I was able to go to the "Add Query" area, and I successfully made the queries necessary for searching by field. However, when I try to do anything other than a search using the query builder (ie start my SQL command with INSERT INTO or DELETE FROM), I ultimately get the message "Failed to get schema for this query"For example, this SQL code (to add an entry to the database) worked when I was in the Query Builder (and the entry that it made is still in the database), but when I finally tried to confirm it, I got the "Failed to get schema for this query" message.Being unable to add entries to the database this way, I tried to do it with textboxes on a form. Each textbox will have one of the fields, and at the click of a button, they would be put into the table. My code is below. I do not know what is wrong withit. When I run it, my fields do not appear on the DataGridView immediately, but I must run the program again to see it. The time after, the entry is gone. So I am not sure how exactly such entries are to be saved.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
[code].....
View 1 Replies
Feb 14, 2011
I am trying to delete rows of an .sdf file using the Database Explorer utility of Visual Basic. When doing so, I get the following error message:No rows were deleted.
A problem occurred attempting to delete row 1.
Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(48 rows). Correct the errors and attempt to delete the row again or press ESC to cancel the change(s). It is correct that the data in the rows are not unique (and not supposed to be; there is no "error" to correct), but why should this prevent deleting them?
View 4 Replies
Jun 15, 2010
I have an Access table in which I connect through ODBC commands. I want to delete the 50% of data rows from it. Can anyone knows a string to write for doing that? ALARMLOG is my table. In MS SQL I tryed succesfully the following command :
[Code]...
View 10 Replies
Nov 28, 2008
I have a menu strip. In the menu strip I have something for some saved urls in the database, I called it Bookmarks. So I'm trying to fetch the items from the database and have it load in to the menu items.. but it keeps adding items and I only want them added once.
[Code]
View 5 Replies
May 29, 2009
I have created an access database which i want to search with vb.net, I tried a few thing but it didnt work as desired.
Firstly the program is suppose to display items in the database base on the criteria selected by the user. what i've succefssfully done so far is I've added a datagrid 2 combobox, 1 (searchcbo) with the columns in the database and the other (searchcbo1) will autoload the items under the column selected in and a button (searchbtn) but i have no clue of the code to put in the button. i also tried the fill method but that didnt work as i wanted to. ultimately i want a combobox with the list of columns and a textbox to enter criteria and of course a search button.
The searchbtn should act as the "WHERE" sql command, e.g. SELECT EmployeeNumber, Firstname, LastName, Phone, Location....etc FROM CallLog WHERE searchcbo.text = searchcbo1.text And display the results in the datagrid.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CallLogDataSet.CallLog' table. You can move, or remove it, as needed.
Me.CallLogTableAdapter.Fill(Me.CallLogDataSet.CallLog)
[CODE]....................
Attached image(s)
View 3 Replies
Sep 15, 2010
I have been trying my hand at this for some days now and just cant get anything to work. Below is the code im currently using to delete a row from a database table, the problem when trying to build the project line 5 is giving this error about the value con" Value of type String cannot be converted to 'System.Data.OleDb.OleDbConnection' "
Dim con As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=Customers.mdb"
Dim cnn As New OleDb.OleDbConnection(con)
cnn.Open()
[CODE]...
I have also tried using this code below, but to no success. Im basically just looking for something rock soild that i can use to accomplish this task. Been stuck on this for quite a while now.
CustDetailsTableAdapter1.Connection.Open()
Me.CustDetailsTableAdapter1.Delete(txtDelCustN.Text, txtDelCustSname.Text, txtDelCustTel.Text, txtDelCustAddr.Text)
CustDetailsTableAdapter1.Connection.Close()
View 13 Replies
