private void cidtxt_TextChanged(object sender, EventArgs e) { DBConnect conn = new DBConnect(); conn.OpenConnection(); string query1 = "SELECT * FROM subject where SubjectId='" + cidtxt.Text + "'"; if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query1, conn.connection); MySqlDataReader datareader = cmd.ExecuteReader(); while (datareader.Read()) { ccodetxt.Text = datareader.GetString(1); ctitletxt.Text = datareader.GetString(2); if (datareader.GetString(3) == "C") { ctypetxt.Text = "Core"; } else if (datareader.GetString(3) == "E") { ctypetxt.Text = "Elective"; } else { ctypetxt.Text = "Auxilary"; } ccreditstxt.Text = Convert.ToString(datareader.GetInt32(4)); if (datareader.GetString(5) == "1") { csemtxt.Text = "Semester 1"; } else { csemtxt.Text = "Semester 2"; } if (datareader.GetString(6) == "1") { cyeartxt.Text = "One"; } else if (datareader.GetString(6) == "2") { cyeartxt.Text = "Two"; } else if (datareader.GetString(6) == "3") { cyeartxt.Text = "Three"; } else { cyeartxt.Text = "Four"; } cacayeartxt.Text = datareader.GetString(7); if (datareader.GetString(8) == "DKAN 01") { cdepttxt.Text = "Kandyan Dance"; } else if (datareader.GetString(8) == "DKAN 02") { cdepttxt.Text = "Low-Country Dance"; } else if (datareader.GetString(8) == "DKAN 03") { cdepttxt.Text = "Sabaragamuwa Dance"; } else if (datareader.GetString(8) == "DKAN 04") { cdepttxt.Text = "Indian and Asian Dance"; } else if (datareader.GetString(8) == "DKAN 05") { cdepttxt.Text = "Percussion Music"; } else if (datareader.GetString(8) == "DKAN 06") { cdepttxt.Text = "History and Theory of Dance and Drama"; } else { cdepttxt.Text = "Theatre, Ballet and Modern Dance"; } } datareader.Close(); conn.CloseConnection(); } }