private void GetDataTable() { Command = "SELECT * FROM STD.Student WHERE ID = '" + Login_Layer.CopyOfID + "'"; DT = new DataTable(); DT = Cls_DataLayer.ExecuteDataTable(Command); }
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); }