I have this query and it works great:
SelectCommand="select l.locationid,c.CourseId, i.instructorId,CourseName, i.instructorname, dbo.fnFormatDate(t.trainingDates, 'MON/DD/YYYY') trainingDates, t.trainingTime,CourseDescription from tblCourses c, tblLocations l, tblTrainingDates t, tblInstructors i, tblCourseInstructor ci where l.locationid = c.locationid and c.dateId = t.dateId and i.instructorid = ci.instructorId and c.courseid=ci.courseid"
FilterExpression="LocationId = '{0}'" >
Then I have this updatecommand which doesn't work completely well:
UpdateCommand = "Update tblCourses Set CourseName = @CourseName, CourseDescription = @CourseDescription where CourseId =@CourseId;Update tblInstructors set InstructorName=@InstructorName where instructorId=@instructorId"
Notice that there are 2 update statements for this UpdateCommand.
Then I have d ...
Go to the complete details ...