Retrieve multiple values from database

Rohit please once follow below steps:

Add your all 3 values in database through SQL command objects.

Take a array type variable of size 3.

Store all your 3 values in  array one by one.

Now you can do easily comparison.

 

 

 

 

 

 

If this is helpful for you then please accept my Answer. 

hi Rohit,

 

Do you want to achieve this in C# Code  or inside stored procedure?

If c# code then

 

Save first value in table using sqlCommand and get that value in Scalar  now do combination as per your requirement and save it into table again and do the above step again.

 

And if its in stored procedure you have to pass three values in procedure and get the last saved value using @@identity and perform combination and save it again and for the third do the previous step again.

 

Hope it helps.