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 }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)