Finding value in database by max(ID) and save as a Variable in c#

Question

I've a problem with my program in c# and i hope, you can help me.

My database looks like this:

and I want to save the last value of "MaxZyklus" in a variable in c#.

My query to the server is okay, when I write it like this:

select Kabel.maxZyklus 
from Kabel 
where Kabel.kabelTyp = 'PM-K031' 
  and ID = 20; 

select max(ID) from Kabel

but I don't know, how I can do it in one query, and save it in C# as a variable

Hope you can help me.

Reza Aghaei · Accepted Answer · 2015-09-08 08:02:22Z

1

SELECT YourField FROM YourTable 
WHERE YourKey =(SELECT MAX(YourKey) FROM YourTable )

answered Sep 8, 2015 at 8:02

Reza Aghaei

126k18 gold badges239 silver badges447 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andy · Accepted Answer · 2015-09-08 09:03:24Z

0

I found the correct query at

select Kabel.max Zyklus form Kabel where ID = (select max(ID) from Kabel where Kabel.kabelTyp = 'PM-K031');

now saving in a vatiable :) suggestions?

answered Sep 8, 2015 at 9:03

Andy

111 bronze badge