예제 #1
0
        private void trsMake()
        {
            ___BASA__DataSet.StatDiagnosisDataTable tabTR = statDiagnosisTableAdapter.GetDataByDSDist();
            trs = new string[tabTR.Rows.Count];
            int ii = 0;

            foreach (DataRow dr in tabTR.Rows)
            {
                trs[ii] = dr["DS"].ToString();
                ii++;
            }
        }
예제 #2
0
        void Fill2(___BASA__DataSet.StatDiagnosisDataTable dataTable)
        {
            statDiagnosisTableAdapter.Adapter.SelectCommand = new System.Data.OleDb.OleDbCommand();

            statDiagnosisTableAdapter.Adapter.SelectCommand.Connection  = new System.Data.OleDb.OleDbConnection(DSS.Properties.Settings.Default.__BASA__ConnectionString1);
            statDiagnosisTableAdapter.Adapter.SelectCommand.CommandType = System.Data.CommandType.Text;

            statDiagnosisTableAdapter.Adapter.SelectCommand.CommandText = "SELECT Diagnosis.Texts AS DS, COUNT(Diagnosis.ID) AS Many " + select +
                                                                          " FROM ((((TreatDS LEFT OUTER JOIN Diagnosis ON TreatDS.Diagnos = Diagnosis.ID) LEFT OUTER JOIN Posesenie ON TreatDS.Posesenie = Posesenie.ID) LEFT OUTER JOIN Patients ON Posesenie.Patient = Patients.PID) LEFT OUTER JOIN Personal ON Posesenie.Personal = Personal.DID) " +
                                                                          " GROUP BY Diagnosis.Texts " + group;

            dataTable.Clear();
            statDiagnosisTableAdapter.Adapter.Fill(dataTable);
        }