Loading

how to sum only search rows in datagridview

how to sum only search rows in datagridview

PK Singh

4y971Learn iOS Programming

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

PK Singh4y ago
error Show

System.InvalidCastException: 'Specified cast is not valid.'

(int)row.Cells[3].Value);
+2
Sachin Singh4y ago
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();
+2
PK Singh4y ago
when I search lable vaule show only Zero
+1
Sachin Singh4y ago
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();
+2
PK Singh4y ago
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
+2
Sachin Singh4y ago
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.
+2