data table field value count

Posted by Sekar.C under C# on 3/9/2012 | Points: 10 | Views : 5483 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi,
In my data table have 3 fields( Name, Deviation, Image) in the Deviation display numeric values I want number of time 0 values display.
attached my sample data table
regard
sekar.c

Attachment

Regards
Sekar.c

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Hmanjarawala on: 3/9/2012 [Member] Bronze | Points: 25

0	Hi, Use DataTable.Compute(string expression, string filter); ex: DataTable dt = new DataTable(); dt.Columns.Add("Value", typeof(double)); dt.Rows.Add(new object[] { 39.56 }); dt.Rows.Add(new object[] { 23.56 }); dt.Rows.Add(new object[] { 0 }); dt.Rows.Add(new object[] { 14.89 }); dt.Rows.Add(new object[] { 0 }); dt.Rows.Add(new object[] { 0 }); dt.Rows.Add(new object[] { 0 }); var count = dt.Compute("Count(Value)", "Value=0"); Mark this as answer, if it helps you............ Himanshu Manjarawala Sr. Software Engineer@AutomationAnywhere http://fieredotnet.wordpress.com/ Sekar.C, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,

Use DataTable.Compute(string expression, string filter);

ex:


            DataTable dt = new DataTable();

            dt.Columns.Add("Value", typeof(double));



            dt.Rows.Add(new object[] { 39.56 });

            dt.Rows.Add(new object[] { 23.56 });

            dt.Rows.Add(new object[] { 0 });

            dt.Rows.Add(new object[] { 14.89 });

            dt.Rows.Add(new object[] { 0 });

            dt.Rows.Add(new object[] { 0 });

            dt.Rows.Add(new object[] { 0 });



            var count = dt.Compute("Count(Value)", "Value=0");

Mark this as answer, if it helps you............

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts