con.Open(); SqlCommand cmddr=new SqlCommand("SELECT * FROM Credit WHERE ID='"+Session["DID"]+"'",con); SqlDataReader drcredit = cmddr.ExecuteReader(); if (drcredit.HasRows) { while (drcredit.Read()) { string ref1 = drcredit["ref"].ToString(); string refid = drcredit["refid"].ToString(); string crdol = drcredit["valuesdol"].ToString(); string crrs = drcredit["valuesrs"].ToString(); con.Open(); SqlCommand cmdmp = new SqlCommand("SELECT * FROM Party_Master WHERE refid='" + refid + "'", con); SqlDataReader drmp = cmdmp.ExecuteReader(); if (drmp.HasRows) { drmp.Read(); string crdoller = drmp["crdol"].ToString(); string crrupess = drmp["crrs"].ToString(); Session["crdoller"] = crdoller; Session["crrupess"] = crrupess; drmp.Close(); } con.Close(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)