how to sum only search rows in datagridview

Question

how to sum only search rows in datagridview in desktop softerware pleas give me code

Sachin Singh · Answer

If you are searching throughout the Grid means each column then follow this int sum=0; string searchValue=txtSearch.Text; sum= dataGridView1.Rows .Cast () .Where(r => r.Cells[0].Value.ToString().Equals(searchValue)||r.Cells[1].Value.ToString().Equals(searchValue)||r.Cells[2].Value.ToString().Equals(searchValue)||r.Cells[3].Value.ToString().Equals(searchValue)) .Sum(row => ( int )row.Cells[3].Value); label1.Text = sum.ToString();

Sachin Singh · Answer

Ok then it is even simpler int sum=0; string searchValue=txtSearch.Text; sum= dataGridView1.Rows .Cast () .Where(r => r.Cells[3].Value.ToString().Equals(searchValue)) .Sum(row => ( int )row.Cells[3].Value); label1.Text = sum.ToString();

PK Singh · Answer

error Show System.InvalidCastException: 'Specified cast is not valid.' (int)row.Cells[3].Value);

PK Singh · Answer

Search rows through TextBox Datagridview show Search Row Quantity Columns total Sum show in textbox or Lebal Condition Only search Product Quantity Total show value. Id Product Name Quantity

Sachin Singh · Answer

If search rows mean selected rows then int sum=0; sum= dataGridView1.SelectedRows.Cast ().Sum(row => ( int )row.Cells[1].Value); label1.Text = total.ToString(); where Cells[1] is the cell having integer value.

PK Singh · Answer

when I search lable vaule show only Zero

how to sum only search rows in datagridview

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)