How Do I Delete Checked Item From Listview Along With Databa

Vivek Joy11y ago

try this..

for (int i = 0; i < DeleteGrid.Rows.Count; 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();

}

0

Baimey Rajesh11y ago

Vns India , any updates??

+1

Baimey Rajesh11y ago

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); 
}

0

Baimey Rajesh11y ago

u mean

string Symbol = (listView1.SelectedItems).ToString();

is not working??

0

Vedant11y ago

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.

0

Baimey Rajesh11y ago

I dint get it what did u mean please explain

+1

Vedant11y ago

please reply

0

Vedant11y ago

please reply

0

Vedant11y ago

please reply

0

Vedant11y ago

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

0

Baimey Rajesh11y ago

When u run the query on management studio, please replace the @tSymbol with the value, in single codes.

DELETE FROM dQuotes WHERE tSymbol =''

+1

Baimey Rajesh11y ago

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??

0

Vedant11y ago

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

0

Baimey Rajesh11y ago

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

0

Vedant11y ago

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 .

0

Vedant11y ago

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

0

Baimey Rajesh11y ago

I'm sorry for the inconvenience.

Please try the code and lemme know

0

Baimey Rajesh11y ago

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) {}

0

Vedant11y ago

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

0

Baimey Rajesh11y ago

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.

0

Baimey Rajesh11y ago

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

0

Vedant11y ago

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

0

Baimey Rajesh11y ago

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

0

Harshad Pansuriya11y ago

 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 ?

0

Baimey Rajesh11y ago

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 
}
}
}

0

Arun Kumar11y ago

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);

}

0

Harshad Pansuriya11y ago

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

0

Vedant11y ago

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

0

Baimey Rajesh11y ago

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?

0

How Do I Delete Checked Item From Listview Along With Databa

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

29 Replies