public void loadDataCourseLearning(TYPE_CONNECT eTypeConnect)
{
switch (eTypeConnect)
{
case TYPE_CONNECT.MySQLite:
{
//*sqlite*//
String sql = "Select * from ChuanDauRa ";
cmd1 = new SQLiteCommand(sql, _Connection);
cmd1.ExecuteNonQuery();
SQLiteDataAdapter da = new SQLiteDataAdapter(cmd1);
data1 = new DataTable();
da.Fill(data1);
break;
}
case TYPE_CONNECT.MySQL:
{
//*sqlphpadmin*//
MySqlDataAdapter mysqlAdapter = new MySqlDataAdapter();
string sql = "Select *from chuandaura";
mysqlAdapter.SelectCommand = new MySqlCommand(sql, mysqlConnection);
data1 = new DataTable();
mysqlAdapter.Fill(data1);
break;
}
default:
{
break;
}
}
foreach (DataRow item in data1.Rows)
{
int n = customCourseLearning2.tableCourseLearning.Rows.Add();
// customCourseLearning2.tableCourseLearning.Rows[n].Cells[0].Value = item["id"].ToString();
customCourseLearning2.tableCourseLearning.Rows[n].Cells[0].Value = item["level1"].ToString();
customCourseLearning2.tableCourseLearning.Rows[n].Cells[1].Value = item["level2"].ToString();
customCourseLearning2.tableCourseLearning.Rows[n].Cells[2].Value = item["level3"].ToString();
customCourseLearning2.tableCourseLearning.Rows[n].Cells[3].Value = item["level4"].ToString();
customCourseLearning2.tableCourseLearning.Rows[n].Cells[4].Value = item["CDR"].ToString();
customCourseLearning2.tableCourseLearning.Rows[n].Cells[5].Value = item["TDNL"].ToString();
nNumbersOfCourseID = n;
}
customCourseLearning2.tableCourseLearning.Rows[78].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customCourseLearning2.tableCourseLearning.Rows[104].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customCourseLearning2.tableCourseLearning.Rows[149].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
}
public void loadDataMatrix(TYPE_CONNECT eTypeConnect)
{
switch (eTypeConnect)
{
case TYPE_CONNECT.MySQLite:
{
/*SQLite*/
String sql = "Select * from MaTranKyNang ";
cmd3 = new SQLiteCommand(sql, _Connection);
cmd3.ExecuteNonQuery();
SQLiteDataAdapter da2 = new SQLiteDataAdapter(cmd3);
data3 = new DataTable();
da2.Fill(data3);
break;
}
case TYPE_CONNECT.MySQL:
{
/*MySQL*/
MySqlDataAdapter mysqlAdapter2 = new MySqlDataAdapter();
string sql = "Select *from MaTranKyNang";
mysqlAdapter2.SelectCommand = new MySqlCommand(sql, mysqlConnection);
data3 = new DataTable();
mysqlAdapter2.Fill(data3);
break;
}
default:
{
break;
}
}
customMatrix1.tableMatrix.DataSource = data3;
foreach (DataGridViewColumn column in customMatrix1.tableMatrix.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
public void loadDataLessonPlant(TYPE_CONNECT eTypeConnect)
{
switch (eTypeConnect)
{
case TYPE_CONNECT.MySQLite:
{
/*SQLite*/
String sql = "Select * from ChuongTrinhDaoTao ";
cmd2 = new SQLiteCommand(sql, _Connection);
cmd2.ExecuteNonQuery();
SQLiteDataAdapter da1 = new SQLiteDataAdapter(cmd2);
data2 = new DataTable();
da1.Fill(data2);
break;
}
case TYPE_CONNECT.MySQL:
{
//*sqlphpadmin*//
MySqlDataAdapter mysqlAdapter1 = new MySqlDataAdapter();
string sql = "Select *from ChuongTrinhDaoTao";
mysqlAdapter1.SelectCommand = new MySqlCommand(sql, mysqlConnection);
data2 = new DataTable();
mysqlAdapter1.Fill(data2);
break;
}
default:
{
break;
}
}
foreach (DataRow item in data2.Rows)
{
int n = customLessonPlant1.tableLessonPlant.Rows.Add();
customLessonPlant1.tableLessonPlant.Rows[n].Cells[0].Value = item["id"].ToString();
customLessonPlant1.tableLessonPlant.Rows[n].Cells[1].Value = item["MaMonHoc"].ToString();
customLessonPlant1.tableLessonPlant.Rows[n].Cells[2].Value = item["TenMonHoc"].ToString();
customLessonPlant1.tableLessonPlant.Rows[n].Cells[3].Value = item["SoTC"].ToString();
customLessonPlant1.tableLessonPlant.Rows[n].Cells[4].Value = item["LT"].ToString();
customLessonPlant1.tableLessonPlant.Rows[n].Cells[5].Value = item["TH"].ToString();
customLessonPlant1.tableLessonPlant.Rows[n].Cells[6].Value = item["BT"].ToString();
customLessonPlant1.tableLessonPlant.Rows[n].Cells[7].Value = item["Loai"].ToString();
customLessonPlant1.tableLessonPlant.Rows[n].Cells[8].Value = item["KeHoach"].ToString();
nNumbersOfLessonPlantID = n;
}
customLessonPlant1.tableLessonPlant.Rows[5].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[15].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[26].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[37].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[47].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[54].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[65].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[74].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[87].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[104].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[114].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[128].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[140].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
// customLessonPlant1.tableLessonPlant.Rows[150].DefaultCellStyle.BackColor = Color.FromArgb(153, 180, 209);
customLessonPlant1.tableLessonPlant.Rows[48].DefaultCellStyle.BackColor = Color.FromArgb(164, 214, 224);
customLessonPlant1.tableLessonPlant.Rows[75].DefaultCellStyle.BackColor = Color.FromArgb(164, 214, 224);
customLessonPlant1.tableLessonPlant.Rows[115].DefaultCellStyle.BackColor = Color.FromArgb(164, 214, 224);
//_Connection.Close();
}
