string Query = "SELECT" + "dbo.DataAccount.PatientAccountNumber, " + "dbo.DataAccount.PatientName, " + "dbo.DataAccount.BARStatus_ORPH," + "dbo.DataAccount.AdmitDate," + "dbo.DataAccount.ServiceDate," + "dbo.DataCodes.CPT1," + "dbo.DataCodes.CPT2," + "dbo.DataCodes.CPT4," + "dbo.DataCodes.CPT6," + "dbo.Diagnosis.DX1," + "dbo.Diagnosis.DX1DESC" + "FROM " + "(dbo.DataCodes INNER JOIN " + "(dbo.DataAccount INNER JOIN dbo.Diagnosis " + "ON dbo.DataAccount.RowID = dbo.Diagnosis.DXRowID) " + "ON dbo.DataAccount.RowID = dbo.DataCodes.RowID)"; EntityConnection eConn = new EntityConnection(security.GetConnectionStringForPIAPratice(Server, DataBaseName, password)); eConn.Open(); using (Etities entity = new Entities(eConn)) { var queryres = entity.ExecuteStoreQuery<dynamic>(Query , null); DGVQueryResults.DataSource = queryres.ToList(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)