how to count column values in c#.net

Hi,

Please refer the below coding

DataTable dtTemp = new DataTable();
dtTemp.Columns.Add("empid", typeof(int));
dtTemp.Columns.Add("name", typeof(string));
dtTemp.Columns.Add("dept", typeof(string));
dtTemp.Columns.Add("1", typeof(string));
dtTemp.Columns.Add("2", typeof(string));
dtTemp.Columns.Add("3", typeof(string));
dtTemp.Columns.Add("4", typeof(string));
dtTemp.Columns.Add("5", typeof(string));
dtTemp.Columns.Add("total X", typeof(int));
dtTemp.Columns.Add("total /", typeof(int));
DataRow drTemp = dtTemp.NewRow();
drTemp["empid"] = 1;
drTemp["name"] = "a";
drTemp["dept"] = "C";
drTemp["1"] = "X";
drTemp["2"] = "wh";
drTemp["3"] = "/";
drTemp["4"] = "X";
drTemp["5"] = "X";
dtTemp.Rows.Add(drTemp);
drTemp = dtTemp.NewRow();
drTemp["empid"] = 2;
drTemp["name"] = "b";
drTemp["dept"] = "C";
drTemp["1"] = "X";
drTemp["2"] = "wh";
drTemp["3"] = "X";
drTemp["4"] = "/";
drTemp["5"] = "/";
dtTemp.Rows.Add(drTemp);
drTemp = dtTemp.NewRow();
drTemp["empid"] = 3;
drTemp["name"] = "c";
drTemp["dept"] = "C";
drTemp["1"] = "X";
drTemp["2"] = "wh";
drTemp["3"] = "/";
drTemp["4"] = "/";
drTemp["5"] = "X";
dtTemp.Rows.Add(drTemp);
string All_Fields = "";
int X_count = 0;
int Slash_count = 0;
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
All_Fields = "";
X_count = 0;
Slash_count = 0;
All_Fields = dtTemp.Rows[i]["1"] + "" + dtTemp.Rows[i]["2"] + "" + "" + dtTemp.Rows[i]["3"] + "" + dtTemp.Rows[i]["4"] + "" + dtTemp.Rows[i]["5"];
X_count = All_Fields.Count(strX => strX == 'X');
Slash_count = All_Fields.Count(strY => strY == '/');
dtTemp.Rows[i]["total X"] = X_count;
dtTemp.Rows[i]["total /"] = Slash_count;
}
dtTemp.AcceptChanges();

1 Reply

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

Hariharan Krishnamoorthi9y ago
Hi,
Please refer the below coding
DataTable dtTemp = new DataTable();
dtTemp.Columns.Add("empid", typeof(int));
dtTemp.Columns.Add("name", typeof(string));
dtTemp.Columns.Add("dept", typeof(string));
dtTemp.Columns.Add("1", typeof(string));
dtTemp.Columns.Add("2", typeof(string));
dtTemp.Columns.Add("3", typeof(string));
dtTemp.Columns.Add("4", typeof(string));
dtTemp.Columns.Add("5", typeof(string));
dtTemp.Columns.Add("total X", typeof(int));
dtTemp.Columns.Add("total /", typeof(int));

DataRow drTemp = dtTemp.NewRow();
drTemp["empid"] = 1;
drTemp["name"] = "a";
drTemp["dept"] = "C";
drTemp["1"] = "X";
drTemp["2"] = "wh";
drTemp["3"] = "/";
drTemp["4"] = "X";
drTemp["5"] = "X";
dtTemp.Rows.Add(drTemp);

drTemp = dtTemp.NewRow();
drTemp["empid"] = 2;
drTemp["name"] = "b";
drTemp["dept"] = "C";
drTemp["1"] = "X";
drTemp["2"] = "wh";
drTemp["3"] = "X";
drTemp["4"] = "/";
drTemp["5"] = "/";
dtTemp.Rows.Add(drTemp);

drTemp = dtTemp.NewRow();
drTemp["empid"] = 3;
drTemp["name"] = "c";
drTemp["dept"] = "C";
drTemp["1"] = "X";
drTemp["2"] = "wh";
drTemp["3"] = "/";
drTemp["4"] = "/";
drTemp["5"] = "X";
dtTemp.Rows.Add(drTemp);


string All_Fields = "";
int X_count = 0;
int Slash_count = 0;

for (int i = 0; i < dtTemp.Rows.Count; i++)
{
    All_Fields = "";
    X_count = 0;
    Slash_count = 0;

    All_Fields = dtTemp.Rows[i]["1"] + "" + dtTemp.Rows[i]["2"] + "" + "" + dtTemp.Rows[i]["3"] + "" + dtTemp.Rows[i]["4"] + "" + dtTemp.Rows[i]["5"];

    X_count = All_Fields.Count(strX => strX == 'X');
    Slash_count = All_Fields.Count(strY => strY == '/');

    dtTemp.Rows[i]["total X"] = X_count;
    dtTemp.Rows[i]["total /"] = Slash_count;
}

dtTemp.AcceptChanges();
+1

empid	name	dept	1	2	3	4	5	total X	total /
1	a	c	x	wh	/	x	x	3	1
2	b	c	x	wh	x	/	/	2	2
3	c	c	x	wh	/	/	x	2	2