Pls try -

var Mins = yourDataTable.AsEnumerable().Max(row => Convert.ToInt32(row["MERENI"]));
var Maxs = yourDataTable.AsEnumerable().Min(row => Convert.ToInt32(row["MERENI"]));

Select allOpen in new window

how min/max value transfer to textbox?

try like..

Txt.Value = (string) Mins

Txt.Value = (string) Mins;

this code find min value in column - how find min/max value in row?

 int min = 0;
            for (int i = 0; i <= dotaz4DataGridView.Rows.Count - 1; i++)
            {
                if (i == 0)
                {
                    min = int.Parse(dotaz4DataGridView.Rows[i].Cells[0].Value.ToString());
                }

                if (min > int.Parse(dotaz4DataGridView.Rows[i].Cells[0].Value.ToString()))
                {
                    min = int.Parse(dotaz4DataGridView.Rows[i].Cells[0].Value.ToString());
                }
            }
            textBox3.Text = min.ToString();

Select allOpen in new window

Try like this-

for (int i = 0; i <= dotaz4DataGridView.rows.Count - 1; i++)
{
	for (int j = 0; j <= dotaz4DataGridView.Columns.Count - 1; j++)
	{
		if (i == 0)
		{
			min = int.Parse(dotaz4DataGridView.Rows[i][j].Cells[0].Value.ToString());
		}

		if (min > int.Parse(dotaz4DataGridView.Rows[i][j].Cells[0].Value.ToString()))
		{
			min = int.Parse(dotaz4DataGridView.Rows[i][j].Cells[0].Value.ToString());
		}
	}
}
textBox3.Text = min.ToString();			

Select allOpen in new window

Not work

Hi Filip;

I think this is what you may be looking for. This assumes that the values in the row are all strings

// From each row in the DataTable find the min and max value of the row
var results = (from DataRow row in dt.AsEnumerable()
               select new
               {
                   Min = row.ItemArray.Where((r, idx) => idx != 0).Min(c => Int32.Parse(c.ToString())),
                   Max = row.ItemArray.Where((r, idx) => idx != 0).Max(c => Int32.Parse(c.ToString()))
               });

// The variable results returns an Anonymous type holding two values Min and Max value of each row
foreach (var minMax in results)
{
    // And to access the Min and Max of the Anonymous type you can do as below
    Console.WriteLine("Min = {0}", minMax.Min);    
    Console.WriteLine("Max = {0}\n", minMax.Max);
}

Select allOpen in new window

Hello Fernando,

It is possible to write min / max value from datagrid (from one row) into textbox?

How are you binding the data to the DataGridView? Do you load a DataTable object and then assign it to the DataGridView.DataSource? How are you loading the DataGridView with data?

Hi Filip;

Try this to see if it works for  you.

var results = (from row in dataGridView1.Rows.Cast<DataGridViewRow>()
               where !row.IsNewRow
               let cells = row.Cells.Cast<DataGridViewCell>()
               let Min = cells.Where((c, idx) => idx != 0).Min(c => Int32.Parse(c.Value.ToString()))
               let Max = cells.Where((c, idx) => idx != 0).Max(c => Int32.Parse(c.Value.ToString()))
               select new
               {
                   Min,
                   Max
               }).ToList();


foreach (var minMax in results)
{
    // And to access the Min and Max of the Anonymous type you can do as below
    Console.WriteLine("Min = {0}", minMax.Min);
    Console.WriteLine("Max = {0}\n", minMax.Max);
}

Select allOpen in new window

My data source is dotaz4BindingSource.

That does not answer my questions.

Did the code I last posted which queries the DataGridView, did that work?

If it did not please post the code you used to load the data into the DataGridView.

What collection do you connect to the BindingSource dotaz4BindingSource?

here is the code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication2
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void dotaz4BindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.dotaz4BindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.dB_KROUTAKUDataSet);

        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'dB_KROUTAKUDataSet.dotaz4' table. You can move, or remove it, as needed.
            this.dotaz4TableAdapter.Fill(this.dB_KROUTAKUDataSet.dotaz4);

        }
    }
}

Select allOpen in new window

I do not know how to find min/max value from one row in datagridview. I need a min / max value display in a textbox.

OK, lets see if I can get some answers. Did the following code work when you implemented in your project? If it did not please post the exception and inner exception.

var results = (from row in dataGridView1.Rows.Cast<DataGridViewRow>()
               where !row.IsNewRow
               let cells = row.Cells.Cast<DataGridViewCell>()
               let Min = cells.Where((c, idx) => idx != 0).Min(c => Int32.Parse(c.Value.ToString()))
               let Max = cells.Where((c, idx) => idx != 0).Max(c => Int32.Parse(c.Value.ToString()))
               select new
               {
                   Min,
                   Max
               }).ToList();


foreach (var minMax in results)
{
    // And to access the Min and Max of the Anonymous type you can do as below
    Console.WriteLine("Min = {0}", minMax.Min);
    Console.WriteLine("Max = {0}\n", minMax.Max);
}

Select allOpen in new window

here is a message

I don't know if I can help, it looks like the error message is in a different language.

can you zip up the complete project so I can see if I can figure out what is happening and post it to a site where I can download it from such as Google Docs or some other.

OK, here is the link. Thank you. https://www.dropbox.com/s/7vc29ryyayj6jix/MIN_MAX_TEST.zip?dl=0

Fernado, work it. Thank you. I am indebted to you... :)

Not a problem Filip, glad to help.

https://www.dropbox.com/s/udn7ol6mt2y3l8y/MIN_MAX_TEST%202.zip?dl=0

Hello Fernando,
How to modify a code so I can also use decimal numbers?

Hi Filip;

Please open a new question for this new requirement and when I get some time today I will look at it.

I modified the code:

let Min = cells.Where((c, idx) => idx != 1).Min(c => Convert.ToDecimal(c.Value.ToString()))
let Max = cells.Where((c, idx) => idx != 1).Max(c => Convert.ToDecimal(c.Value.ToString()))

Select allOpen in new window

Work it

Hi Filip;

By changing this section of the two lines from this, (c, idx) => idx != 0, to this, (c, idx) => idx != 1, you are removing the column 1_MERENI from the calculation and adding the column PROVEDL_MERENI to the calculation. Is this what you want to be doing?