Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
DataTable DT_Courses = new DataTable(); DT_Courses = KazooSoft.MSSQL_Functions.DBQuery( "SELECT students.student_cn, students.student_fn, students.student_ln, course.course_title, lm_statements.archived, lm_statements.printed " + "FROM course INNER JOIN " + "lm_statements ON course.course_code = lm_statements.course_id INNER JOIN " + "students ON lm_statements.student_id = students.person_code " + "WHERE course.course_code = '"+ combo_Courses.SelectedValue.ToString() +"'", KazooReports.Properties.Settings.Default.MSSQL_username, KazooReports.Properties.Settings.Default.MSSQL_password, KazooReports.Properties.Settings.Default.MSSQL_database, KazooReports.Properties.Settings.Default.MSSQL_server ); dataGridView_PrintArchive.DataSource = DT_Courses;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.