Retrieve multiple values from database

Question

I need to add three values and save it in database one after the another in same table.The same values should be retrieved and stored in a variable and that variable should be made for comparison

Sujeet Suman · Answer

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 .

Vishal Jadav · 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.