I have a list of registered users in gridview...
I want when i click on delete button on selected item in gridview, then the record of user will be deleted from the whole database... on single delete command of sqldatasource in gridview....
i have a databound combobox using VB2010 and MS access as the DB.. When i click on a button, the selected item in the combobox will be deleted from the database and no longer display in the combobox...
View 1 RepliesI trying to make a code to Delete and Update Access 2007 database after remove a selected item from a listbox in VB 2008. [using "Remove" button that i create] pervious i already make a button to View data from database and Remove from listbox. but i don't know how to delete and update in database.
The code i using now:
CODE:
In the database, i have ID,Name and Age (simple database)
I habe a little problem with my code. After 4 years, I must now expand and adapt an old program with new features for Windows 7.I use the great snippet from Chris to query the members of a active directory group.Now I want to use a selected item from the Listbox for a further search, but it doesn't work. I check the selction with a Textbox, but I get an error message:"Invalid Conversion from DirectoryEntry to String".[code]Until now I was able to read the selected items from the listbox in a Textbox or a query.
View 1 RepliesI am making a password program that remembers what the password is for and what the password is. I have two listboxes: 'listbox1' for what the password is for, and 'listbox2' for the password. I also have a remove button. I would like it so when you press the remove button, the selected item in listbox1 is removed and the password in listbox2 is also deleted. The passwords are stored in two settings: what, and pw. The items that will be deleted will have the same value. By value i mean they will be the same number item. E.G. the 1st item, or the 3rd item in the list.
[Code]...
Delete Selected Rowin A Data Gridview
View 11 RepliesI am creating a simple website using the language of VB.NET, I am having trouble with one part at the moment and could really use some help.
At the moment I have items that are stored in a database, when the homepage loads these items are added to a Gridview which allows the user to select the items they wish to add to their shopping cart. Once an item is selected from the gridview it is added to a collection. That collection is then added to a Session. This is the code I have for completing that task.[code]...
I have the below code that works great, until you have multiples of the same thing.example of data
burger
-tomato
+tomato[code].....
if i select the +tomato in wrap it remmoves the +tomato in burger (deleting the 1st oocurance of it) how can i fix that. i have played alot and can not figure it out.(ps the other list boxes are other data but it needs to remove the same "line" as each other. they are all changed to the same selected index when 1 is changed)
Dim value As String
Dim value1 As String
Dim value2 As object[code].....
I have a GridView with image buttons for selecting rows. I am using an OnRowDataBound event to color selected rows Blue:
e.Row.ForeColor = System.Drawing.Color.Blue
Now that works great as long as I don't set a color either in the CSS stylesheet or on the grid Items themselves. If I do that, then all rows are colored that color and I don't get my Blue selected rows color for selected rows. I would like to color the text in the grid something other than black.
How can I delete a row from an SQL database based on what item is selected in a listbox?
View 7 Replieshow do I do the code if I wanna delete a selected item from the array list and not all the items store in the array list? [Code]
View 2 RepliesWhen I run the program it will populate the listview but when i delete the selected item it will clear all of my records in my listview. . . .can anyone elp me with this??This is my code. . . .
[Code]...
I try to do a very simple job which is: Delete a row in dgv AND database! But now after three days I'm running out of steam
The problem is: I select on or more rows in dgv and push the del button. The sub zDelete starts working and at the end the selected row is gone and the row after my selection is gone too!?!? The deletion of the selected row was well done in dgv and database. But why is the next row in dgv only also disappeared??? After a restart of the form the missing row is back up again. And when I try to delete the last row it trows an exception error: System.IndexOutOfRangeException was unhandled
The code fragment is this:
'Delete all selected rows in dgv AND database!
Private Sub zDelete()
If MessageBox.Show("Do you really want to delete the selected rows?", "Delete", MessageBoxButtons.YesNo) = DialogResult.Yes Then
[Code].....
I am using Visual Basic 2008.I Have a lilstview with items from an MS Access database loading in to it. I can update, insert and delete all from the database and the listview is updated accordingly. However, I cannnot for the life of me get it to remove a row from the database based on the selected index of the listview!!!I suppose I could use a DataGridView but then I would need to add a datasource wouldn't I?
View 4 RepliesI got a gridview of data. One of the food item in the database is expired and I want the gridview to actually "highlight' it in red. The display code is as follow:
.Dock = DockStyle.None
.SelectionMode = DataGridViewSelectionMode.FullRowSelect
.RowHeadersVisible = False
.EditMode = DataGridViewEditMode.EditProgrammatically
.AutoGenerateColumns = True ' Automatically generate the DataGridView columns.
[Code] .....
I got a problem with this code for delete button. I want it to delete the row with the listbox (lstMicro) selected item in "Microscope" column. The code below gives me an error message "Conversion from type "DataRowView" to type 'string' is not valid." What did I do wrong?
[Code]...
how do i delete selected row from a datagrid connected to sql server database...?? Delete selected row and update database.
View 2 RepliesHere's my delete button
If MsgBox("You sure?", MsgBoxStyle.YesNo, "Wait..") = MsgBoxResult.No Then : Exit Sub : End If
rs = New ADODB.Recordset
rs.Open("select * from Rami where Name like '" & Me.Text & "'", cn, 2, 3)
rs.Delete()
DisplayList()
I get that error when I try to delete:Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
I am trying to get a value for a textbox from a database according to the selected item in combobox. but i had this ex.message " there is no row at position (0) "i have filled the combobox droplist from the same database table as below!
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim connstrg As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:Documents and SettingshedrisMy DocumentsREGISTER.mdb;"
Dim conn As New OleDbConnection(connstrg)
[code]....
how compare the selected item of the listbox with the database and dispaly data again in the textbox of front end
View 3 RepliesIn my application I have a listbox and SelectionMode should be MultiSimple because users need to see which items they selected. In another tab we have another listbox this one should show all the selection users had done in first tab. Private Sub
[Code]....
I have a datagrid being filled by the data adapater connected to my database.I have a delete button on the form, i cant figure out how to delete the selected row on the datagrid when the delete button is clicked.
View 1 RepliesI have a gridview that contains data from a database somewhere in a sql server, so far so good, what i want to be able to do next is delete a row when i press the delete...Am new to asp.net and vbi will send the code and a printscree of the software:
ascx
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="Admin.ascx.vb" Inherits="Admin" %>
[code]....
I want to delete record from GridView.Before to this ask for confirmation like "Are you sure to delete?"I used command field in GridView, [code] I wrote a function in javascript. [code] How I will call this on delete click.
View 4 RepliesI have a gridview that contains data from a database somewhere in a sql server, so far so good, what i want to be able to do next is delete a row when i press the delete..
i will send the code and a printscree ofthe software:
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="Admin.ascx.vb" Inherits="Admin" %>
002<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
[Code]....
I'm working on a website using VB (ASP.NET)I want to implement a password recovery code without using the controls in asp.net I didn't use ASP.Net Membership for logging in, I have MSSQL database with USER table? when the user forget his/her password, he/she enters the email then press a button to submit, then I have to find this email in the user table, retrieve the user name and password, generate new a random password, update the password with the new generated one, and finally send an email to the user with the username and the new generated password.
View 1 RepliesI'm currently working on a membership system for my web application, which is based on forms authentication from the framework.I created some users with the integrated tool, and the login is perfectly working. But now what I want to do is to give administrator the capability to create, modify, delete users.
[Code]...
I'm having some difficulty with a sorted & grouped listbox in WPF vb.net 3.5 that has an items source bound to an ObservableCollection.
What I want to be able to do is to retrieve a piece of data from the ObservableCollection items source depending on what item in the listbox the user has selected.I've almost got it working but because the listbox is sorted it does not match the index of the items source.
[code]...
As I previously mentioned, because the lstBox is sorted and also grouped the index's don't match up.Does anyone know how I can get the correct information I want from the List Source depending on the selected item in the list box?
Just started on vb.net
I have a combo box with "yes" and "no" with i select Yes i want the label2 to change the text to "yes" likewise with "no"
I've tried to code it in a logical way as possible but it just doesn't works except for the "wtf" so i think that overall my code is correct but the way i want to retrieve the selected item from combo box is wrong.
Public Class Form1
Dim aa As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
[Code].....
Ok, so I have a listview on one form, and when a button is pressed it opens up a new form with the contents of the selected listview item and it's subitems in a series of textboxes. The user can then change the data in the textboxes and either press save to make the changes or cancel to close the window. What command would I use to change the selected listview item and subitems to whatever is in the boxes?
this is the code that populates the boxes:
Private Sub Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim appeditcontents As String = main.passlist.SelectedItems(0).ToString
[Code]....