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