using(var different=new SqlCommand("SELECT ID,Name,Surname from ##mytemptable except SELECT ID,Name,Surname from Student)),connection) SqlDataReader dr =different.ExecuteReader(); int newdifferentvalue=0; if(dr.Read()) { newdifferentvalue=dr.GetInt32(0); using(var different=new SqlCommand("INSERT INTO ID,Name,Surname from Student (SELECT ID,Name,Surname from ##mytemptable except SELECT ID,Name,Surname from Student)),connection) MessageBox.Show("Different Information is added"); } else { <pre>MessageBox.Show("Different Information has no value.So not added.");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)