How to get the least value in a row (Table row).

Pavan Bujji

Hi guys,

How to get the least value in a row ?.

For ex.,

Here How can i know the Item4 has least value in c# ?.

Thanks & Regards,

Pavan G.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pavan Bujji8y ago
Thank you responding Siddhartha.

i got the solution by Sql Query instead of writing the code .query is below

Select top 1 Column1,Min(Column2) as Quantity from TABLEName where Column= 'ColumnName' group by Column1order by Column2

Thank You so much for ur assistance.
siddhartha sharna8y ago
Hi Pawan,

I have done with sample data Table . Please check the below code.

DataTable dt = new DataTable();

dt.Clear();

dt.Columns.Add("Row1");

dt.Columns.Add("Row2");

dt.Columns[1].DataType = typeof(Int32);

DataRow r1 = dt.NewRow();

r1["Row1"] = "xyz";

r1["Row2"] = "200";

dt.Rows.Add(r1);

DataRow r2 = dt.NewRow();

r2["Row1"] = "abc";

r2["Row2"] = "100";

dt.Rows.Add(r2);

DataRow r3 = dt.NewRow();

r3["Row1"] = "test";

r3["Row2"] = "50";

dt.Rows.Add(r3);

DataView view = dt.DefaultView;

view.Sort = "Row2 ASC";

DataTable dt1 = view.ToTable();

Console.WriteLine("Row1 :" + dt1.Rows[0][0].ToString() +" Row2 :"+ dt1.Rows[0][1]);// First();

Console.ReadLine();
Pavan Bujji8y ago
S.it is datatable (Sql Server) Amit. and i used that code Siddhartha sharna.but it is not working for me.

any advices ?.
siddhartha sharna8y ago
For Data Table :

var col = dt.Select("row2", "row2 ASC");

var min = col.First();

For SQL Server :

Use the Min Function for getting value.
Amit Gupta8y ago
What table is this? Is this a sql table or Datatable