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

Question

Hi guys, How to get the least value in a row ?. For ex., ROw1 Row2 Item1 5 Item2 9 Item3 11 Item4 3 Here How can i know the Item4 has least value in c# ?. Thanks & Regards, Pavan G.

siddhartha sharna · Answer

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

Amit Gupta · Answer

What table is this? Is this a sql table or Datatable

Pavan Bujji · Answer

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.

Pavan Bujji · Answer

S.it is datatable (Sql Server) Amit. and i used that code Siddhartha sharna.but it is not working for me. any advices ?.

siddhartha sharna · Answer

For Data Table : var col = dt.Select("row2", "row2 ASC"); var min = col.First(); For SQL Server : Use the Min Function for getting value.