In my table mvefinalRx, I have a column RxType which contains Final CL Rx and Final Spectacle Rx. In C#,based on Rxtype I have to display the values.

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MVEdb"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("select * from MVE_FinalRX where RxType='Final CL Rx'", con);
SqlDataAdapter da1 = new SqlDataAdapter("select * from MVE_FinalRX where RxType='Final Spectacle Rx'", con);
SqlDataAdapter da2 = new SqlDataAdapter("select RxType from MVE_FinalRX where RxType='Final CL Rx'", con);
DataSet ds = new DataSet();
da.Fill(ds, "MVE_FinalRX");
da1.Fill(ds, "MVE_FinalRX");
da2.Fill(ds, "MVE_FinalRX");

// Here I have to compare based on Rxtype if Rxtype is Final CL Rx execute if condition or else
if () 
{
    //Final CL Rx values
}
else
{
    //Final Spectacle Rx value
}