How to get minimum and maximum column count in dataset?

Question

minimum and maximum column count. i refer some websites but little bit cofused.

Bikesh Srivastava · Answer

Hi Raja , Try this.. int minAccountLevel= int .MaxValue; int maxAccountLevel= int .MinValue; foreach (DataRowdr in table.Rows) { int accountLevel=dr.Field int >( "AccountLevel" ); minAccountLevel=Math.Min(minAccountLevel,accountLevel); maxAccountLevel=Math.Max(maxAccountLevel,accountLevel); }

Raja · Answer

Ok i will check it

Midhun Tp · Answer

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.

Vinay Singh · Answer

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);

Raja · Answer

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[f]["Column52"] =ds.Tables[k].Compute("MAX(Column52)",""); //double maxval = Convert.ToDouble((ds.Tables[k].Compute("MAX(Column52)", ""))); (also try this one) }

Midhun Tp · Answer

Hi, Try below code - double maxval = Convert.ToDouble((dataset.Tables[0].Compute("MAX(colname)", ""))); double minval = Convert.ToDouble((dataset.Tables[0].Compute("MIN(colname)", "")));

Raja · Answer

Midhun T P S midhun

Midhun Tp · Answer

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