C# And SQL Server. Why Select Can Transac But Insert ?

string connectionString;


string queryString;


SqlConnection sqlconnection;connectionString="server=fatyi;integrated security=SSPI;initial catalog=tempdb";


queryString="insert into products values(5,'BaoMa',200596,900000,0)";


sqlconnection=new SqlConnection(connectionString);


SqlCommand addScorce=new SqlCommand(queryString,sqlconnection);


sqlconnection.Open();


addScorce.ExecuteNonQuery();


sqlconnection.Close();





help to find out why? if i use "select" it can transaction in this code. And here "insert" .My WebAplication could work,but have no result of "insert".and no error information.The "insert" purview of "products" table have selected.


I help you can help me to point out maybe where is error.


Thank you !