public static string MedDetails(string MedName) { IssueHeaderDetails IssuedtlsObj = new IssueHeaderDetails(); UIClasses.Const Const = new UIClasses.Const(); ClinicDAL.UserAuthendication UA; UA = (ClinicDAL.UserAuthendication)HttpContext.Current.Session[Const.LoginSession]; IssuedtlsObj.ClinicID = UA.ClinicID.ToString(); DataSet ds = IssuedtlsObj.GetMedicineDetailsByMedicineName(MedName); string Unit = ""; string MedCode = ""; string Category = ""; string Qty = ""; if (ds.Tables[0].Rows.Count > 0) { Unit = Convert.ToString(ds.Tables[0].Rows[0]["Unit"]); MedCode = Convert.ToString(ds.Tables[0].Rows[0]["MedCode"]); Category = Convert.ToString(ds.Tables[0].Rows[0]["CategoryName"]); Qty = Convert.ToString(ds.Tables[0].Rows[0]["Qty"]); } return String.Format("{0}" + "|" + "{1}" + " | " + "{2}" + " | " + "{3}", Unit, MedCode, Category, Qty); }