how deleteing multi records with sqlcommand

Using Sql Delete Command directly in FE is not a good idea. I would suggest you to create a procedure to delete the selected row. As you are storing the selected rows ID in list<string></string>, pass the list to the procedure(See here : C# SQL Server - Passing a list to a stored procedure[^].) and perform the delete operation in procedure with Sql Transaction.

Please see : What are the pros and cons to keeping SQL in Stored Procs versus Code[^].

--Amit

try this :-

Make string of data from rowlist and add into your delete query

string data= null;
if (dataGridView1.SelectedRows.Count > 1)
            {
                List<string> rowList = new List<string>();
 
                foreach (DataGridViewRow r in dataGridView1.SelectedRows)
		  {
                    if (r.Cells[3].Value.ToString() != null)
                        {
                          rowList.Add(r.Cells[3].Value.ToString());
			  data = data + "'" + r.Cells[3].Value.ToString() + "',";
                        }
		  }
}
if (Strings.Len(data) >= 1) {
		data = Strings.Mid(data, 1, Strings.Len(data) - 1);
}
commandtext = "delete mytable where recordid in(" + data + ")";

Your input query must be in this format :
DELETE FROM dbo.mytable WHERE recordid IN('Value 1','Value 2','Value 3')


//So modify the below command it will work
commandtext = "delete mytable where recordid in(" + string.Join(",", rowList.ToList()) + ")"

Thank you.

if (dataGridView1.SelectedRows.Count > 1)
 {
    string strValue=String.Empty;

    foreach (DataGridViewRow r in dataGridView1.SelectedRows)
     {
      if (r.Cells[3].Value.ToString() != null)
        {
          strValue+=(r.Cells[3].Value.ToString())+',';
        }
     }
}

And then you use

commandtext ="delete mytable where recordid in(strValue)

Thanks & Regard
Sham :)

Hello,

try this.

commandtext ="delete mytable where recordid in("+String.Join(',',rowList.ToArray())+")";