private void GetDataTable()
        {
            Command = "SELECT * FROM STD.Student WHERE ID = '" + Login_Layer.CopyOfID + "'";

            DT = new DataTable();

            DT = Cls_DataLayer.ExecuteDataTable(Command);
        }
Example #2
0
        private void GetDataTable()
        {
            Command = "SELECT FK.Teacherr.Name, FK.Teacherr.Lname, FK.Dars.Name, FK.TimeOfClass.[DayOfWeek], FK.TimeOfClass.TimeStart, FK.TimeOfClass.TimeEnd" +
                      "FROM FK.Teacherr" +
                      "INNER JOIN FK.ClassHa" +
                      "ON FK.Teacherr.ID = FK.ClassHa.OstadID" +
                      "INNER JOIN FK.Dars" +
                      "ON FK.ClassHa.DarsID = FK.Dars.ID" +
                      "INNER JOIN FK.TimeOfClass" +
                      "ON FK.ClassHa.ID = FK.TimeOfClass.ClassHaID";

            DataGrideList.DataSource = Cls_DataLayer.ExecuteDataTable(Command);
        }