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(minAccountLevelaccountLevel); maxAccountLevel=Math.Max(maxAccountLevelaccountLevel); }

Raja · Answer

Ok i will check it

Midhun T P · 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 T P · 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 T P · Answer

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