How to get minimum and maximum column count in dataset?

Question

minimum and maximum column count.

 

i refer some websites but little bit cofused.

Answer 1

Hi Raja ,

Try this..

intminAccountLevel=int.MaxValue;
intmaxAccountLevel=int.MinValue;
foreach(DataRowdrintable.Rows)
{
intaccountLevel=dr.Field<int>("AccountLevel");
minAccountLevel=Math.Min(minAccountLevel,accountLevel);
maxAccountLevel=Math.Max(maxAccountLevel,accountLevel);
}

Answer 2

Ok i will check it

Answer 3

Hi.

There is no rows corresponding to column "Column52" in that dataset. Thats why its throwing error. There should be rows for that column in your dataset for below code to work.

Answer 4

Hi

check the below solution

DataTable dt= ds.Tables[0];
int min=dt.Compute("min(age)",string.Empty);
int max=dt.Compute(max(age)",string.Empty);

Answer 5

Object cannot be cast from DBNull to other types.

Exception error occur

ds.Tables[k].Columns.Add("Column52");
ds.Tables["Source" + c].AcceptChanges();
for (int f = 0; f < ds.Tables[k].Rows.Count; f++)
{

ds.Tables[k].Rows[f]["Column52"] =ds.Tables[k].Compute("MAX(Column52)","");
//double maxval = Convert.ToDouble((ds.Tables[k].Compute("MAX(Column52)", "")));
(also try this one)
}

Answer 6

Hi,

Try below code -

double maxval = Convert.ToDouble((dataset.Tables[0].Compute("MAX(colname)", "")));

double minval = Convert.ToDouble((dataset.Tables[0].Compute("MIN(colname)", "")));

Answer 7

<h4><a data-userid="9088f9" href="http://www.c-sharpcorner.com/members/midhun-tp">Midhun T P</a></h4>S midhun

Answer 8

Hi,

Did you mean the minimum or maximum values in a column of dataset?