ExecuteNonQuery方法使用舉例

 string updateQuery=“UPdate student Set sName=‘小李’”+”Where ID=‘200131500145’”;

SqlConnection conn=new SqlConnection( );

conn.ConnectionString=connectionString;

SqlCommand cmd=new SqlCommand(updateQuery,conn);

conn.Open( );   

int RecordsAffected=cmd.ExecuteNonQuery( ); conn.Close( );