public JsonResult GetProductSupplier(string ProductSupplierID) { BL_Purchase db = new BL_Purchase(); DataSet dsBalance = new DataSet(); DataSet ds = new DataSet(); dsBalance = objbl.GetProductSupplier(ProductSupplierID); ds = objbl.GetProductSupplier(ProductSupplierID); List <Purchase> searchlist = new List <Purchase>(); foreach (DataRow dr in dsBalance.Tables[0].Rows) { searchlist.Add(new Purchase { ProductSupplierID = Convert.ToString(dr["ProductSupplierID"]), ProductSupplierName = Convert.ToString(dr["ProductSupplierName"]), Address = Convert.ToString(dr["Address"]), Balance = dsBalance.Tables[1].Rows[0]["Balance"].ToString(), }); } return(new JsonResult { Data = searchlist, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }