How Do I Delete Checked Item From Listview Along With Databa

Question

How Do I Delete Checked Item From Listview Along With Database Also C# Windows

Baimey Rajesh · Answer

Vns India , any updates??

Baimey Rajesh · Answer

I dint get it what did u mean please explain

Baimey Rajesh · Answer

When u run the query on management studio, please replace the @tSymbol with the value, in single codes. DELETE FROM dQuotes WHERE tSymbol =' '

Vivek Joy · Answer

try this.. for (int i = 0; i { string strrtnval = DeleteGrid.Rows[i].Cells[0].Value == null ? "false" : "true"; int intchecked = strrtnval == "true" ? 0 : 1;//It is a turnary operator. if (intchecked == 0) { String cguid = DeleteGrid.Rows[i].Cells[1].Value.ToString(); SqlCommand cmd = new SqlCommand(); Program.StrSql = "delete datatable Where condition'"; cmd.Connection = Program.QbSysDbCon; cmd.CommandText = Program.StrSql; cmd.ExecuteNonQuery(); } }

Baimey Rajesh · Answer

Please be informed that is not the way to get the selected Item from list view foreach ( int i in Listview1 . SelectedIndices ) { string symbol = Listview1 . Items [ i ]. Text ; Listview1 . Items . Remove ( Listview1 . Items [ i ]); Obrisi( symbol ); }

Baimey Rajesh · Answer

u mean string Symbol = (listView1.SelectedItems).ToString(); is not working??

Vedant · Answer

as your last solution is working fine when i used any listview items that is deleted but when i give selected items(Symbol) its not deleted.

Vedant · Answer

please reply

Vedant · Answer

please reply

Vedant · Answer

please reply

Vedant · Answer

last one is working but only by Symbol item name; when i try for selected symbol its not working

Baimey Rajesh · Answer

Please put @ for the parameter. Check the second code snippet I send u. Please copy paste this code private void Obrisi(string Symbol) { SqlConnection cnn = new SqlConnection(Properties.Settings.Default.connection); cnn.Open(); SqlCommand cm = new SqlCommand(); cm.Connection = cnn; cm.CommandText = "DELETE FROM dQuotes WHERE tSymbol =@tSymbol"; cm.Parameters.AddWithValue("@tSymbol", Symbol); try { cm.ExecuteNonQuery(); MessageBox.Show("Deleted"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { cnn.Close(); } } private void btnDelete_Click(object sender, EventArgs e) { if (listView1.SelectedItems == null) { MessageBox.Show("Please select Class to Delete"); return; } string Symbol = (listView1.SelectedItems).ToString(); Obrisi(Symbol); listView1.Items.Clear(); } Is the message box showing any error??

Vedant · Answer

Msg 137, Level 15, State 2, Line 1 Must declare the scalar variable "@tSymbol".

Baimey Rajesh · Answer

Can u try running the query in sql management studio. and lemme know the output?

Vedant · Answer

private void Obrisi(string Symbol) { SqlConnection cnn = new SqlConnection(Properties.Settings.Default.connection); cnn.Open(); SqlCommand cm = new SqlCommand(); cm.Connection = cnn; cm.CommandText = "DELETE FROM dQuotes WHERE tSymbol ='"+ Symbol+"'"; cm.Parameters.AddWithValue("@Class_Name", Symbol); try { cm.ExecuteNonQuery(); MessageBox.Show("Deleted"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { cnn.Close(); listView1.Items.Clear(); } } private void btnDelete_Click(object sender, EventArgs e) { if (listView1.SelectedItems == null) { MessageBox.Show("Please select Class to Delete"); return; } string Symbol = (listView1.SelectedItems).ToString(); Obrisi(Symbol); } message comes deleted but still symbol fom database have not deleted. my database name is dQuotes and the column name into database is tSymbol.plz give me complete code or make a short project on that .

Vedant · Answer

try { foreach (int i in listView1.SelectedIndices) { string lvSymbol= listView1.Items[i].Text; listView1.Items.Remove(listView1.Items[i]); using (var cnn = new SqlConnection(Properties.Settings.Default.connection)) using (var cmd = cnn.CreateCommand()) { cnn.Open(); cmd.CommandText = "DELETE FROM dQuotes WHERE tSymbol= @tSymbol"; cmd.Parameters.AddWithValue("@tSymbol", lvSymbol); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } got error still delete from listview but not from database my database column name is tSymbol so plz give me complete code for that and also add search by keyword in listview

Baimey Rajesh · Answer

I'm sorry for the inconvenience. Please try the code and lemme know

Baimey Rajesh · Answer

sorry that is the connection variable. try { using ( var cnn = new SqlConnection ( ConnectionString )) using ( var cmd = cnn . CreateCommand ()) { cnn . Open (); cmd . CommandText = "DELETE FROM dQuotes WHERE tSymbol= @tSymbol" ; cmd . Parameters . AddWithValue ( "@tSymbol" , lvSymbol ); cmd . ExecuteNonQuery (); } } catch ( Exception e ) {}

Vedant · Answer

mam what is sc you are using sc.CreateCommand())

Baimey Rajesh · Answer

Notice also that because the connection is wrapped in a using block you don't need to Close it in a finally statement. The Dispose method will automatically call the .Close method which will return the connection to the ADO.NET connection pool so that it can be reused.

Baimey Rajesh · Answer

try { using ( var cnn = new SqlConnection ( ConnectionString )) using ( var cmd = sc . CreateCommand ()) { cnn . Open (); cmd . CommandText = "DELETE FROM dQuotes WHERE tSymbol= @tSymbol" ; cmd . Parameters . AddWithValue ( "@tSymbol" , lvSymbol ); cmd . ExecuteNonQuery (); } } catch ( Exception e ) {} NB: change the parameters as needed

Vedant · Answer

foreach (int i in listView1.SelectedIndices) { string lvSymbol= listView1.Items[i].Text; listView1.Items.Remove(listView1.Items[i]); using( SqlCommand cmd = new SqlCommand ("delete from dQuotes where tSymbol='"+lvSymbol+"'",cnn )) { cmd.Parameters.Add(new SqlParameter("tSymbol", lvSymbol)); cnn.Open(); cmd.ExecuteNonQuery(); //Then execute the query cnn.Close(); } } i tryed that code its executed but delete only listview item not from the database plz help me where i am wrong

Baimey Rajesh · Answer

Connecting to the database for each check box selection might not be a good idea. Still can be done according to the logic applied.

Harshad Pansuriya · Answer

chkBox . setOnClickListener ( new new OnClickListener () { @Override public void onClick ( View v ) { // TODO Auto-generated method stub CheckBox cb = ( CheckBox ) v ; if ( cb . isChecked () == true ) { String getStrinValue = cb . getTExt (). toString (); // here you will get the value of selected CheckBox // And now you have to perform your deletion operation as usual. } } You can use it for the checkbox selection ?

Baimey Rajesh · Answer

private void deleterow_Click ( object sender , EventArgs e ) { foreach ( int i in Listview2 . SelectedIndices ) { string productId = Listview2 . Items [ i ]. Text ; Listview2 . Items . Remove ( Listview2 . Items [ i ]); using ( SqlCommand cmd = new SqlCommand ( "delete from Products where ProductID=@ProductId" , connection )) { command . Parameters . Add ( new SqlParameter ( "ProductId" , productId )); //Then execute the query } } }

Arun Kumar · Answer

private void Obrisi(string id) { SqlCommand cm = new SqlCommand(); cm.Connection = conn; conn.Open(); cm.CommandText = "DELETE FROM Table_name WHERE Class_Name = @Class_Name"; cm.Parameters.AddWithValue("@Class_Name", id); try { cm.ExecuteNonQuery(); MessageBox.Show("Deleted"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); listBox1.Items.Clear(); GetClasses(); } } //Add code in the button private void btnDelete_Click(object sender, EventArgs e) { if (listBox1.SelectedItem == null) { MessageBox.Show("Please select Class to Delete"); return; } string id = (listBox1.SelectedItem).ToString(); Obrisi(id); }

Harshad Pansuriya · Answer

Here's the general path you'll have to follow. Remove the item from the ArrayList that is populating your ListView . Once that is done you will have to call notifyDataSetChanged() on the Adapter that is being used for the ListView

Vedant · Answer

but it will remove only from listview but we want to delete database record also when i select listview item.

Baimey Rajesh · Answer

Remove from list view foreach (ListViewItem i in ListView1.SelectedItems) { ListView1.Items.Remove(i); } do u want to remove from the database on each item click. or do u have a separate button to delete?