vb Code:
  1. Dim DRow As DataRow = DS.Tables(0).Rows(0)
  2.             If DS.Tables(0).Rows.Count > 0 Then
  3.                 .txtCourseCode.Text = DRow.Item("CourseCode").ToString()
  4.                 .txtRoomNumber.Text = DRow.Item("RoomNumber").ToString()
  5.                 .txtSchoolYear.Text = DRow.Item("SchoolYear").ToString()
  6.                 .txtTeacher.Text = DRow.Item("Teacher").ToString()
  7.             End If

Since theirs only 1 ROW in the Table, How could I just read from that instead of having the DataRow and so on? Is their a way to reduce / optimize it? I know its not a lot, but I don't want redundant code.