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++;
}
}
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);
}
