如何从C＃.Net中的数据库删除值对应于选中的复选框 [英] How Do I Delete Values From Databse In C#.Net Corresponding To Checked Checkboxes

问题描述

  public   void  btn_delete_Click（对象发​​件人，EventArgs e）
 {
  //   dataGridView1。 Rows.RemoveAt（dataGridView1.CurrentRow.Index）;  
 
  int  selectedIndex = dataGridView1.CurrentRow.Index; 
 字符串 selectedOrderID =  ; 
  if （selectedIndex >  -1）
 {
 dataGridView1 .Rows.RemoveAt（的selectedIndex）; 
 
 
} 

这是从datagridview删除行的代码...它正在删除datagridview中的行被检查但是它没有从数据库中删除行...如何从已检查复选框的数据库中删除数据..plz help

解决方案

你好，



您要从datagridview中删除行，而不是从数据库中删除。



尝试这种方式

 int selectedIndex = dataGridView1.CurrentRow.Index; 
 String selectedOrderID = dataGridView1.CurrentRow.Cell [0] .Value.ToString（）; 
 //如果orderid是零索引

现在制作一个查询来删除来自数据库的数据。

 string sql =DELETE FROM Table1 WHERE OrderID = @selectedOrderID; 
 
 SqlCommand deleteRecord = new SqlCommand（）; 
 
 deleteRecord.Connection = connectionstring; 
 
 deleteRecord.CommandType = CommandType.Text; 
 
 deleteRecord.CommandText = sql; 
 
 SqlParameter RowParameter = new SqlParameter（）; 
 
 RowParameter.ParameterName =@ selectOrderID; 
 
 RowParameter.SqlDbType = SqlDbType.Varchar; 
 
 RowParameter.Value = selectedOrderID; 
 
 deleteRecord.Parameters.Add（RowParameter）; 
 
 deleteRecord.Connection.Open（）; 
 
 deleteRecord.ExecuteNonQuery（）; 
 
 deleteRecord.Connection.Close（）; 
 

并最终通过再次从数据库加载数据来刷新datagridview。



感谢

animesh

请参阅以下链接，以便从数据库和gridview中删除行： -

< a href =http://www.aspdotnet-suresh.com/2011/02/how-to-delete-multiple-rows-in-gridview.html> http://www.aspdotnet-suresh.com/2011 /02/how-to-delete-multiple-rows-in-gridview.html [ ^ ]

HTTP：// social.msdn.microsoft.com/Forums/en-US/90334fcb-adec-4e9a-9148-763eed1fbb33/help-how-to-delete-row-in-datagridview-based-on-checkbox-selection-in-c [ ^ ]

http://www.aspsnippets.com/Articles/Delete-multiple-rows-in-GridView-with-CheckBox-selection-and-with-confirmation-in-ASPNet.aspx [<一个href =http://www.aspsnippets.com/Articles/Delete-multiple-rows-in-GridView-with-CheckBox-selection-and-with-confirmation-in-ASPNet.aspx\"target =_ blanktitle = 新窗口> ^ ]

http：/ /www.c-sharpcorner.com/forums/thread/137021/__cs_myImageUpload.aspx [ ^ ]

试试这个：



第1步：为d编写存储过程获取记录。

步骤2：使用存储过程在代码后面添加新函数进行删除。

步骤3：从datagridview中删除btn_delete_Click事件后调用删除函数。

public void btn_delete_Click(object sender, EventArgs e)
     {
          //dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index);

           int selectedIndex = dataGridView1.CurrentRow.Index;
          String selectedOrderID = "";
         if (selectedIndex > -1)
          {
             dataGridView1.Rows.RemoveAt(selectedIndex);        
            

         } 

this is code for deleting rows from datagridview...it is deleting rows from datagridview that are checked but it is not deleting the rows from database...how to delete the data from database of checked checkboxes..plz help

解决方案

Hello ,

you are deleting row from the datagridview , not from the database .

try this way

int selectedIndex = dataGridView1.CurrentRow.Index;
String selectedOrderID = dataGridView1.CurrentRow.Cell[0].Value.ToString();
 //if orderid is in zero index

Now make one Query to delete that data from database .

string sql = "DELETE FROM Table1 WHERE OrderID = @selectedOrderID";

 SqlCommand deleteRecord = new SqlCommand();

 deleteRecord.Connection = connectionstring;

 deleteRecord.CommandType = CommandType.Text;

 deleteRecord.CommandText = sql;

 SqlParameter RowParameter = new SqlParameter();

 RowParameter.ParameterName = "@selectedOrderID";

 RowParameter.SqlDbType = SqlDbType.Varchar;

 RowParameter.Value = selectedOrderID;

 deleteRecord.Parameters.Add(RowParameter);

 deleteRecord.Connection.Open();

 deleteRecord.ExecuteNonQuery();

 deleteRecord.Connection.Close();

and finally refresh the datagridview by load the data from database again .

thanks
animesh

refer below links for deleting rows from database as well as gridview:-
http://www.aspdotnet-suresh.com/2011/02/how-to-delete-multiple-rows-in-gridview.html[^]
http://social.msdn.microsoft.com/Forums/en-US/90334fcb-adec-4e9a-9148-763eed1fbb33/help-how-to-delete-row-in-datagridview-based-on-checkbox-selection-in-c[^]
http://www.aspsnippets.com/Articles/Delete-multiple-rows-in-GridView-with-CheckBox-selection-and-with-confirmation-in-ASPNet.aspx[^]
http://www.c-sharpcorner.com/forums/thread/137021/__cs_myImageUpload.aspx[^]

Try this:

Step1:Write a stored procedure for deleting records.
Step2:Add new function in code behind for delete using stored procedure.
Step3:Call delete function inside btn_delete_Click event after removing it from datagridview.

这篇关于如何从C＃.Net中的数据库删除值对应于选中的复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！