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();
}
}
