It's pretty simple:
SELECT Job_Name FROM Job_Category WHERE Industry_ID=1
Is an SQL query which returns an unknown number of rows (this depends on how many rows in your DB are in the appropriate industry), each of which has a single column (the Job Name).
Label6.Text = Convert.ToString(reader[0]);
Label8.Text = Convert.ToString(reader[1]);
Label10.Text = Convert.ToString(reader[2]);
Label12.Text = Convert.ToString(reader[3]);
Label14.Text = Convert.ToString(reader[4]);
Label16.Text = Convert.ToString(reader[5]);
Label18.Text = Convert.ToString(reader[6]);
Label20.Text = Convert.ToString(reader[7]);
Label22.Text = Convert.ToString(reader[8]);
Label24.Text = Convert.ToString(reader[9]);
Label26.Text = Convert.ToString(reader[10]);
Label28.Text = Convert.ToString(reader[11]);
Label30.Text = Convert.ToString(reader[12]);
Label7.Text = Convert.ToString(reader[13]);
This attempts to read 14 columns from a single row which contains only one column. This will throw an error when it gets the the second line.
But it isn't getting that far, because you are not reading any rows into the SqlReader from the DB.
You need to call the SqlReader.Read method before you use each row:
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand com = new SqlCommand("SELECT iD, description FROM myTable", con))
{
using (SqlDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int id = (int) reader["iD"];
string desc = (string) reader["description"];
Console.WriteLine("ID: {0}\n {1}", iD, desc);
}
}
}
}