SELECT INST_ID, LongName FROM TableCOCINSE EXCEPT SELECT INST_ID, LongName from TableAFTE where AFTEYR = 2016
SqlConnection con3 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PassoneConnectionString"].ConnectionString); con3.Open(); SqlCommand com = new SqlCommand("(SELECT INST_ID, LongName FROM TableCOCINSE) EXCEPT (SELECT INST_ID, LongName FROM TableAFTE)", con3); DataTable dt = new DataTable(); SqlDataReader sqlDataReader = com.ExecuteReader(); dt.Load(sqlDataReader); sqlDataReader.Close(); GridView dataGridView4 = new GridView(); dataGridView4.DataSource = dt;
dataGridView4.DataBind();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)