Populate DropDownList from Database with condition using C# or SQL Server

Hi sowjanya,

You need to check with if condition.

string bloodGroup = string.Empty;
string bloodGroupDb = "GetFromDb";
if (bloodGroupDb == "A" || bloodGroupDb == "a" || bloodGroupDb == "A+" || bloodGroupDb == "a+" 
    || bloodGroupDb == "a+" || bloodGroupDb == "A+" || bloodGroupDb == "a + ve" || bloodGroupDb == "A + VE")
{
    bloodGroup = "A+ve";
}
// Then bind to dropdownlist

Refer the below query.

DECLARE @Test AS TABLE(BGroup CHAR(10))
INSERT INTO @Test VALUES('A'),('a'),('A+'),('a+'),('a+'),('A+'),('a+ve'),('A+VE')
SELECT CASE 
	   WHEN BGroup = 'A' OR BGroup = 'A+' OR BGroup = 'A+VE' THEN 'A+ve' 
	   ELSE BGroup 
	   END BGroup
FROM @Test

Output